display image from MySQL blob

[jherzens]

I am trying to put a section on my website which will allow users to upload their images to be displayed in a gallery. What I wanted to do was let them upload the file, and just store the location in the database, but my server uses safe mode and I can't do that.

Anyway, I decided to put the files into a blob field, but when I display it, I just see the massive character string, not the image itself. How do I convert it back into an image?
Alternately, is there a way to tell the server to put the uploaded file directly into my web directory? (Keeping in mind that I can't access any of the ini files, I would have to do this with my code.)

[toma42]

RTFM. http://www.php.net/manual/en/function.header.php

Strait from the comments on that page:
by [e-mail]
For inline images (JPEG for example):

header('Content-Type: image/jpeg');
header('Content-Disposition: inline; filename=file.jpg);

For attachments (Adobe PDF for example):

header('Content-Type: application/pdf');
header('Content-Disposition: attachment; filename=file.pdf);

NOTE: In Internet Explorer, the Content-Disposition header is important, otherwise it will be inline. 'Content-Disposition: attachment' will ALWAYS make IE download it.

NOTE: In Netscape, if you want to force it to be a download (i.e. not inline), use header('Content-Type: application/octet-stream').
Netscape doesn't appear to care about the Content-Disposition header apart from when it's in an email message, then the header controls behaviour as expected.

It's best to be specific about the file you're sending. Don't rely on the interpretation of the browsers in the face of missing or default headers.

Content-Length is good to set for downloads, since it will allow the browser to show a progress meter. It has to be accurate otherwise the browser will stall in downloading

[Sphynx]

Take a look at this article...
http://www.phpbuilder.com/columns/florian19991014.php3

🆒