Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Change mysql extensions
Change mysql extensions [message #1925] Sat, 22 September 2007 06:43 Go to next message
carefree is currently offline carefree
Messages: 2
Registered: September 2007
Junior Member
I want to allow people to download videos off my site.

But the uploaded extensions all end in .mpg .avi etc

Basically want to still get the video name - {$answers[i].videoname}, but change the last extension from whatever to .zip.

Can this be done ??


<a href="{$baseurl}/video/{section name=i}{$answers[i].videoname}{/section}">
Report message to a moderator
Re: Change mysql extensions [message #1926 is a reply to message #1925 ] Sat, 22 September 2007 09:24 Go to previous messageGo to next message
allworknoplay is currently offline allworknoplay
Messages: 58
Registered: September 2007
Location: New York
Member
What does this have to do with mysql?
Report message to a moderator
Re: Change mysql extensions [message #1927 is a reply to message #1925 ] Sat, 22 September 2007 09:28 Go to previous messageGo to next message
carefree is currently offline carefree
Messages: 2
Registered: September 2007
Junior Member
Because the information is within mysql tables
Report message to a moderator
Re: Change mysql extensions [message #1928 is a reply to message #1927 ] Sat, 22 September 2007 10:38 Go to previous message
allworknoplay is currently offline allworknoplay
Messages: 58
Registered: September 2007
Location: New York
Member
carefree wrote on Sat, 22 September 2007 09:28

Because the information is within mysql tables


You can just change the output to the end user dynamically, or change the extension before it goes into mysql...

.mpeg = .whatever to end user
then as they try to download it
your front end script changes it
back to .whatever to .mpeg
Report message to a moderator
Previous Topic:Are rows or fields stored in the INNOdb Buffer?
Next Topic:A table with a negative size in innoDb and concurrency troubles! Are my data safe?
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Thu Jul 9 19:15:16 EDT 2009

Total time taken to generate the page: 0.02610 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.