A way to add rows to a table for each file in a folder?

[membot]

I have a MySQL table for some photos (including columns like file path, caption, date, etc.), and I'm eventually making a PHP form I can use to upload photos and set the captions and whatever.

 

However, initially, I want to add around 100 photos, and I'm thinking it would be easier to upload them all by FTP and have some kind of script (which I would only use this once) that would add all the photos in that folder to the MySQL table. Only the file path column would need to be filled out with this.

 

I'm thinking this might not necessarily be a MySQL command or a PHP script, but I don't know anything about any other programming languages. Any help is appreciated.

[sunfighter]

After you copy your file with FTP use this:

<?php

$handle = opendir('PUT NAME OF YOUR DIR HERE');
while (false !== ($file = readdir($handle)))
{
    if ($file != "." && $file != "..")
{
        echo $file,'<br />';
    }
}
closedir($handle);
?>

 

It will list your files so you can check that it is correct. It list them without the . and .. that are in dir's.

 

Then change the echo line to write file names and path into your DB.

[fenway]

Yup, just missing the actual INSERT.

[dmirsch]

I can use this...however, is there a way to modify it so that if there are subdirectories, it will list those as hyperlinks so the code would run off of those if you were to click that link?

[fenway]

Clicking links has nothing to do with mysql.

[membot]

Thank you!