[Resolved] Storing image in db sometimes does not display afterwards

ysu

Ok, first of all I know I shouldn't do it. Client's request.

It does work, and stores the images in the database.
Seems to work fine.

The curious thing is, that sometimes the uploaded images don't display correctly. It depends on the image, not it's size or it's type. Those 'special' images are always bad, which makes a good solid base for debugging. :-)

As a start I saved the image into a file after loading (from db) and decoding it, and the saved image seems ok.
So the problem is at the display part...

Next: I've saved the image in a file just before displaying...again: ok. (displayable even in a browser)
So the only problematic code left:
echo ($data);
or
print($data);
whichever you like.

I've tried to empty the buffer just before, tried to buffer it all and output afterwards...nothing seems to help.

I was looking around if someone found something out on the matter, no luck so far. If any of you knows anything please don't hesitate to post it!

Thank you

btw, it's php5.0.4 / mysql4.1.10a/nt on an xp with apache 2.x - but it does the exact same thing on a linux server with some other versions...

I'm using base64 encode/decode at storing/retrieving the images.

sorry for the edit: title was misleading

Drakla

You don't need to base64 encode and decode to store the image, you can load it into your script, then use mysql_escape_string on it, then do a direct insert. And no, you don't use stripslashes when you read it back out.

Or you can load the file directly into the db like

UPDATE files SET data=LOAD_FILE($pathToFile) WHERE fileid=55

ysu

Ok, I'll try and see.
I seem to remember reading that the only safe thing is the base64 on binary data storage.

ysu

Well, after a good night's sleep it's all easier. ;-)
There was nothing wrong with the echo of course.

The headers got messed up with a mis-reported file size on upload. Switching off the header("Content-Length:xxx"); solved the problem...damn.

Lerned lesson: don't trust the getimagesize(); hehe