Get Directory contents and put them in mysql

[DigitalExpl0it]

Im trying to figure out a way to have a php script (when ran) look into a certain directory and look for only .midi files. When midi files are found I want to beable to insert just the name of the file inot a database.

like test.midi should be in a mysql database in a field like file

though Id like the directory name with it also, which wouldnt be hard to add later like

80/test.midi

though Im not to sure on how to go by this. Any help with be helpful, thanx

[DigitalExpl0it]

<?php
$directory = "/home/test/www/wml/midi";
if ($handle = opendir($directory)) {
    echo "Directory: $directory<br>Files:<br>";

/* This is the correct way to loop over the directory. */
while (false !== ($file = readdir($handle))) { 
    echo "$file<br>";
}

closedir($handle); 
}
?>

I found this little script that will list the contents in the directory. Now I have them posting and when I veiw the data it works fine only that its showing the

. and .. directorys. though how would I strip those out without stripping out the . in the extention of the file name like test.midi

Couldnt I just put in a insert statement in this script in here

    while (false !== ($file = readdir($handle))) { 
        echo "$file<br>";
    }

[devinemke]

$handle = opendir ('/home/test/www/wml/midi');
while (false !== ($file = readdir($handle)))
{
if ($file != '.' && $file != '..') {echo "$file<br>";}
}
closedir ($handle);

[DigitalExpl0it]

hey thanx

[DigitalExpl0it]

I found how to do it 🙂

if anyone wants it to make a simple indexing site script here you go.

<?
$handle = opendir ('/home/test/www/wml/midi/80');
while (false !== ($file = readdir($handle)))
{
if ($file != '.' && $file != '..') {
//Check new entry against records in db
$filter = $file;
$filter = "midi/80/$file";

$connect = mysql_connect("localhost", "test", "test") or die ("Couldnt connect");
$db = mysql_select_db("test", $connect) or die ("Couldnt open Database"); 
$check_query = mysql_query("SELECT * FROM wml WHERE wml_text='$file' AND wml_link='$filter' ");
if (mysql_num_rows($check_query) == 0) {

//Do insert only if record does not yet exist
$query = mysql_query("INSERT INTO wml (wml_text,wml_link,wml_cat) VALUES ('$file','$filter','80')");
echo "Merging into Database: $file<br>";
} else {
echo "Already in Database: $file<br>";
}
}
}
closedir ($handle);
mysql_close($connect);
?>

have fun