How to display an image stored in the mysql BLOB field in a php page?

Question

I have an image saved in my mysql blob encoded in base 64. However, I cannot display the image in a simple php page. In reality what I want is for the user to click on a product category, be returned a search performed in php that returns the field values and also the images of each product. Follow my php code that is returning a broken image on my page and not the image that is stored in my database. Please, I’d like to find out where the bug is in my code.

    <?php

        require "conexao.php";

                    $sql = "SELECT * FROM produtos WHERE idProduto = 17;";

                    $result = mysqli_query($conexao, $sql) or die(mysql_error());  
                    $row = mysqli_fetch_array($result);

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

        mysqli_close($conexao);
    ?>

Answer 1

I found the bug. didn’t need to decode back. The image is already coming ready to be displayed.

This way, the line that was like this:

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

gets like this:

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

Solved!