i want to retrieve image from mysql database but it is showing characters instead of image

Question

<?php

//mysql connection code

$link = mysqli_connect("localhost", "root", "", "srsc");

//mysql query

$sql = "SELECT image1 FROM images WHERE imageID=1";
$result = mysqli_query($link,$sql);
$row = mysqli_fetch_assoc($result);
?>

//image tag

<img src="<?php echo $row["image1"]; ?>" />

what is the data-type of your column where you stored image? Also you stored image or it's path only? What error you get can you please add that to your question. — Alive to die - Anant, Jul 21 '17 at 05:28
jpeg image is stored in blob type column name image1 and it is displaying characters not error — Mehar, Jul 21 '17 at 05:28
possible duplicate of:- [PHP display image BLOB from MySQL](https://stackoverflow.com/a/20564797/4248328) — Alive to die - Anant, Jul 21 '17 at 05:34

score 0 · Accepted Answer · answered Jul 21 '17 at 05:32

This looks pretty simple. You tell us what are you storing in your database table. I mean your are storing the image itself or image path (including only image name) in database. If you are storing image path (name) then you need to give right path while accessing image and if your are storing image itself in blob form then here is some help for you.

i want to retrieve image from mysql database but it is showing characters instead of image

1 Answers1