At 12:01 PM -0400 4/8/06, Nicholas Couloute wrote:
On my website http://www.sidekick2music.com ! I use scandir() [php
5.0] to fetch all the files which are all in subfolders of this one
folder. like this:
public_html/amrs/$cat/$author/*.amr
$cat = different catergoried of music
$author = Authors of the particular catergory
This way isn't fast when you have over 5,000+ files.
I use flatfile for everything on the site!
site: http://www.sidekick2music.com
Would it run faster if I used mysql?
How would this be done?
Is there another way when dealing with files and organizing them? CMS?
Nicholas:
You certainly can use MySQL to store the url's to the sound files OR
the sound files themselves -- MySQL can handle both ways and both
ways have their advantages and disadvantages.
However, in either event, using MySQL is in my mind a preferable
method of organizing a large data set.
You'll need to set up a MySQL database, with a table containing the
name, catalog, artist, and whatever else you want. Then you'll need
to enter the data and finally set up your web site to dynamically
access the dB and pull out what the user wants. I've done this with
several sites, but I charge.
However, it's certainly something that you can receive free help from
this list.
tedd
--
--------------------------------------------------------------------------------
http://sperling.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
