Welcome Guest, Not a member yet? Register   Sign In
diplaying blob image from mysqli using php
#1

[eluser]Unknown[/eluser]
hi friends i am using this php code to retrieve image which is stored as blob file in my database
Code:
$dbc=mysqli_connect('localhost','root','','db')

$query="SELECT Binfile, Filetype FROM imagetable where imgid='$imgid'" ;
$result=mysqli_query($dbc,$query);
$row=mysqli_fetch_assoc($result);

$image=$row['Binfile'];
header("Content-type:".$row['Filetype']);

echo $image;
this is the code which i am using to display the image.
But it is giving an error like

The image "http://lacalhost//viewimage.php?imgid=1" cannot be displayed because tit contain errors.


help me to remove this error and display the image...




Theme © iAndrew 2016 - Forum software by © MyBB