I had a php script that handled file uploads into a MySQL DB. It was working fine when it was located in the root directory of my website. To better organize things I moved the script to a new directory within that root dir. Now my script doesn't work. I changed all my links correctly....
Here's the code:
if ($FILES['picture_data1']['tmp_name'] && $FILES['picture_data1']['type'] == "image/jpeg" || $FILES['picture_data1']['type'] == "image/gif" || $FILES['picture_data1']['type'] == "image/jpg")
{
$picture_data1 = $FILES['picture_data1']['tmp_name'];
$picture_data1_name = $FILES['picture_data1']['name'];
$picture_data1_size = $FILES['picture_data1']['size'];
$picture_data1_type = $FILES['picture_data1']['type'];
$data1 = addslashes(fread(fopen($picture_data1, "rb"), filesize($picture_data1)));
MYSQL_QUERY("INSERT INTO Pictures (PIC_ID,CON_id,PIC_binary,PIC_filename,PIC_filesize,PIC_filetype) VALUES(NULL,'$con_id','$data1','$picture_data1_name','$picture_data1_size','$picture_data1_type')");
$pic_data_query = mysql_query("select count(*) from Pictures where CON_ID='$con_id'");
$pic_data_data = mysql_fetch_row($pic_data_query);
$piccount = $pic_data_data[0];
if ($piccount > "1")
{
$pic_id_query = mysql_query("select MAX(PIC_ID) from Pictures where CON_ID='$con_id'");
$pic_id_data = mysql_fetch_row($pic_id_query);
$pic_id = $pic_id_data[0];
$pic_con_num = $piccount ++;
MYSQL_QUERY("update Pictures set PIC_con_num='$pic_con_num' where PIC_ID='$pic_id'");
}
}
