query("UPDATE lab_reports SET status='Approved' WHERE id=$id"); header("Location: approve_reports.php"); } // 2. Delete Action if (isset($_GET['delete_id'])) { $id = intval($_GET['delete_id']); $res = $conn->query("SELECT file_path FROM lab_reports WHERE id=$id"); if($res->num_rows > 0) { $file = $res->fetch_assoc()['file_path']; if(file_exists("../assets/reports/$file")) { unlink("../assets/reports/$file"); } } $conn->query("DELETE FROM lab_reports WHERE id=$id"); header("Location: approve_reports.php"); } ?> Review Reports
⏳ Pending Approval
query($sql); if($res->num_rows > 0) { while($row = $res->fetch_assoc()) { echo '
'; echo '

'.$row['patient_name'].'

'.$row['report_name'].'

View File
'; echo '
Approve ✕
'; echo '
'; } } else { echo '

No pending reports.

'; } ?>
✅ Recently Approved
query($sql); if($res->num_rows > 0) { while($row = $res->fetch_assoc()) { echo '
'; echo '

'.$row['patient_name'].'

'.$row['report_name'].'

'; echo 'Live'; echo '
'; } } ?>