how do I display an image saved in the db as a longblob?

Question

I've stored a blob image in the database but I can't see it. I wrote this code

$queryi = "SELECT Foto  FROM bhk   WHERE Cod_Bhk = '".$Codice."' INTO DUMPFILE 'immagine.jpg'";

$resulti = mysqli_query($connessione_al_server,$queryi);

html code:

<img id="imgcaricata" class="mySlides" src="immagine.jpg" style="height:600px; width:auto;max-width:500px;">

What does that code do? What is not working yet? – Nico Haase Sep 05 '19 at 06:22 — Nico Haase, Sep 05 '19 at 06:22

score 0 · Accepted Answer · answered Sep 04 '19 at 19:09

This is valid if your blob has the mime type jpeg

echo '<img id="imgcaricata" class="mySlides"  
src="data:image/jpeg;base64,'.base64_encode( $resulti["Foto"] ).'" 
style="height:600px; width:auto;max-width:500px;" />';

Or try it with a separate php script like https://stackoverflow.com/a/7793098/5193536

score 0 · Answer 2 · answered Sep 05 '19 at 05:52

0

<img src="data:image/jpeg;base64,<?php echo base64_encode(  $resulti["Foto"] ); ?>" id="imgcaricata" class="mySlides" style="height:600px; width:auto;max-width:500px;"/>

answered Sep 05 '19 at 05:52

Wazan

539
1
8
27

1

Please add some explanation to your code such that others can learn from it – Nico Haase Sep 05 '19 at 06:22

how do I display an image saved in the db as a longblob?

2 Answers2