Dears,
I have images in mysql (blob).
Some of the images need to be rotated (90 degrees).

and restored in mysql.

Any hints/suggestions are very welcome.

Thanks a lot
Jack

Don't ever store big files (such as images) in a database (it's devilishly inefficient), instead just put the location of the file on the server (http wise).

To rotate the image take a look at this:
http://php.about.com/od/gdlibrary/a/rotate_image_gd.htm

If you really want to stick your image in the Database, just store the data from the string in the database field value.

Make use of GD library and the jpgraph

Thanks for the reply.

I don't have the problem to rotate the images and display.

The problem I have to save/overwrite the image back to mysql record.

e.g.:
imagecreatefromstring (..);
..
$img = imagerotate($image, $degrees, 0)
imagejpeg($img, $img_rot)

How to get $img or $img_rot back into the the db record ???


Thanks for any help.
Jahn

BTW: I have ~ 100 000 images in the database, it works very well, images are sized to fit the surfers display.