3 replies to this topic

[amir2000]

Hi All,

Is there any way to update / insert a lot of files (photos) to mysql database?
I have a lot of photos on my website and I want to enter all into database.


Thanks,

Amir

[DarkLordofthePenguins]

What exactly is it that you're trying to do? Are you asking how to automate the process of inserting records?

[Alexander]

You can use glob() to fetch an array of image names and then join()/implode() them into the database query.

A simplistic example. This assumes you had set up a simple table with autoincrement and the table is named "photos":

$photoarray = array();
foreach (glob('/photos/*.jpg') as $filename) {
    $photoarray[] = "'$filename'";
}

$sql = "INSERT INTO photos VALUES (" . join(',', $photoarray) . ")";
$result = mysql_query($sql);

[amir2000]

sorry but is it possible to explain a bit more about your suggestion?