PHP fetch images stored on database

Question

I manually inserted a image in longblob field named image ...the image is .gif so i entered mimetype as 'image/gif' but it isn't working??

 $result=mysql_query("SELECT image FROM page WHERE number=$ide"); while($image=mysql_fetch_array($result)) { header('Content-type:'.$image['mimetype']); echo $image['image'];

Please help it is showig some random binary text instead of the image it also says undefined index mimetype have i done something wrong in defining it ???

edit-i changed the mimetype to image/gif but the image isnt cropping up still — kshitij
– kshitij, Commented Sep 1, 2011 at 11:07

Treffynnon · Accepted Answer · 2011-09-01 11:01:05Z

3

You need to get the mime type in your SQL query like so:

$result=mysql_query("SELECT image, mimetype FROM page WHERE number=$ide");

The mimetype should be image/gif

answered Sep 1, 2011 at 11:01

Treffynnon

21.6k6 gold badges68 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

kshitij Over a year ago

did that ..the error notice didn't come but the image also didn't show up.the page is blank?@Treffynnon

Treffynnon Over a year ago

Sounds like the image data might have been corrupted when you inserted it into the database. If you do a diff on the data and that of the original image file is it any different?

Collectives™ on Stack Overflow

PHP fetch images stored on database

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related