image upload

rayzun

Ive read in many places about uploading into MySQL images as binary or blob, but this method will not work for my query.

Ive not been able to find an example which shows how to upload using a form the image information into MySQL such as
type
size
path on server etc..

and also uploads the image to disk in a set directory

Im just looking for examples in script to do this.

-
Thanks for any help or suggestions!

Installer

Which part of the two-step process are you having trouble with? There are plenty of examples to be found of uploading and storing image files. As for the db part, that would take a simple query.

$query = "INSERT ('type','size','path') VALUES($type,$size,$path)";

rayzun

Which part of the two-step process are you having trouble with?

The actual form to do both upload to MySQL and image to a directory and rename the file to variable , my page is also in PHP.

kburger

Before you go too far with this, personally, I'd recommend against storing the images in the database at all. Store them in the filesystem. That's exactly what a filesystem is designed to do.

Store the path, the name, and whatever else about that image you want to in the database. Databases are great for storing text and information because they can be indexed and searched quickly. You can't really 'search' through an image in a database (or filesystem for that matter), so why use a database for storing images?

Just my 2 cents.

hcoms

Hello everyone,

i agree with the last post. For images we never store them within the database but rather just the path where the image sits. For other type of files such as pdfs which are downloadable, then we store them in mysql.

Cheers

Graham
hcoms

Installer

My reading of rayzun's posts is that that's what he's decided to do: i.e. put the image into the file system and put the information about it into the db. So, again, it's a two-step process (or three, counting the user's input): store the image file and store the image information.

kburger

Oops. You're right. He was telling us he's NOT going to do that. My bad. :rolleyes:

Anyway, back to the original question. What, exactly are you having trouble with, rayzun?

rayzun

the trouble Im having has to be the html for the form, which does all steps.. basically a form, uploads the image to Filesystem and the 20+ other text fields and image information to the database.

How would I alter my code to only upload the image itself to filesystem and keep the other fields uploading to my database??

include "/dyuiyuiy.php";
if(isset($POST['upload']) && $FILES['userfile']['size'] > 0)
{
$fileName = $FILES['userfile']['name'];
$tmpName = $FILES['userfile']['tmp_name'];
$fileSize = $FILES['userfile']['size'];
$fileType = $FILES['userfile']['type'];

$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}
$query = "INSERT INTO upload (name, size, type, content, pageid, Model, Make, Price ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$content', '$pageid', '$Model', '$Make', '$Price')";

mysql_query($query) or die('Error, query failed');
echo "<br>File $fileName uploaded<br>";
}

<form name="formCheck" action="" method="post" enctype="multipart/form-data">
..

kburger

Check out move_uploaded_file().