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

Expand|Select|Wrap|Line Numbers

 
<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

Expand|Select|Wrap|Line Numbers

 
<?

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

Expand|Select|Wrap|Line Numbers

 
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:

Expand|Select|Wrap|Line Numbers

 
{

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.

Expand|Select|Wrap|Line Numbers

 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

how to store image in Mysql database

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ