prepare("SELECT full_name FROM students WHERE id = ?");
$student->execute([$student_id]);
$student_name = $student->fetchColumn();
// جلب الجدول الدراسي مع اسم الكورس
$stmt = $conn->prepare("
SELECT ss.*, c.course_name
FROM student_schedules ss
JOIN courses c ON ss.course_id = c.id
WHERE ss.student_id = ?
ORDER BY FIELD(day_name, 'Saturday', 'Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday'), start_time
");
$stmt->execute([$student_id]);
$schedules = $stmt->fetchAll(PDO::FETCH_ASSOC);
include('../includes/header.php');
include('../includes/navbar.php');
?>
