'; print_r($_FILES); echo ''; exit; $filename = $_FILES['file']['name']; $file_tmp_name = $_FILES['file']['tmp_name']; $file_size = $_FILES['file']['size']; $file_error = $_FILES['file']['error']; if ($file_error === UPLOAD_ERR_OK) { $maxsize = 9097152; $minsize = 300000; if ($file_size >= $maxsize || $file_size == 0) { $return_arr["status"] = 0; $return_arr["message"] = "Image file too large. Image must be less than " . round(($maxsize / 1000000), 0) . " megabytes."; echo json_encode($return_arr); return; } $quality = $file_size >= $minsize ? ($file_size >= $maxsize / 2 ? 30 : 60) : 60; $valid_ext = array('png', 'jpeg', 'jpg'); $file_extension = strtolower(pathinfo($filename, PATHINFO_EXTENSION)); if (in_array($file_extension, $valid_ext)) { $location = "../../dist/img/customer/ltms/" . $filename; // $location = "uploads/" . $filename; compressImage($file_tmp_name, $location, $quality); try { $pdo->beginTransaction(); $fullname = $_REQUEST['fullname']; $cs_number = $_REQUEST['cs_number']; $created_at = date('Y-m-d h:i:s'); $stmt = $pdo->prepare("INSERT INTO `customer_upload_ltms` (`fullname`,`cs_number`, `filename`, `directory`, `extension`, `size`, `created_at`) VALUES (:fullname, :cs_number, :filename, :directory, :extension, :size, :created_at)"); $stmt->bindParam(':fullname', $fullname); $stmt->bindParam(':cs_number', $cs_number); $stmt->bindParam(':filename', $filename); $stmt->bindValue(':directory', 'uploads/'); $stmt->bindParam(':extension', $file_extension); $stmt->bindParam(':size', $file_size); $stmt->bindParam(':created_at', $created_at); $stmt->execute(); $pdo->commit(); $return_arr["status"] = 1; $return_arr["message"] = "Image uploaded and data inserted successfully."; } catch (Exception $e) { // Rollback the transaction if something failed $pdo->rollBack(); error_log("Exception: " . $e->getMessage()); $return_arr["status"] = 0; $return_arr["message"] = "Error: " . $e->getMessage(); } } else { $return_arr["status"] = 0; $return_arr["message"] = "Invalid file type."; echo json_encode($return_arr); return; } } else { $return_arr["status"] = 0; $return_arr["message"] = "Error with file upload."; echo json_encode($return_arr); return; } $return_arr["status"] = 1; $return_arr["message"] = "Image uploaded successfully."; echo json_encode($return_arr); } else { $return_arr["status"] = 0; $return_arr["message"] = "No files uploaded."; // echo json_encode($return_arr); } ?>