'Unauthorized']);
exit;
}
$Program_ID = intval($_POST['Program_ID'] ?? 0);
$Group_ID = intval($_POST['Group_ID'] ?? 0);
$Course_ID = intval($_POST['Course_ID'] ?? 0);
$sessions = [];
if ($Program_ID && $Group_ID && $Course_ID) {
$stmt = $mysqli->prepare("
SELECT scg.Schedule_ID, scg.Start_Date, scg.Time_Slot,
c.Course_Name, g.Group_Name, p.Program_Name
FROM schedule_course_for_group scg
JOIN Courses c ON scg.Course_ID = c.Course_ID
JOIN manager_group_name g ON scg.Group_ID = g.Group_ID
JOIN Programs p ON scg.Program_ID = p.Program_ID
WHERE scg.Program_ID = ? AND scg.Group_ID = ? AND scg.Course_ID = ?
ORDER BY scg.Start_Date DESC
");
$stmt->bind_param("iii", $Program_ID, $Group_ID, $Course_ID);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$row['action'] = "
";
$sessions[] = $row;
}
$stmt->close();
}
echo json_encode($sessions);