show image from blob mysql

Question

Hi I have a image table in my database. These are stored as blob along with details such as image type & name.

I am having a problem showing the image, all I get is a white box with a red cross in it. code:

<?php

include '../connection.php';

$ID = $_GET['id'];

$query = "SELECT * FROM `images` WHERE `image_id` = '$ID'";

$result=mysql_query($query);
$row = mysql_fetch_array($result);

$image = $row['image'];
$image_type= $row['image_type'];   

header("Content-type: $image_type");
print $image; 

exit;

?>

Thanks

What is stored in db ? How ? Do you know that blob type is limited to 64k ? — Boris Guéry, May 25 '09 at 16:48
the actual image is stored as blob in the database the rest of the data is varchar. The image shows as [BLOB - 64.0 KiB] in the db — Elliott, May 25 '09 at 16:50
Are the pictures uploaded and stored in your db less than 64K ? Are the image type is a correct mime type like image/png or image/jpeg ? — Boris Guéry, May 25 '09 at 17:03
Change the type. Upload a new image, and try with it. With JPG compression, if the file is not complete, you'll error while displaying. — Boris Guéry, May 25 '09 at 17:13
I also saw in a comment that you mentioned a 'image/pjpeg' type. It could be a reason of the error, i heard that IE doesn't support this mime type — Boris Guéry, May 25 '09 at 17:15

Boris Guéry · Accepted Answer · 2009-05-25T18:45:07.723

3

Well here is a short answer.

<?php
include '../connection.php';
$id = (int)$_GET['id'];
$query = "SELECT * FROM `images` WHERE `image_id` = '$id'";

$result=mysql_query($query);
$row = mysql_fetch_array($result);

$image = $row['image'];
$image_type= $row['image_type'];
$size = $row['image_size'];
//alternative
/* list($image, $image_type, $size) = array(
                                       $row['image'],
                                       $row['image_type'],
                                       $row['image_size']
                                      );
*/
$ext = explode('/', $image_type);
$name = $id . '.' . $ext[1]; 

header("Content-type: $image_type");
header("Content-length: $size");
header("Content-Disposition: attachment; filename=$name");

print $image;     
exit;

Check your blobtype to be a least MEDIUMBLOB which is able to store data up to 16M

edited May 25 '09 at 18:45

answered May 25 '09 at 16:51

Boris Guéry

47,316
8
52
87

I have added them , and also changed it to MEDIUMBLOB but still the same. – Elliott May 25 '09 at 17:02
1

The Content-Dispostion header should only be used for downloads. It should not be used for sending the image for a tag. – Jon Benedicto May 25 '09 at 17:03
Hi I have tried this...and it tries to download a file called 4 – Elliott May 25 '09 at 17:21
update - in firefox I get the error The image /view_image.php?id=4” cannot be displayed, because it contains errors. – Elliott May 25 '09 at 17:23
I fixed some errors in the code. Btw, the filename should be 4.jpeg or even 4.pjpeg Try, var_dump($row); to see what you get from the db. – Boris Guéry May 25 '09 at 17:34
Thanks I now get:
Warning: filesize() [function.filesize]: stat failed for 4.pjpeg in /home/""/public_html/""/images/view.php on line 13< Plus alot of un-readable coding. – Elliott May 25 '09 at 17:39
tested in firefox..it downloads file called 4.pjpeg but cannot be opened – Elliott May 25 '09 at 17:42
humm mea culpa, filesize is used to check a the file size. You should store the size of the file when uploading it, you should be able to this by using the function above on the temp file. – Boris Guéry May 25 '09 at 17:46
I store the filesize when uploading this is in the row image_size – Elliott May 25 '09 at 17:51
I did this and the page tried to download 4.pjepg as a html doc. – Elliott May 25 '09 at 18:51
it tried to download the jpeg image...but it was shown as a pjpeg file type, which could not me opended. – Elliott May 25 '09 at 21:50

score 1 · Answer 2 · answered May 25 '09 at 17:06

1

To debug this, I'd suggest commenting-out the Content-type header line, then hitting the url directly in the browser. This will allow you to see any errors, warnings or notices that PHP might be emitting.

answered May 25 '09 at 17:06

Jon Benedicto

10,492
3
28
30

score 0 · Answer 3 · answered Jun 03 '14 at 18:52

0

Or if you don't want to create a separate php file, you can inline it

<?php
// retrieve blob into $img
?><img src='data:image/png;base64,<?php echo base64_encode( $img );?>' alt='Image <?php echo $id;?>'>

answered Jun 03 '14 at 18:52

Jeff

2,095
25
18

Andomar · Answer 4 · 2009-05-25T16:58:00.080

0

That looks like it might work, what's going wrong?

Try to specify the fields explicitly:

 SELECT image, image_type FROM ...

What happens when you run the query from the database?

Are you loading the image like:

<img src="image.php?id=12">

Or do you load the PHP as its own page?

edited May 25 '09 at 16:58

answered May 25 '09 at 16:50

Andomar

232,371
49
380
404

I load the image on its own page such as view_image.php?id=2 I get no errors from the query but running in Firefox I get the url shown in the page. but in IE I get a pic box with red cross? – Elliott May 25 '09 at 17:00

score 0 · Answer 5 · answered May 25 '09 at 16:56

Couple of things to try

maybe something is failing and it is returning an error msg in html instead of the expected image
is the content_type stored correctly in the database or are you just storing the file extension of the image

content-type should look something like this

image/gif 
image/jpeg

score 0 · Answer 6 · answered May 25 '09 at 17:01

0

maybe you could try

$row = mysql_fetch_assoc($result);

instead of

$row = mysql_fetch_array($result);

answered May 25 '09 at 17:01

bumperbox

10,166
6
43
66

I think by default, mysql_fetch_array will store both the numbers and the names, so both $row[0] and $row['columnname'] are valid – Andomar May 25 '09 at 17:05

score 0 · Answer 7 · answered May 25 '09 at 17:41

0

You said in a comment that the table initially said "[BLOB - 64.0 KiB]" but you then changed it to "MEDIUMBLOB". This will expand the size that you can store, but all of your existing data will still be truncated to 64KiB.

Make sure that the field type you use is large enough to store the data you want to store (16mb in a MEDIUMBLOB or ~4gb in a LONGBLOB I'm pretty sure) and then re-insert all of your data.

Other than the security problems mentioned, I don't see why the code shouldn't work other than the database problem.

answered May 25 '09 at 17:41

Drakia

279
1
3

I have done this and re-uploaded an image, now being shown as [BLOB - 369.9 KiB] – Elliott May 25 '09 at 17:45
Does it show properly on the page when you visit it now? (Using the code in your original question). I tried that exact code out and it seemed to work fine (Using a jpeg, not a pjpeg though) – Drakia May 25 '09 at 19:08

show image from blob mysql

7 Answers7

Linked