View Image in browser

[sandy1028]

//DB Connection

$sql ="select img_val from image where id=152";
$result = mysql_query($sql);

while ($row = mysql_fetch_assoc($result)) {
    $Image=$row['img_val'];
#       print "Image is $Image";
}

header( "Content-type: image/jpeg");
echo "<img src=\"$Image\"; alt=\"Image from DB\" />";

When I view the file in browser, some characters are printed and not the image.

Please tell me how to view the exact image in the browser.

[premiso]

header( "Content-type: image/jpeg");
echo $Image;

 

It expects the raw data of the image, not an html tag. Try that. (And you do not need the while loop since you are only pulling 1 record)

[sandy1028]

In the browser I can see some characters and not the image.

 

[attachment deleted by admin]

[PFMaBiSmAd]

The <img src="..." attribute value MUST BE a URL to an image, NOT binary image data.

 

The URL that you put into the src="..." attribute must cause the correct Content-type: header to be output, followed by the binary image data.

 

Since you are outputting the binary image data using a .php script, you would put a .php file in as the URL. You will also typically put a GET parameter on the end of the URL that indicates which image you want (so that you can use the same .php file to output any available image.)

 

The <img tag that you produce for your web page would look something like -

 

<img src="myimage.php?id=152" alt="">

 

The myimage.php file (or whatever name you choose) will need to get the id (using $_GET['id']), validate it, and put that into the query in order to retrieve the correct binary image data.