get image stored in database using fetch_object() PHP

Question

I have stored several images in mediumblob type on a SQL database , I have tired following code but it gives ASCII characters instead of images

    while($obj = $results->fetch_object())
      {
 echo ' <div class="col-md-3"> ';
 echo ' <h2>'.$obj->name.'</h2>';
 echo ' <img src=Image/'.$obj->pic.' />';
 echo ' <div class="row">'.$obj->price.'</div>';
 echo ' </div> ';
      }

how do I change this to appear an image?

echo ' <img src=Image/'.$obj->pic.' />';

I know it's not a good practice to store images inside databases.

Try inline base64 instead https://stackoverflow.com/questions/3967515/how-to-convert-image-to-base64-encoding — Charlotte Dunois, Aug 29 '16 at 19:07
It's exactly wrong. Look at this answer closely http://stackoverflow.com/a/18739753/3885509 — Charlotte Dunois, Aug 29 '16 at 19:41

score 0 · Answer 1 · answered Aug 29 '16 at 19:10

0

The format you would probably want to try is more like ( assuming the data in the pic column is already base64 encoded )

echo "<img src='data:image/jpeg;base64, {$obj->pic}' /> ";

answered Aug 29 '16 at 19:10

Professor Abronsius

33,063
5
32
46

You could've just marked this question as duplicate, since it is an exact duplicate. – Charlotte Dunois Aug 29 '16 at 19:16

score 0 · Accepted Answer · answered Aug 29 '16 at 19:43

0

This worked for me !

  echo '<img src="data:image/x-icon;base64,'.base64_encode($obj->pic).'"> ';

answered Aug 29 '16 at 19:43

get image stored in database using fetch_object() PHP

2 Answers2