format("Y-m-d"); error_reporting(1); if ( $_FILES['file']['error'] > 0 ){ echo 'Error: ' . $_FILES['file']['error'] . '
'; } else { $clearanceID = mysql_escape_string($_POST['clearanceID']); $addCompID = mysql_escape_string($_POST['addCompID']); $fullPath = $clearanceID . '_rl_' . $_FILES['file']['name']; if(move_uploaded_file($_FILES['file']['tmp_name'], 'FILES/clearance/' .$fullPath)) { echo "File Uploaded Successfully"; } } //$imageLink = "https://www.autohub.ph/connect/home/uimages/pricelist/".$fullPath; $FileLink = "https://www.autohub.ph/connect/home/FILES/clearance/".$fullPath; //mysql_query("INSERT INTO vts_profile_images (cust_id, file_path) VALUES('$customerID','$fullPath')"); mysql_query("UPDATE `cl_clearance_header` SET `cl_resignation_letter`='$FileLink' WHERE `h_id`='$clearanceID'"); echo ""; ?>