Doesn't show blob image in php from mysql db

Question

Can someone help me with this code? The problem is it doesn't show the image but this weird stuff: OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOÿÀx !ÿÄ¢ }!1AQa"q2‘¡#B±ÁRÑð$3br‚%&'()*456789:CDEFGHIJSTUVW

Here is my code:

 <?php
//mysql connect database
mysql_connect('localhost','root','password') or die(mysql_error());
mysql_select_db('database') or die(mysql_error());
$res=mysql_query('select * from img');
while($row=mysql_fetch_array($res))
{
echo "<div id='image'>";
echo "<p/>";?> <img src="<?php echo $row['image'];?>" height='300px' width='468px'>";<?php
echo "<p/>"; echo $row['name'];
echo "</div>"; 
}
?>

Please see this answer here. The blob is a binary file type. — Ohgodwhy
– Ohgodwhy, Commented Aug 28, 2014 at 18:59
possible duplicate of Php : Convert a blob into an image file — Biswajit Maji
– Biswajit Maji, Commented Aug 28, 2014 at 19:01

Marc B · Accepted Answer · 2014-08-28 19:01:34Z

2

<img> expects a URL pointing at where the image file is. You're trying to dump the raw binary garbage of the image into that image tag. That garbage will naturally contain " and > chars in it, and "close" your img tag, letting the rest of the garbage be treated as plain text.

You either have to serve up your image via separate script, e.g.

html:

<img src="pic.php?id=foo">

php:

header('Content-type: image/jpeg');
echo get_blob_from_database($_GET['id']);

Or embed the image inside the html properly:

<img src="data:image/jpg;base64,<?php echo base64_encode($row['image']); ?>">

And neither of these is particularly a good solution. Storing images directly in the database is almost never a good idea.

answered Aug 28, 2014 at 19:01

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

Comments

Shen Siddharta · Accepted Answer · 2014-08-29 07:34:16Z

0

it's better to save your images in folder rather than save in blob format

you can save the file name in database table and save the images in folder

when you call the filename, you can combine it with src from and get the content

answered Aug 29, 2014 at 7:34

Shen Siddharta

507 bronze badges

Collectives™ on Stack Overflow

Doesn't show blob image in php from mysql db

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related