prepare("UPDATE submissions SET status = ? WHERE id = ?");
$stmt->execute([$status, $submission_id]);
// Fetch applicant email
$stmt = $pdo->prepare("SELECT email, full_name FROM submissions WHERE id = ?");
$stmt->execute([$submission_id]);
$submission = $stmt->fetch(PDO::FETCH_ASSOC);
if ($submission) {
$to = $submission['email'];
$subject = "Your Security Clearance Application Status";
$body = "Dear " . htmlspecialchars($submission['full_name']) . ",
";
$body .= "Your application for security clearance has been " . htmlspecialchars($status) . ".
";
$body .= "Thank you.
";
MailService::sendMail($to, $subject, $body, strip_tags($body));
}
}
}
header("Location: dashboard.php");
exit;