loading images...

How do you save images to and load images from a mysql db? I'm really stuck here.

I personally opt to not save images in the database. Instead I save them to a directory and save the filename of the image in mysql.

1) Inserting images into database, field for storing image must be BLOB type:
to choose image user:
Upload.php
<form name='MyForm' method=post enctype="multipart/form-data" action='Dofile.php'><input type=file name='userfile'><input type=submit value=Upload">

Dofile.php:
$data = "";
$userfile = $HTTP_POST_FILES['userfile']['tmp_name'];
//get file
$fp = fopen($userfile, "rb");
while(!feof($fp))
{
$data .= fread($fp, 1024);
}
fclose($fp);

$data = addslashes($data);
$data = addcslashes($data, "");

//insert image into database
$Query = "INSERT INTO images VALUES (NULL,'$data')";

$res = $db->query($Query);

OutputImages.php

<img src="print_image.php?id=$id>

print_image.php

$MainSQL="SELECT image FROM images where id=$id;

$res = $db->query($MainSQL);
$data = $res[0][0];

header("Content-Type: image/jpegn");
header("Content-Transfer-Encoding: binaryn");
header("Content-length: " . strlen($data) . "n");

//send file contents
print($data);

I have never ever saved an image directly into a mySQL DB. I always just save it to a certain directory, and store the image's filename in the DB.

I know that it loads faster by saving it to a file, but sometimes it's more useful saving it to database.