Add filenames to db.

[Anon]

Sorry for the double post!
Greetings, all. I have a directory with images, of which I need to place the file names in a column in a MySQL db. There are two files for every image:
image.jpg and image_t.jpg (the thumbnail for image.jpg)
What I would like to do is strip the file extension (as well as the '_t.jpg') from the filenames, and just enter the 'root' filename (image). This way I have only one db entry per image.

Can anyone help me with this?
Thanks!!
Dale.

[Anon]

This should serve your purposes

<?php
//Make sure this is the path to your image directory
$path = "/www/something/images";
chdir($path);
$dir = dir(".");
$dir->rewind();
while ($file=$dir->read()) {
if (!ereg("_t", $file) && !is_dir($file)) {
$filelist[] = $file;
}
}
$dir->close();

while (list ($key, $value) = each ($filelist)) {
$imagename = explode(".", $value);
$strippedimagename = $imagename[0];

$result = mysql_query("INSERT into tablename (imagename) VALUES ('$strippedimagename')", $db);
}
?>

-Freddydoesphp

[Anon]

Hell ya!

Thanks, man- it worked great... I'm building my own photo repository for a website that is all php/mysql, and this is the one element that I needed...

Thanks for your time, and effort!!!

Dale.
admin, www.live2ride.net