Resizing an image pulled from MySql

Anon

Hello,

I store my images in an long_blob in my MySql database. Now, I want them to be resized with "imagecopyresized" function, when I show them. The problem is that this function (exactly as the getimagesize()) does not take this. The function seems to need a file.

Ok, if I has to be a file, I create one. So I just create a file (with .gif extension let's say) where I write all the data from my database in it. Then the function sayz that this file wasn't a valid gif file.

What is wrong, does the image file need any extra coding to allow the function to recognize it ass a valid gif file.

Thanx a lot for help.

[deleted]

Maybe the image you wrote isn't a gif image but jpg?

Anyway, storing images in a database is a very bad move. Save them to disk instead. THen you can also save the thumbnails along with them and save a HUGE amount of resources.

Anon

The file is a gif for shure. Still, I need to save the images into my database. Otherwise I wouldn't have asked 🙂

[deleted]

Are you sure you write all the data to the file (not missing the last few bytes)
and are you sure you don't need to 'stripslashes' the data?

"Otherwise I wouldn't have asked 🙂"
Most people who store the images in the database are clueless about why they do it, they just think it's cool. That's why I always warn against it.

PS: the trouble you are having now just proves that storing images in a database is an extremely bad idea.