Image Downloads From MySQL

williamlmahan

I've been beating my head against the keyboard on this one....I know I've done it before, though with Perl.

What I want to do is download and display images stored in a MySQL database. I've tried everything i could think of, but below is where I am at now (simplicity)

[INDENT] ob_clean();
$file_contents = $row[file_contents];
$size=count($file_contents);
header("\"Content-type: " . $row[file_type] . "\"");
echo $row[image];
[/INDENT]
😕

jib0

To display an image stored in a database, use this:

$im = imagecreatefromstring($data);
header("Content-Type: image/jpeg");
imagejpeg($im);
imagedestroy($im);

williamlmahan

I appreciate the try, but the code you included did not work, so I'm still at a loss, with my hair thinning more and more each day.

Code suggested:

$im = imagecreatefromstring($data);
header("Content-Type: image/jpeg");
imagejpeg($im);
imagedestroy($im);

mwasif

Checkout this small post to display images from MySQL.

jib0

It may depend on how you stored your images in the database. Personally I always used file_get_contents to store the data and imagecreatefromstring to display it. I use the code that I posted...$data is the one stored in the DB in a BLOB field and this code is in a single file with nothing else (no echo or other characters before the <?php. After that you should call this file in the image tag <img src="file.php" />.
I never tryed the example give by mwasif but it looks quite similar except that it encodes (base64) the data before inserting it. I'm not sure it is the best solution since base64 encoding uses 33% more space than the original data.
I hope this helps.