PK!X>&&polveriDelete.phpnu„[µü¤ false, 'message' => '']; $data = json_decode(file_get_contents('php://input'), true); // Get JSON payload if (isset($data['fileName'])) { $fileName = basename($data['fileName']); // Sanitize file name $filePath = "../../uploads/police_verification/" . $fileName; // Initialize database connection $database = new Database(); $db = $database->getConnection(); if ($db === null) { $response['message'] = "Database connection failed."; echo json_encode($response); exit; } if (file_exists($filePath)) { if (unlink($filePath)) { // Clear `doc_polveri` column for matching file name $query = "UPDATE acts_emp SET doc_polveri = NULL WHERE doc_polveri = :fileName"; $stmt = $db->prepare($query); $stmt->bindParam(':fileName', $fileName); $stmt->execute(); $response['success'] = true; $response['message'] = 'Police Verification File deleted successfully.'; } else { $response['message'] = 'Failed to delete the file.'; } } else { $response['message'] = 'File not found.'; } } else { $response['message'] = 'No file name provided.'; } echo json_encode($response); ?>PK!ÚtͰ°adharDelete.phpnu„[µü¤ false, 'message' => '']; $data = json_decode(file_get_contents('php://input'), true); // Get JSON payload if (isset($data['fileName'])) { $fileName = basename($data['fileName']); $filePath = "../../uploads/adhar/" .$fileName; // Assuming the file is uploaded to this directory // Initialize database connection $database = new Database(); $db = $database->getConnection(); if ($db === null) { $response['message'] = "Database connection failed."; echo json_encode($response); exit; } // Check if file exists before attempting to delete if (file_exists($filePath)) { if (unlink($filePath)) { // Clear `doc_adhar` column for matching file name $query = "UPDATE acts_emp SET doc_adhar = NULL WHERE doc_adhar = :fileName"; $stmt = $db->prepare($query); $stmt->bindParam(':fileName', $fileName); $stmt->execute(); $response['success'] = true; $response['message'] = 'Adhar File deleted successfully'; } else { $response['message'] = 'Error deleting file'; } } else { $response['message'] = 'File not found'; } } else { $response['message'] = 'No file name provided'; } echo json_encode($response); ?> PK!¥·Fá°°otherDelete.phpnu„[µü¤ false, 'message' => '']; $data = json_decode(file_get_contents('php://input'), true); // Get JSON payload if (isset($data['fileName'])) { $fileName = basename($data['fileName']); $filePath = "../../uploads/other_documents/" . $fileName; // Initialize database connection $database = new Database(); $db = $database->getConnection(); if ($db === null) { $response['message'] = "Database connection failed."; echo json_encode($response); exit; } if (file_exists($filePath)) { if (unlink($filePath)) { // Clear `doc_adhar` column for matching file name $query = "UPDATE acts_emp SET doc_other = NULL WHERE doc_other = :fileName"; $stmt = $db->prepare($query); $stmt->bindParam(':fileName', $fileName); $stmt->execute(); $response['success'] = true; $response['message'] = 'Other Documnet File deleted successfully'; } else { $response['message'] = 'Error deleting file'; } } else { $response['message'] = 'File not found'; } } else { $response['message'] = 'No file name provided'; } echo json_encode($response); ?>PK!X>&&polveriDelete.phpnu„[µü¤PK!ÚtͰ°gadharDelete.phpnu„[µü¤PK!¥·Fá°°V otherDelete.phpnu„[µü¤PKïE