Page 1 of 1

How to store audio and video files for search & manipula

Posted: Mon Sep 10, 2007 9:23 pm
by krraleigh
My church presently has about 40 some odd links to audio and video files on one page.
I would like to dump them into a file or database so that I can pull the last
5 files according to date created and display them on the webpage automatically.
I could then have an upload page so that the files can be uploaded and I won't
have to constantly keep updating the display page.

Can you advise me on how I might do this?
I don't see anyway to store this type of data in a mySQL database
so how do I create this setup? Do I store file paths? :?:

Kevin

Posted: Mon Sep 10, 2007 9:41 pm
by s.dot
Yes, store the path to the file on the server.
Use an auto_increment primary key on a field called id

To display the most recent 5

Code: Select all

SELECT * FROM `tablename` ORDER BY `id` DESC LIMIT 0, 5

Posted: Tue Sep 11, 2007 8:32 pm
by krraleigh
I tripped over the answer

Use blobs

http://www.onlamp.com/pub/a/php/2000/09 ... mysql.html

Thank You
Kevin

Posted: Wed Sep 12, 2007 1:05 am
by Rovas
scottayy wrote:Yes, store the path to the file on the server.
Use an auto_increment primary key on a field called id
This is the best method because the server has a faster response time than using media files embedded in the database.

Posted: Wed Sep 12, 2007 7:33 pm
by krraleigh
Thank You
Kevin