Read File Name and update Database ?

Mad_T

I have a folder with multiple sub folders..
In each folder there are multiple files and the files are of mixed type.

Is there any quick way in PHP to read all the folders and insert the file name including extension and the folder name into an MySQL DB ?

Ideally I need :

file.exe - filename
images - foldername
exe - extension

into three different fields.

I have several thousand files so doing it manually will be a pain !

Thanks

Mad_T

Got a bit further !!

<?

// directory path can be either absolute or relative
$dir = 'files/';
$sub = 'test';
$dirPath = $dir . $sub;


// Make a MySQL Connection
mysql_connect("localhost", "user", "pass") or die(mysql_error());
mysql_select_db("my_db") or die(mysql_error());


// open the specified directory and check if it's opened successfully
if ($handle = opendir($dirPath)) {

   // keep reading the directory entries 'til the end
   while (false !== ($file = readdir($handle))) {

  // just skip the reference to current and parent directory
  if ($file != "." && $file != "..") {
     if (is_dir("$dirPath/$file")) {
        // found a directory, do something with it?
        echo "[$file]<br>";
     } else {
        // found an ordinary file


	mysql_query("INSERT INTO table (folder,filename) VALUES ('$sub,$file)") or die("Insert Error: ".mysql_error());

	    echo "$sub / $file<br>";

     }
  }
   }


mysql_close($con);



   // ALWAYS remember to close what you opened
   closedir($handle);
}

?>

But I get an MySQL Insert Error... Why ?
Any way to make this start in 'files/' then recursively read all sub folders ?

Thanks

Res

If you could tell us what the error says we could help you much easier.

Also, echo out your query and see what you are passing MySQL, if you're missing a variable or it's an escaping issue it should be fairly apparent