Display image stored in Database

Question

I’m creating a digital menu that contains pictures of the dishes. I stored the photo in the Mysql BD using the following code:

HTML code

<form enctype="multipart/form-data" method="post" action="./processos/cadastra_item.php">
<p align="left">Imagem<br>
    <input type="hidden" name="MAX_FILE_SIZE" value="99999999"/>
    <input name="imagem" type="file"/>
</form>

PHP code

$imagem = $_FILES['imagem']['tmp_name'];
$tamanho = $_FILES['imagem']['size'];

if ( $imagem != "none" )
{
  $fp = fopen($imagem, "rb");
  $item->itemImg = fread($fp, $tamanho);
  $item->itemImg = addslashes($item->itemImg);
  fclose($fp);
}

After that I perform the INSERT normally. The field that stores the image is of type LONGBLOB. I checked by Workbench and the image was stored successfully but I can not display it on the page.

The code I used to try to display the image follows below:

echo "<center><img src='./processos/verImg.php?itemCod=\".$cod.\"' width='100' height='50' border='1'></center>"

PHP (File verImg.php)

$itemCod = $_GET['itemCod'];

    //Encontra o item no banco utilizando o código
    $sql = mysqli_query("SELECT itemCod, itemImg FROM Cardapio WHERE itemCod = ".$itemCod."");

    $row = mysqli_fetch_object($sql, MYSQLI_ASSOC);
    //itemImg é o campo onde esta armazenada a imagem
    $bytes  = $row->itemImg;
    header( "Content-type: image/gif");              
    echo $bytes;

I also tried to use mysqli_fetch_array but failed to display the image.

Answer 1

It may be that the error is in your html to show the image, you are not specifying that it is a Base64. Try to change the last line to:

echo 'data:image/jpeg;base64,'.base64_encode($bytes);