📁 File Manager
Editing:
/home/wvl7mof7402e/www/remindyourdata.live/admin/approvallistdelete.php
<?php session_start(); include "dbconnect.php"; // Check if ID is passed if (!isset($_GET['id'])) { echo "<script>alert('No applicant selected for deletion.'); window.location.href='approvallistedit.php';</script>"; exit; } $applicant_id = intval($_GET['id']); // Get the file path before deleting $sql = "SELECT file_upload FROM work_permit_approval WHERE applicant_id = ?"; $stmt = $con->prepare($sql); $stmt->bind_param("i", $applicant_id); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows == 0) { echo "<script>alert('No record found to delete.'); window.location.href='approvallistedit.php';</script>"; exit; } $row = $result->fetch_assoc(); $file_path = $row['file_upload']; // Delete the record $delete_sql = "DELETE FROM work_permit_approval WHERE applicant_id = ?"; $stmt_delete = $con->prepare($delete_sql); $stmt_delete->bind_param("i", $applicant_id); if ($stmt_delete->execute()) { // Delete file if exists if (!empty($file_path) && file_exists($file_path)) { unlink($file_path); } echo "<script>alert('Record deleted successfully.'); window.location.href='approvallistdelete.php';</script>"; } else { echo "<script>alert('Failed to delete record.'); window.location.href='approvallistdelete.php';</script>"; } ?>
Save
Cancel