Directory (array) PHP + Mysql

Anon

I'm hoping someone can help me out - I've been searching the forums, but to no avail to find an asnwer to this question. What I am looking to do is to use PHP to populate a MySQL database with directory information.

Specifically, I have taken all of my CD's and encoded them into MP3's and they reside on a central server. They are organized into the following format:

/mp3/[artist]/[album]/[track]-SongTitle.mp3

What I want to be able to do is point to a basedir (i.e. F:/mp3) - and have the php script do a recursive directory search such that it populates an array, which subsequently populates a MySQL database. The different parameters I would like are for the array to know that the first directory is the artist, 2nd is album, 3rd is the song title (stripped of it's .mp3 for storage in the db) -

Is this incredibly difficult to do? I've b een reading a ton, and seem to be at a wall..

Thank you!! Mike

nashirak

since you are using a *nix enviroment. (I assume from the /mp3/... style) then you could do something kinda dirty.

You could use the locate program to look for all .mp3's then pipe the output to a file and read from the file. I say dirty cause you might have stray mp3s or something.

Ex:

// Run locate and pipe it into a file
exec("locate .mp3 > mp3.out");

$mp3s = file("mp3.out");
$i = 0;

while ($i < sizeof($mp3s)) {

// Seperate each line into aritst etc...
$parsearray = explode("/",$mp3s);

$artist = $parsearray[1];
$album = $parsearray[2];
$trackmp3 = $parsearray[3];

// Explode again to seperate the Track number and song

$blaharray = explode("-",$trackmp3);

$tracknumber = $blaharray[0];

// lastly lop off the .mp3

$songtmp = explode("."$blaharray[1]);

// Put in the name of the song with no .mp3
$songname = $songtmp[0];

// then you have all your parts so do database stuff

Database.........Input....

// Remember to up the flag
$i++;

}

As I said this is kinda a dirty way to do it and you might get file that dont need to be in there, so be careful. Oh fair warning I havent tested this code so dont take it as Bible. 🙂
Hope that Helps!

Anon

Thank you for your help -

Unfortunately, I am running on a Win2000 Apache server machine -

Any ideas for that type of a setup?

Thank you!!

Mike

Anon

If I were to substitute:

exec("find * .mp3 > mp3.out");

for

exec("locate .mp3 > mp3.out");

that seems to run the DOS command equivalent of locate - the problem is that it does not seem to recuse the subdirectories... only runs in the directory that it is executed in (i.e. f:/mp3)

Thanks! Mike

Anon

Hi. If i got your problem the right way, then you can use smth like this:

$root = 'F:/mp3';
$dir = opendir($root);
while ($artist = readdir($dir))
{
if is_dir($artist)
{
$art_dir = opendir($root.$artist);
while ($album = readdir($art_dir))
{
..............
}
}

}
Build such a hierarhical script, go the way down to the files, put in some mysql requests or array filling, and it would work.
Sure you'd better check for thee functions in manual - vars they get, results they return etc. My code is no scetch of Bible, too 🙂)