Cannot display blob data from mysql database

Question

So I am trying to display a BLOB data from a database using the PHP code below, but it doesn't load, in the place of the picture I can only see the question mark (absence). What did I do wrong? I'm new to PHP btw.

<?php
    $query = "SELECT * FROM `blog_posts` LIMIT 0, 30 ";
    $result = mysqli_query($db, $query);
    while($row = mysqli_fetch_assoc($result)) {
        echo "<article>"; 
        echo    "<header>".$row["title"]."</header>"; 
        echo    "<div class='post-content'>";   
        echo        "<div class='post-image'><img src='data:image/jpeg;base64,".base64_encode($row["picture"])." width='290' height='290'></div>"; 
        echo        "<div class='post-text'>".$row["body"]."</div>"; 
        echo    "</div>"; 
        echo    "<div class='post-footer'>".$row["likes_number"]."  likes ".$row["comments_number"]."  comments"; 
        echo    "</div>";
        echo "</article>";
    }
?>

How are you storing the image in the DB? If you look at your page html source, what do you see? — Andy
– Andy, Commented Mar 13, 2017 at 21:48

slayer · Accepted Answer · 2017-03-13 21:58:34Z

1

I think the problem is that you are missing a closing single quote after the src of the tag

add ' after src='data:image/jpeg;base64,".base64_encode($row["picture"])." or try this src="data:image/jpeg;base64,'.base64_encode($row['picture']).'"

edited Mar 13, 2017 at 21:58

answered Mar 13, 2017 at 21:53

slayer

572 silver badges10 bronze badges

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

2 Comments

Danny Richard Aboo Over a year ago

Yes, I just noticed that, but thank you! It works now.

slayer Over a year ago

Always happy to help

Collectives™ on Stack Overflow

Cannot display blob data from mysql database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related