prepare("DELETE FROM teacher_replacement_assignments WHERE Absent_Teacher_ID = (SELECT Teacher_ID FROM teacher_absences WHERE Absence_ID = ?)");
if ($stmt) {
$stmt->bind_param("i", $Absence_ID);
$stmt->execute();
$stmt->close();
}
$stmt = $mysqli->prepare("DELETE FROM teacher_absences WHERE Absence_ID = ?");
if ($stmt) {
$stmt->bind_param("i", $Absence_ID);
if ($stmt->execute()) {
echo "Absence deleted successfully";
} else {
echo "Error deleting record.";
}
$stmt->close();
} else {
echo "Failed to prepare statement.";
}
} else {
echo "Invalid request method.";
}
?>