DaniWeb Forum Index > Web Development > PHP

Upload images to a folder script problem

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Feb 2008

Posts: 52

Reputation: Scottmandoo is an unknown quantity at this point

Solved Threads: 0

Scottmandoo Scottmandoo is offline

Offline

Junior Poster in Training

Upload images to a folder script problem

Mar 7th, 2008

Alright this is my code, the error im getting is in red

Help with Code Tags

(Toggle Plain Text)

<?php

include("dbinfo.inc.php");

$tut_name     = $_POST['tut_name'];
$tut_link     = $_POST['tut_link'];
$tut_program  = $_POST['tut_program'];
$tut_category = $_POST['tut_category'];
$tut_video    = $_POST['tut_video'];
$tut_download = $_POST['tut_download'];
$tut_image    = $_FILES['tut_image']['name'];

function getExtension($str) {
$i = strrpos($str,".");
if (!$i) { return ""; }
$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);
return $ext;
}

if (empty($tut_image)) {
	$result = '<font color=FFFFFF>Please choose a photo to upload</font>';
	$error++;
}
else {
		$filename = stripslashes($tut_image);
		$extension = getextension($filename);
		$extension = strtolower($extension);
		if (($extension !== "jpg") && ($extension !== "jpeg") && ($extension !== "png") && ($extension !== "gif")) {
			$result = '<font color=FFFFFF>Unknown file extension, please try again</font>';
			$error++;
		}
		else {
			$tmpFile = $_FILES['tut_image']['tmp_name'];
			$size = getimagesize($tmpFile);
			$sizekb = filesize($tmpFile);
			if ($sizekb > 10000) {
				$result = '<font color=FFFFFF>The image has exceeded the size limit, please try again</font>';
				$error++;
			}
			else {
				$imageName = '../images/tutorials/' . time() . '.' . $extension;
				$copy = copy($tmpFile, $imageName);
				if (!$copy) {
					$result = '<font color=FFFFFF>Image upload unsuccessful, please try again</font>';
					$error++;
				}
			}
		}
}
if ($error > 0) {
	echo $result;
}
else {
	$con = mysql_connect('localhost',$username,$password);
	@mysql_select_db($database) or die( "Unable to select database");
	$sql = "INSERT INTO `tutorials` VALUES ('','$tut_name','$tut_link','$tut_program','$tut_category','$tut_video','$tut_download','$imageName')";
	$query = mysql_query($sql) or die('Error: ' . mysql_error());
}

mysql_close();

?>

I have also CHMODed my file destination to 777 permision

•

Join Date: Nov 2007

Posts: 121

Reputation: Auzzie is an unknown quantity at this point

Solved Threads: 16

Auzzie

Offline

Junior Poster

Re: Upload images to a folder script problem

Mar 7th, 2008

I'm not 100% sure (just woken up and skimmed the code) but arent you trying to convert a directory into a file on your copy command?

Also i believe there is an image part of the multi dimensional array that is the bit you need to copy, not just the name.

If not then ignore the post and i will wake up and try again

•

Join Date: Jun 2007

Posts: 1,227

Reputation: kkeith29 has a spectacular aura about

Solved Threads: 167

kkeith29

Offline

Nearly a Posting Virtuoso

Re: Upload images to a folder script problem

Mar 7th, 2008

i look over my code again and i can't see the problem. i have used this code a dozen times and never had a problem with it. are you sure its not the server.

•

Join Date: Jun 2007

Posts: 1,227

Reputation: kkeith29 has a spectacular aura about

Solved Threads: 167

kkeith29

Offline

Nearly a Posting Virtuoso

Re: Upload images to a folder script problem

Mar 7th, 2008

try this:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
 
include("dbinfo.inc.php");
 
$tut_name     = $_POST['tut_name'];
$tut_link     = $_POST['tut_link'];
$tut_program  = $_POST['tut_program'];
$tut_category = $_POST['tut_category'];
$tut_video    = $_POST['tut_video'];
$tut_download = $_POST['tut_download'];
$tut_image    = $_FILES['tut_image']['name'];
 
function getExtension($str) {
$i = strrpos($str,".");
if (!$i) { return ""; }
$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);
return $ext;
}
 
if (empty($tut_image)) {
	$result = '<font color=FFFFFF>Please choose a photo to upload</font>';
	$error++;
}
else {
		$filename = stripslashes($tut_image);
		$extension = getextension($filename);
		$extension = strtolower($extension);
		if (($extension !== "jpg") && ($extension !== "jpeg") && ($extension !== "png") && ($extension !== "gif")) {
			$result = '<font color=FFFFFF>Unknown file extension, please try again</font>';
			$error++;
		}
		else {
			$tmpFile = $_FILES['tut_image']['tmp_name'];
			$sizekb = filesize($tmpFile);
			if ($sizekb > 10000) {
				$result = '<font color=FFFFFF>The image has exceeded the size limit, please try again</font>';
				$error++;
			}
			else {
				$imageName = 'images/tutorials/' . time() . '.' . $extension;
				$copy = copy($tmpFile, $imageName);
				if (!$copy) {
					$result = '<font color=FFFFFF>Image upload unsuccessful, please try again</font>';
					$error++;
				}
			}
		}
}
if ($error > 0) {
	echo $result;
}
else {
	$con = mysql_connect('localhost',$username,$password);
	@mysql_select_db($database) or die( "Unable to select database");
	$sql = "INSERT INTO `tutorials` VALUES ('','$tut_name','$tut_link','$tut_program','$tut_category','$tut_video','$tut_download','$imageName')";
	$query = mysql_query($sql) or die('Error: ' . mysql_error());
}
 
mysql_close();
 
?>
<?php

include("dbinfo.inc.php");

$tut_name     = $_POST['tut_name'];
$tut_link     = $_POST['tut_link'];
$tut_program  = $_POST['tut_program'];
$tut_category = $_POST['tut_category'];
$tut_video    = $_POST['tut_video'];
$tut_download = $_POST['tut_download'];
$tut_image    = $_FILES['tut_image']['name'];

function getExtension($str) {
$i = strrpos($str,".");
if (!$i) { return ""; }
$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);
return $ext;
}

if (empty($tut_image)) {
	$result = '<font color=FFFFFF>Please choose a photo to upload</font>';
	$error++;
}
else {
		$filename = stripslashes($tut_image);
		$extension = getextension($filename);
		$extension = strtolower($extension);
		if (($extension !== "jpg") && ($extension !== "jpeg") && ($extension !== "png") && ($extension !== "gif")) {
			$result = '<font color=FFFFFF>Unknown file extension, please try again</font>';
			$error++;
		}
		else {
			$tmpFile = $_FILES['tut_image']['tmp_name'];
			$sizekb = filesize($tmpFile);
			if ($sizekb > 10000) {
				$result = '<font color=FFFFFF>The image has exceeded the size limit, please try again</font>';
				$error++;
			}
			else {
				$imageName = 'images/tutorials/' . time() . '.' . $extension;
				$copy = copy($tmpFile, $imageName);
				if (!$copy) {
					$result = '<font color=FFFFFF>Image upload unsuccessful, please try again</font>';
					$error++;
				}
			}
		}
}
if ($error > 0) {
	echo $result;
}
else {
	$con = mysql_connect('localhost',$username,$password);
	@mysql_select_db($database) or die( "Unable to select database");
	$sql = "INSERT INTO `tutorials` VALUES ('','$tut_name','$tut_link','$tut_program','$tut_category','$tut_video','$tut_download','$imageName')";
	$query = mysql_query($sql) or die('Error: ' . mysql_error());
}

mysql_close();

?>

Last edited by kkeith29; Mar 7th, 2008 at 8:57 pm.

•

Join Date: Feb 2008

Posts: 52

Reputation: Scottmandoo is an unknown quantity at this point

Solved Threads: 0

Scottmandoo Scottmandoo is offline

Offline

Junior Poster in Training

Re: Upload images to a folder script problem

Mar 9th, 2008

Thanks kkiehth29, but again another problem, heres what I get.

Error: Column count doesn't match value count at row 1
Edit: nvm it works now, thanks a lot

Last edited by Scottmandoo; Mar 9th, 2008 at 5:06 am.