Cannot display Image from database in php

Question

I am using smarty, mysql and I am just trying to display image. This is the error i am getting -

Resource interpreted as Image but transferred with MIME type text/html

My index.php file

<img src="http://localhost/admin/image2.php?id={$editWine[0].id}" width="150" height="260" border="0" class="bottle-img" id="smallImageWineEdit" />

My image2.php file

$id=$_REQUEST['id'];        
$sql="SELECT * FROM table WHERE id=$id";        
$result=mysql_query($sql) or die(mysql_error());
while($row=@mysql_fetch_assoc($result))
{
   echo '<img src="data:image/jpeg;base64,'.base64_encode( $row['image_data'] ).'" width="150" height="150" /> &nbsp';  
   echo $row['image_data'];                     
}

This echo inside while loop is working fine.

And when i inspect element and open this img link in new tab, Image is displaying. whereas its not displaying in current page.

Why do you double <img> tags in index.php and as output of image2.php? <img> tag from index.php expects content-type to be image, but you are sending back from image2.php html code with list of <img> tags with data-uris and not content-type image and image's binary code. — Cheery
– Cheery, Commented Oct 9, 2014 at 4:55
@Cheery. I was just checking whether image is displaying or not thats it. — user3918082
– user3918082, Commented Oct 9, 2014 at 4:58
So, it not displaying because you are not sending image back to browser. — Cheery
– Cheery, Commented Oct 9, 2014 at 4:58
I am calling my image2.php in index.php's <img> tag using id.. — user3918082
– user3918082, Commented Oct 9, 2014 at 5:02
you do not understand how http requests are working. look at the answer provided below. — Cheery
– Cheery, Commented Oct 9, 2014 at 5:06

Mithun Satheesh · Accepted Answer · 2014-10-09 05:12:33Z

1

Issue is that you are again delivering the html tags from the image file. You just need to output the image data with proper image content-type.

Edit image2.php like

if($row=@mysql_fetch_assoc($result))
{
   header('Content-type: image/jpg');
   echo $row['image_data'];
   exit();                   
}

update to comments below

Do the above changes and request http://localhost/admin/image2.php?id=VALID_ID_HERE in browser and check if its retuning an image. Then you can use it in the src tag of index.php to show it there. If you get errors in rendering the image, whn you request it, make sure you are asking for the correct image id in the db and update the question with the error messages you are seeing.

edited Oct 9, 2014 at 5:12

answered Oct 9, 2014 at 4:58

Mithun Satheesh

27.9k14 gold badges80 silver badges103 bronze badges

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

2 Comments

user3918082 Over a year ago

Thanks.. i tried.. but i wanted to display my image in index.php.

Mithun Satheesh Over a year ago

image.php? there are only image2.php and index.php in your question? which file you are refering to?

Collectives™ on Stack Overflow

Cannot display Image from database in php

My index.php file

My image2.php file

1 Answer 1

update to comments below

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

My index.php file

My image2.php file

1 Answer 1

update to comments below

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related