[Resolved] converting directories of images and adding them to mysql

fr8

Im working on a photo gallery project of my own. Before I begin id like to say im not looking for premade scripts aka hotscripts.

Im using ImageMagick for all of my photo manipulation. Currently I have finished a script that will convert a single picture into a thumbnail and also add a watermark in the corner of the original image.

Now im stuck on how to do this to the entire directory of images.

I have an idea of how to do it but i cant seem to find the commands i need. right now for the script to work the image has to be in the same directory.

my current thumbs script is:

$image = "FileName.jpg";
$cmdthumb = 'convert -quality 65 -scale 80x80 '.$image.' THUMB.'.$image.' ';

exec($cmdthumb);
?>

and one other thing is how should i add this to my database (mysql). I know it would be someing in the nature that when the $image name is found that it would be added to the database along with its path. And when it is added to the database should i have all of the images in the same table (200,000+)? or should i have a sperate table per photoset?

bad76

Originally posted by fr8
...I know it would be someing in the nature that ...

in the nature 😃 fun :p ...

This natural element is the dir. Look the manual for opendir() and you'll find here an how-to read a dir.

Put your code in a function and call this function for each entry in dir.

To put in a db, you first have to setup a table, link to this table at beginning of script, and for each convertion do any insert...

For more help try to give me the field list of db...

see you

[edit] using one or more tables is just personal think. My hint is to use single table with field "photoset" ...

fr8

that was it. opendir() worked like a charm. with a little reading into readdir() and mucking those "." and ".." directorys and i was set.

Now concerning the database. i have the insert setup in the loop so with each conversion the info is added to the database. But im concerned with having 200,000+ rows in a table. i know i could pull the photosets by adding a photoset collum to the table. But im concerned with the strain that will put on my sever. or will there be one? am i wrong?

fr8

oh and my field info.

my current one is:

iid | imagename | dirname |

now when i pull from this my img src is like so

echo "<img src=\"photos/".$dirname."/Fullsize/".$imagename."\">";
echo "<img src=\"photos/".$dirname."/Thumbs/".$imagename."\">";

EDIT: The $dirname is the photoset id. probly easy to see that. just wanted to state it in case it wasnt.

bad76

Well,
the problem is the naviagation you want.
Can your user search any subject in more photoset?
If yes, with more table you have to do more select (one for table you make...). It's the only big difference.

However, after the exec($cmdthumb); instruction, you can do:

insert into $dirname values(0,'$imagename')
or
insert into mytable values(0,'$imagename','$dirname')

see you

fr8

Originally posted by bad76
Well,
the problem is the naviagation you want.
Can your user search any subject in more photoset?
If yes, with more table you have to do more select (one for table you make...). It's the only big difference.

However, after the exec($cmdthumb); instruction, you can do:

insert into $dirname values(0,'$imagename')
or
insert into mytable values(0,'$imagename','$dirname')

see you

What i did was associate the pid with the table that contains the information. that way if you did a search it will give you the information and the pid will be the same for when you want to open the gallery.