Upload Image Problem

[ssmitra]

I have written some code to process an image upload from a web form. The name given to the image upload field is 'img'.

if(isset($_POST["img"])) {					

$file_size=$_FILES['img']['size'];	
$file_name=$_FILES['img']['name'];			
$file_type=$_FILES['img']['type'];
$file_image=$_FILES['img']['tmp_name'];

if($file_type =="image/jpeg")  { 

$insert_img = mysql_query("INSERT INTO image(image_id,image_name,image_type,image,image_size)  VALUES(null,'$file_name','$file_type','$file_image','$file_size')");
}
}

I've tested it a number of times within my website, but each, and every, time I run the script it just doesn't work. I'm at a loss to as to where I'm going wrong!

Any help would be grately appreciated. Thank you in advance. 🙂

[laserlight]

You are trying to save the image itself into a BLOB field?

[DemonMaestro]

is your permissions on your folder 777?

[DemonMaestro]

is your permissions on your folder that witch you are uploading the pic set to 777?

[ssmitra]

Thanks for your feedback.

As for the comment about the BLOB file, I'm not entirely sure if i'm processing the image correctly into the blob field. I thought about using ob_start(), but aren't sure if that'd sort the problem out.

The comment about the permissions, the file would simply load into the server folder so I'm not sure if I need to provide permissions to do that.

Thanks again.

[laserlight]

$_FILES['img']['tmp_name'] gives the temporary name of the image to be uploaded. This is different from the actual data that comprises the image.

One way might be to open the image file (in binary mode) and read to a variable which is then used for the value of the BLOB field.

An alternative is to not use the BLOB field at all, but instead upload the image and store its location on the filesystem.

[ssmitra]

Laserlight you raise a very interesting point, whether to use a BLOB field or a file system to store the images.

I'm no expert on this, and I'm very much open to suggestions on how I should store my images. Using a BLOB mechanism seems complicated for a novice programmer like me, but I suspect for many hardened programmers it's just a walk in the park. The file system method seems easier, but I wasn't sure of the overhead that would cause on my server- to store every file in its original form compared to a compressed BLOB file.

It'd be great if any one, or any people, could offer there expert advice on which method would have longevity and indeed which method would be classed as a best practice for uploading and storing images.

I've been trying to code this image upload script for a while now, and owing to frustration I've stated from scratch several times! So, I don't mind binning my script and starting again with a new method.

Thank you all!

[hairulazami]

I used this at my web page, and it work. You may try this too.
I hope you enjoy there.

<?
//just for connection to dbase
/* SQL
CREATE TABLE `images` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`image_name` VARCHAR( 100 ) NOT NULL ,
`image_type` VARCHAR( 100 ) NOT NULL ,
`image_size` INT( 10 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
) TYPE = MYISAM ;
*/

function db_connect1()
{
 	global $db_link1;
 	@$db_link1 = mysql_connect("localhost","","") or die("Connection Error! $php_errormsg");
 	if ($db_link1) @mysql_select_db("drev7_dbase") or die ("Error Select Database!");
 	return $db_link1;
}
//upload progress goes here
db_connect1();
if($goSave)//your button name
{
	$checkFile=$HTTP_POST_FILES['ufile']['type'][0]; // will be check your image file type
	if($checkFile=="image/gif" || $checkFile=="image/pjpeg" || $checkFile=="image/x-png")
	{
		$dir= "images/".$HTTP_POST_FILES['ufile']['name'][0]; // your directory target
		copy($HTTP_POST_FILES['ufile']['tmp_name'][0], $dir); // your files will be copy to images/ directory
        $insert_img = @mysql_query("INSERT INTO images(image_name, image_type, image_size) 
		VALUES ('".$HTTP_POST_FILES['ufile']['name'][0]."', '".$HTTP_POST_FILES['ufile']['type'][0]."', '".$HTTP_POST_FILES['ufile']['size'][0]."')");
		echo "Successfully";
		echo "<br><br><a href='javascript:history.go(-1)'>CONTINUE</a>";
    }
	else
	{
		echo "Files are not allowed. / Your Filed is empty";
		echo "<br><br><a href='javascript:history.go(-1)'>CONTINUE</a>";
	}	 
}
else
{
	echo"
	<form id='formID' action='' method='post' name='iMan' enctype='multipart/form-data'>
    Browse Files : <br>
    <input type='file' name='ufile[]' id='ufile[]' /><br><br>
	<input type='submit' name='goSave' value='Save and Upload'>
	</form>";
}

?>

[hammadtariq]

hello,
well when you upload a file it get stored in the uploadtemp folder of your php.
you need to move it to some permanent location first...

use move_uploaded_files function

check
http://www.php.net/manual/en/function.move-uploaded-file.php

this is atleast what i do...