Don't know how to save image in Mysql

Anon

I don't know how to save image in Mysql and display if from the database. I used code example from www.weberdev.com but I failed to get it worked. The script showed error message. Please anybody let me know where I can find comprehensive PHP code example regarding saving in mysql and displaying it using PHP.

Anon

I believe it will be much quicker and more useful to save the image in the filesystem and refer to that image from your database.

This is very easy to call.

This is how I refer to my images and find it quite fast.

Hope it helps

John

saltwater

I think Misha means how to store the binary data from images in a database, not there path

First of all, you need to have a colum with data type BLOB (for the binary data)

When you upload a file, it is saved as a temperary file in the tmp directory of the server, the name of the temp file is stored into the variable with the name of your file tag, if there is nothing uploaded, the variable will contain 'none'
i.e.:

<?
if ($myfile!='none') {
$fp=fopen($myfile,'r');
$bin_myfile=addslashes(fread($fp,filesize($myfile)));
fclose($fp);
}

what I do is reading the temp file and putting it in a variable

now you can use this variable in your query
i.e.:
INSERT INTO images SET image='$bin_myfile'

if image is your colum with datatype BLOB..

hope this helps,
Bruno

saltwater

<file name="myfile"> should be <input type="file" name="myfile">
my mistake 🙂

saltwater

oh, and to show the image's, I use an external script (my imgage tags look like this <img src="img.php?id=1>

and the basic of the external script (img.php) like this:

header ("Content-type: image/pjpeg"); // if you are using a jpeg image

$querydone=mysql_query("SELECT image FROM images WHERE id='$id'");
echo stripslashes(mysql_result($querydone,0,0)); // just echo the binary data, slashes must be removed because they are automaticly added by MySQL