query("SELECT id, full_name FROM students ORDER BY full_name")->fetchAll(PDO::FETCH_ASSOC);
if ($selected_student_id) {
// 2. جلب الدورات التي سجل بها الطالب فقط
$stmt = $conn->prepare("SELECT c.id, c.course_name FROM courses c
JOIN enrollments e ON c.id = e.course_id
WHERE e.student_id = ?");
$stmt->execute([$selected_student_id]);
$enrolled_courses = $stmt->fetchAll(PDO::FETCH_ASSOC);
// 3. جلب الجدول الدراسي الحالي (يتضمن وقت البداية والنهاية)
$schedStmt = $conn->prepare("SELECT * FROM student_schedules WHERE student_id = ?");
$schedStmt->execute([$selected_student_id]);
$existing_schedule = $schedStmt->fetchAll(PDO::FETCH_ASSOC);
}
include('../includes/header.php');
include('../includes/navbar.php');
?>