Using PHP (PDO) to show image (blob) from mysql database in HTML image tag

Question

i have a small problem with my code. I'm trying to show an image out of my database on my homepage using php (pdo). Problem is: I don't really know how to let insert the variable of the image in the HTML img tag. Where is my mistake / How can I fix it?

I am saving the images in my mysql database as a blob (largeblob) and all images are .jpg and / or .png

<?php
  $db = new Dbh;
  $pdo = $db->connect();
  $counter = 0;
  $content = "";

  $statement = $pdo->prepare('SELECT * FROM images');
  $statement->execute();

  while ($row = $statement->fetch()) {          ?>

    <img src = "<?php echo $row['image']; ?>">

  <?php         }       
 ?>

The thing happening right now is, is that html just shows some kind of bit code full of strange symbols

Thanks for your help in advance!

Assuming jpeg, change as needed. echo '<img src="data:image/jpeg;base64,'.base64_encode($row['image']).'"/>'; — AbraCadaver
– AbraCadaver, Commented Feb 11, 2019 at 20:49
If your images are being stored as blobs the src attribute isn't going to work as is. Here is a way to use javascript to render blob images: stackoverflow.com/questions/7650587/…. Note that using id as a selector as this example will not work in a loop structure, so you may want to use a class instead, and dynamically set a class identifier that increments each loop iteration (e.g., $classname = 'myimage-' . $i++;) — tshimkus
– tshimkus, Commented Feb 11, 2019 at 20:56

Navneet Krishna · Accepted Answer · 2019-05-21 06:03:55Z

1

This should work

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

edited May 21, 2019 at 6:03

Navneet Krishna

5,0275 gold badges27 silver badges45 bronze badges

answered Feb 11, 2019 at 20:49

Mr Tea

1417 bronze badges

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

Collectives™ on Stack Overflow

Using PHP (PDO) to show image (blob) from mysql database in HTML image tag

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related