prepare("SELECT * FROM teacher_unavailability WHERE Unavailable_ID = ?");
$stmt->bind_param("i", $Unavailable_ID);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows != 1) {
die("Record not found.");
}
$data = $result->fetch_assoc();
$Teacher_ID= $data['Teacher_ID'];
$resultTeachers = $mysqli->query("SELECT Teacher_ID, First_Name, Last_Name FROM teacher_profile WHERE Teacher_ID='".$Teacher_ID."' AND User_Access = 1 ORDER BY First_Name");
$teacher = $resultTeachers->fetch_assoc();
$_SESSION['Teacher_ID'] =$Teacher_ID;
// Handle form submission
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['submit'])) {
$Teacher_ID = $_SESSION['Teacher_ID'];
$Unavailable_From = $_POST['Unavailable_From'];
$Unavailable_To = $_POST['Unavailable_To'];
if ($Teacher_ID > 0 && !empty($Unavailable_From) && !empty($Unavailable_To)) {
$stmt = $mysqli->prepare("UPDATE teacher_unavailability SET Teacher_ID = ?, Unavailable_From = ?, Unavailable_To = ? WHERE Unavailable_ID = ?");
$stmt->bind_param("issi", $Teacher_ID, $Unavailable_From, $Unavailable_To, $Unavailable_ID);
if ($stmt->execute()) {
$error_msg = "Updated successfully";
//exit;
} else {
$error_msg = "Update failed.";
}
} else {
$error_msg = "Please fill in all fields.";
}
}
if (!empty($error_msg)) {
// echo $error_msg;
}
if (!empty($error_msg)) {
// echo "
Notification! ".$mesg."
";
echo "";
}
?>