how to store image in Mysql database

[hemashiki]

hi
i need help..how can i store image in mysql database
and i want to retrive that image
can anyone suggest plz

[stephane]

there is BLOB datatype in Mysql

to put it in, read image file with file_get_contents() function and put content into mysql query

[Motoma]

there is BLOB datatype in Mysql

to put it in, read image file with file_get_contents() function and put content into mysql query

Thank you for your response stephane!

[hemashiki]

<form name="form1" enctype="multipart/form-data" method="post" action="">
  <input name="file1" type="file" id="file1">
  <input type="submit" name="Submit" value="Submit">
</form>
<?
$f=$_POST['file1'];
mysql_connect("localhost","root","");
mysql_select_db("real");
mysql_query("select * from reg");
//$file_u=$_POST['file1'];
 
 
 
                $val = '0x' . bin2hex($f);
                $qu="insert into `reg`(`file`)values('$val')";
 
mysql_query($qu) or die("Query Error");
print '<h1 align="center">File Successfully Uploaded</h1>';
?>
 

Here i inserted the image in database.its stored as BLOB 2BYTES
and i tried to retrived by using this code

<?
mysql_connect("localhost","root","");
mysql_select_db("real");
$q=mysql_query("select * from reg");
while($log=mysql_fetch_array($q))
{
 
print file_get_contents($log['file']);
}
?>
 

i dint get the image.....

[stephane]

while($log=mysql_fetch_array($q))
{
print file_get_contents($log['file']);
}

.

why u use file_get_contents here?
i think it must looks like this

while($log=mysql_fetch_array($q))
{
print $log['file'];
}
 

and don't foget to send image/jpg ( or other ) before

[Motoma]

{

print file_get_contents($log['file']);
}

This is wrong, first, you need to specify the content type: jpeg, gif, png, etc...
Second, you aren't opening a file, so file_get_contents() should not be used.

You will want to do something more like this:

{
header("Content-type: image/png");
echo $log['file'];
}
 

Hope this helps.

[hemashiki]

Here i tried...
print $log['file'];
but the result came as OX
plz give me an solution

[Nert]

Here i tried...
print $log['file'];
but the result came as OX
plz give me an solution

Hi hemashiki,

according to you, you have already save image to database right? now you want to retrieve the image?
here try this code, i've come up with this code when i encountered the same problem as yours.

mysql_connect("localhost","root","");
mysql_select_db("real");
$q=mysql_query("select * from reg") or die(mysql_error());
$log = mysql_fetch_object($q); 
header("Content-type: image/GIF");    
echo $log->file; 

hope this would help you too.

--nert (^_^)

[stephane]

Here i tried...
print $log['file'];
but the result came as OX
plz give me an solution

because you insert to base at the same hex format
$val = '0x' . bin2hex($f);
it's wrong, you must insert simply file content, returned file_get_contents function