0

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>"; 
}
?>
smovie9
  • 788
  • 1
  • 8
  • 16
  • [Please see this answer here](http://stackoverflow.com/a/6273415/1206267). The blob is a binary file type. – Ohgodwhy Aug 28 '14 at 18:59
  • possible duplicate of [Php : Convert a blob into an image file](http://stackoverflow.com/questions/6106470/php-convert-a-blob-into-an-image-file) – Biswajit Maji Aug 28 '14 at 19:01

2 Answers2

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.

Marc B
  • 356,200
  • 43
  • 426
  • 500
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

Shen Siddharta
  • 50
  • 7