Trouble Getting File Name Values

[PhilipK]

Here is my problem I have a folder with 2500 image files. I need to get all of the file names into a MySQL database.

 

Writing them in manually is not an option!

 

Any suggestions?

[PFMaBiSmAd]

glob

 

 

[PhilipK]

Short and sweet...

 

Thank you very much!

[PhilipK]

Hey sorry but I'm still having a bit of trouble.

 

Here is what I have so far...

 

$images = glob("images/{*.jpg,*.gif,*.png}", GLOB_BRACE);
print_r($images);

 

How can I edit the code I have here to use INSERT INTO instead of print_r.

 

Thanks and sorry for the noob questions!

 

[PFMaBiSmAd]

Assuming you want one row in your table for each filename, I would use array_chunk to break the list of files down into reasonable size chunks of around 500 files each. Then I would loop over those chunks and implode each group into a multi-insert query.

 

$chunks = array_chunk($images, 500); // break into reasonable size pieces
foreach($chunks as $chunk){
$imp = implode("'),('",$chunk); // implode the data to make a mulit-insert query
$query = "INSERT INTO your_table (file_name) VALUES ('$imp')";
//echo $query . '<br />';
mysql_query($query) or die(mysql_error());
}