prepare("DELETE FROM Teacher_Course_Assignments WHERE Group_ID = ?");
$stmt1->bind_param("i", $Group_ID);
$stmt1->execute();
$stmt1->close();
// 2. Update Schedule_Course_for_Group
if (!$mysqli->query("UPDATE Schedule_Course_for_Group SET Assigned = 0 WHERE Group_ID = '$Group_ID'")) {
echo json_encode(["status" => "error", "message" => $mysqli->error]);
exit();
}
// 3. Update Course_Group_Schedule_Main
if (!$mysqli->query("UPDATE Course_Group_Schedule_Main SET Assigned = 0 WHERE Group_ID = '$Group_ID'")) {
echo json_encode(["status" => "error", "message" => $mysqli->error]);
exit();
}
// ✅ Final success response
//// 2. Delete from Schedule_Course_for_Group
$stmt2 = $mysqli->prepare("DELETE FROM Schedule_Course_for_Group WHERE Group_ID = ?");
$stmt2->bind_param("i", $Group_ID);
$stmt2->execute();
$stmt2->close();
// 3. Delete from Course_Group_Schedule_Main
$stmt3 = $mysqli->prepare("DELETE FROM Course_Group_Schedule_Main WHERE Group_ID = ?");
$stmt3->bind_param("i", $Group_ID);
$stmt3->execute();
$stmt3->close();
// Return a response
//echo json_encode(['status' => 'success', 'message' => 'Schedule deleted.']);
echo json_encode(["status" => "success", "message" => "Schedule deleted successfully from teacher"]);
} catch (Exception $e) {
// Roll back the transaction on error.
$mysqli->rollback();
echo json_encode(["status" => "error", "message" => $e->getMessage()]);
}
}
?>