blob image - rotate image - save in mysql again - How to ???

[khunjack]

Dears,

I have images in mysql (blob).

Some of the images need to be rotated (90 degrees).

 

Not sure how to do it.

Do I have to physical write the image?

(I did that and was using 'imagerotate' -> image rotated, but couldn't manage to store the rotated images back into mysql.)

Can the blob be rotated??

 

Any hints/suggestions are very welcome.

 

Thanks a lot

Jack

[khunjack]

PS:

 

The image is on the server root .... the issue is to store it back into mysql

Thanks

[Mchl]

What is your code? What are the errors you get?

[khunjack]

Mchl,

Thank you for your reply.

 

$aRow = $this->getPicture($sPicId);

.

 

$src = @imagecreatefromstring ($aRow["Bin Data"]);

$image = imagecreatetruecolor (...);

imagecopyresampled (...);

.

.

$rotate = imagerotate($image, $degrees, 0) ;

imagejpeg($rotate, $imagename2) ;

 

now I have the rotated pic in '$imagename2' in the server root

 

 

Up to now could not manage to store the rotated image back into mysql.

 

Tried a few things, honestly I don't have a glue, e.g. stored the $rotate, $imagename2 in the blob ["Bin Data"] field... etc...

 

Thank you

Jack

 

 

[Mchl]

What did you try?