Display saved image in BLOB

Question

I would like to know how to display an image saved in the BLOB database:

code:

$nome = $_POST["nome"];
$preco = $_POST["preco"];
$cor = $_POST["cor"];
$descricao = $_POST["descricao"];

if(is_uploaded_file($_FILES['imagem']['tmp_name']))
{
 $imgData = file_get_contents($_FILES['imagem']['tmp_name']);
 $sizeData = getimagesize($_FILES['imagem']['tmp_name']);
 $imagem = $imgData;
}
if(insereProduto($conexao, $nome, $preco, $imagem, $descricao, $cor)) { 

    ?><p class="text-success">Produto  <?=$nome ?>, que custa <?=$preco?> adicionado com sucesso!</p><?php


}

function insereProduto($conexao, $nome, $preco, $imagem, $descricao, $cor) {
   $query = "insert into produtos (nome, preco, imagem, descricao, cor) values 
   ('{$nome}', '{$preco}','{$imagem}', '{$descricao}','{$cor}')"; 
   echo $query;
   $resultadoDaInsercao = mysqli_query($conexao, $query); 
   return $resultadoDaInsercao; 
}

Answer 1

To view images from the BD you have to change the header of the page for the browser to understand that it is an image. To do this create a.php generate file that will be responsible for generating the image so that the browser understands it as image and call this page in the src attribute of the html img tag. Thus:

Gera.php

  <?
//RECEBE
PARÂMETRO 
$id = $_GET["id"];

//CONECTA
AO MYSQL 
$conn = mysqli_connect("localhost", "usuario",
"senha", "base de dados ");

//EXIBE
IMAGEM 
$sql = mysqli_query($conn, "SELECT foto,tipo FROM
fotos WHERE id = ".$id."");

$row = mysqli_fetch_array($sql,
MYSQLI_ASSOC); 
$tipo = $row["tipo"]; 
$bytes = $row["foto"];

//EXIBE
IMAGEM 
header("Content-type: ".$tipo."");

echo $bytes;
?>

Display:

  echo "<img src=”gera.php?id=".$id."”";

Answer 2

vc has can print directly on image encoding in Base64

echo base64_decode($data);
echo '<img src="data:image/gif;base64,' . $data . '" />';

where $data he image that came straight from db