prepare(" SELECT c.* FROM courses c JOIN course_students cs ON c.id = cs.course_id WHERE cs.student_id = ? AND c.status = 'active' "); $stmt->execute([$student_id]); $enrolled_courses = $stmt->fetchAll(PDO::FETCH_ASSOC); } render_head( t('Student dashboard', 'لوحة الطالب'), t('Review the active subscription, upcoming live classes, and access to subject detail pages.', 'راجع الاشتراك النشط والفصول المباشرة القادمة والوصول إلى صفحات تفاصيل المواد.') ); render_nav('dashboard.php'); ?>

prepare(" SELECT * FROM course_live_lessons WHERE course_id = ? AND status != 'ended' ORDER BY scheduled_at ASC LIMIT 1 "); $live_stmt->execute([$course['id']]); $next_lesson = $live_stmt->fetch(PDO::FETCH_ASSOC); ?>