how to display blob as image in php

Question

Hi I'm storing an image as blob in a SQL database and I want to display it but when I do it´s a blank image. I'm saving like this:

$image = addslashes(file_get_contents($_FILES['image']['tmp_name']));
$image = base64_encode($image);

$sql = "INSERT INTO `imagenes` (`imagen`,)  VALUES ('$image',)";

and when I display it I use an echo with:

img src="data:image/jpg;base64,'.$row["image"].'"

It shows a blank image, so I don´t know what I'm doing wrong.

Don't save files in a database. http://stackoverflow.com/a/38829952/267540 — e4c5, Dec 08 '16 at 00:59
At the risk of being redundant it is not generally a good idea to store images in the database. Database storage has no value add over storing the data in the file system. — M T Head, Dec 08 '16 at 01:37

score 1 · Answer 1 · answered Dec 08 '16 at 01:19

1

Try it please, may be it will help:

img src="data:image/jpg;base64,'.base64_encode($row["image"]).'"

answered Dec 08 '16 at 01:19

Solonik

21
1
2

how to display blob as image in php

1 Answers1