Image uploading script, very very strange error
Posted: Fri Sep 12, 2008 5:12 pm
Hey Everybody,
this is such a weird and frustrating error. The code below is for a client's gallery. She chooses an image from a standard html form and then submits, witch triggers this function. The script re sizes and uploads the file to two folders on the server and at the bottom, the $query and mysql_query inserts the file name into a database. The problem is, is that when you run the script, the query fails every time, i can't figure out why, but it never executes successfully.The worst part is that it was working one day, and then the next it wasn't working, nobody touched the code or the database. Could anybody suggest anything, even if its a total "DUH".... it might help! haha thanks.
this is such a weird and frustrating error. The code below is for a client's gallery. She chooses an image from a standard html form and then submits, witch triggers this function. The script re sizes and uploads the file to two folders on the server and at the bottom, the $query and mysql_query inserts the file name into a database. The problem is, is that when you run the script, the query fails every time, i can't figure out why, but it never executes successfully.The worst part is that it was working one day, and then the next it wasn't working, nobody touched the code or the database. Could anybody suggest anything, even if its a total "DUH".... it might help! haha thanks.
Code: Select all
if(isset($_POST['Submit'])):
$size = 480; // the thumbnail height
$filedir = '../../pictures-videos/images/'; // the directory for the original image
$thumbdir = '../../pictures-videos/thumbs/'; // the directory for the thumbnail image
$prefix = ''; // the prefix to be added to the original name
$maxfile = '2000000';
$mode = '0666';
$userfile_name = $_FILES['image']['name'];
$userfile_tmp = $_FILES['image']['tmp_name'];
$userfile_size = $_FILES['image']['size'];
$userfile_type = $_FILES['image']['type'];
if (isset($_FILES['image']['name'])):
$prod_img = $filedir.$userfile_name;
$prod_img_thumb = $thumbdir.$prefix.$userfile_name;
move_uploaded_file($userfile_tmp, $prod_img);
chmod ($prod_img, octdec($mode));
$sizes = getimagesize($prod_img);
$aspect_ratio = $sizes[1]/$sizes[0];
if ($sizes[1] <= $size)
{
$new_width = $sizes[0];
$new_height = $sizes[1];
}else{
$new_height = $size;
$new_width = abs($new_height/$aspect_ratio);
}
$destimg=ImageCreateTrueColor($new_width,$new_height)
or die('Problem In Creating image');
$srcimg=ImageCreateFromJPEG($prod_img)
or die('Problem In opening Source Image');
if(function_exists('imagecopyresampled'))
{
imagecopyresampled($destimg,$srcimg,0,0,0,0,$new_width,$new_height,ImageSX($srcimg),ImageSY($srcimg))
or die('Problem In resizing');
}else{
Imagecopyresized($destimg,$srcimg,0,0,0,0,$new_width,$new_height,ImageSX($srcimg),ImageSY($srcimg))
or die('Problem In resizing');
}
ImageJPEG($destimg,$prod_img_thumb,90)
or die('Problem In saving');
imagedestroy($destimg);
endif;
$query = "INSERT INTO ida_gallery VALUES ('','$userfile_name','')";
mysql_query($query) or die ($query." Failed");
endif;