Problem loading images to MySQL

asolell

Hi All,

I'm encountering an odd situation.
I'm uploading images to my site,.. playing with using ImageMagick.. So far...that works like a charm.
Now.. the second step is..saving the images to the MySQL database.

Well.. if you glance at the code below.. you will see the the
first image being processed fine.. and then preparing it for the database,.. then comes the second image.
Identical processing.

I have about 6 images like that.. in each record.
Running the code works fine.. No complaints from the database.

Now comes the weired stuff.
I can only extract the first image.
The rest of the images are getting currupted (on the load to the database. On the server they are created just fine and are viewable via the web - the newly processed images).

So the question is.. why is that happening? How do I get the images to load correctly and clean into the database. The first image ALWAYS loads fine!

///// AAAAAAAA - Image - In More Pictures - White Background
$cmd="${root}/home/soft/bin/run_from_nochroot composite -gravity center -size 500x500 -geometry 500x500 +profile \'*\' -sharpen 0x1 'temp12/ORIGINAL.$date.$rand.$type' -size 500x500 xc:white temp12/Image.$another1.jpg";
exec("$cmd 2>&1");

$filename = "temp12/Image.$another1.jpg";
$fd = fopen ($filename, "rb");
$Image = addslashes(fread ($fd, filesize ($filename)));
fclose ($fd);

////// BBBBBBBBBBBB - ImageMediumGalleryBlack - Black Background

$cmd="${root}/home/soft/bin/run_from_nochroot composite -gravity center -size 96x96 -geometry 96x96 +profile \'*\' -sharpen 0x1.5 'temp12/ORIGINAL.$date.$rand.$type' -size 96x96 xc:black temp12/GalleryBlack.$another1.jpg";
exec("$cmd 2>&1");

$filename = "temp12/GalleryBlack.$another1.jpg";
$fd = fopen ($filename, "rb");
$GalleryBlack = addslashes(fread ($fd, filesize ($filename)));
fclose ($fd);

.... <same stuff goes more here>...

    $sql   = "INSERT INTO Images (	Id, 
									Views, 
									Format,
									Image,
									ImageMediumGalleryBlack,
									ImageMediumGalleryWhite,
									ImageMediumShowRoomGrey,
									ImageMediumShowRoomWhite,
									ImageMediumShowRoomGreenHilite,
									ImageMediumCarDetail) 
				VALUES ($newid, 
						0,
						'$File_type',
						'$Image',
						'$ImageMediumGalleryBlack',
						'$ImageMediumGalleryWhite',
						'$ImageMediumShowRoomGrey',
						'$ImageMediumShowRoomWhite',
						'$ImageMediumShowRoomGreen',
						'$ImageMediumCarDetail')";

Thanks for your help

-Alon.

js@wsco.com

asolell

up.

psyjoniz

are you trying to do this just to see how it works or are you actually planning on putting your images inside your DB?

asolell

I actually have a whole system in place that works fine.
I used to work with pnmscale on my previous server and now
I've moved to a new server where I'm working on a revised system and using ImageMagick instead of pnmscale.
The system is fast enough for my needs and Yes... this is for
real live website. The code listed here is from my temp file that once it works,.. will be clean a bit and be put into production.
No theory questions here...:-))
This is the real thing.

I know plenty here are advising against puting blob and other
images into the database,.. but sorry,.. I'm planning on thousands of images (not necessarily with the need for ultra speed), but this will hold a big archive of images.
I'm comfortable with the database settings.. just trying to make it work!

Someone suggested that I should reset some variable that is probably doing something it shouldn't.

The code as you see it.. is litterally the code I'm using to create the first and second images.. the rest of the images are repetative code (obviously with the respective variable names).

The first image is stored fine.. but the second image is already failing.
Since this is the real code.. there is nothing in the code between AAAAAA and BBBBB other than what you see posted here.
If there is a need to reset any variables for BBBBBBB.. I would appreciate to know what it is.

Thanks,

-Alon.

robsgaming

this probably doesn't help you any but maybe ... i found a script a long time ago that stores images as binary data in mysql.. some tutorial crud i found that i used to use, and whata ya know its right here on phpbuilder:

http://www.phpbuilder.com/columns/florian19991014.php3

sorry if that doesn't pertain to anything you were asking about..

asolell

Thanks for the link.
I've checked it and unfortunatly it is already code that is covered within my code. It uploads a single image into a database (which is working for me fine),.. but my problem is with the second and beyond image.

I appreciate the effort.

-Alon.

asolell

Issue has been resolved.

Silly me!
If you view the code you realize that the Insert values are not the same name as the file handler with the exception of the first one. No wonder it didn't work. It has nothing to do with the Images themselves.. it was all a matter of using the wrong variable names.

Thanks for all those that tried to help me.

-Alon.