Image Upload Question
Posted: Thu Oct 30, 2003 5:53 pm
What in this code doesn't make sence??
I am getting the following error: Column count doesn't match value count at row 1
I am getting the following error: Column count doesn't match value count at row 1
Code: Select all
<?php
if ($_POST['action'] == 'uploadbandimage')
{
$name = $_POST['name'];
$namearr = explode(".",$_FILES['file']['name']);
$path = $_SERVER['DOCUMENT_ROOT']."/bands/";
$filename = $namearr[0];
$ext = $namearr[1];
$query = "INSERT INTO bandimage(userid, name, filename) VALUES ($IYOY_UID, '$name', '$filename', NOW())";
if (!empty($_FILES['file']) && !empty($name) && ($ext == "jpg" || $ext == "JPG" || $ext == "gif" || $ext == "jpeg" || $ext == "png"))
{
if (is_uploaded_file($_FILES['file']['tmp_name']))
{
$filename = $IYOY_USER;
move_uploaded_file($_FILES['file']['tmp_name'], $path.$filename.".".$ext);
$filename = $filename.$ext;
$query = "INSERT INTO bandimage(userid, name, filename) VALUES ($IYOY_UID, '$name', '$filename', NOW())";
$result = mysql_query($query) OR DIE(mysql_error());
}
else {
switch ($_FILES['file']['error'])
{
case 0:
$errormsg = "<font color ='#FF0000'>File Uploaded</font>";
break;
case 1:
$errormsg = "<font color ='#FF0000'>File Size Exceeded</font>";
break;
case 2:
$errormsg = "<font color ='#FF0000'>File Size Exceeded</font>";
break;
case 3:
$errormsg = "<font color ='#FF0000'>File Only Partially Uploaded</font>";
break;
case 4:
$errormsg = "<font color ='#FF0000'>File Not Uploaded</font>";
break;
}
$p = 3;
}
}
else
{
$errormsg = "<font color ='#FF0000'>Not Complete or Wrong Type</font>";
$p = 3;
}
}
?>