prepare("SELECT * FROM courses WHERE id = ?"); $stmt->execute([$course_id]); $course = $stmt->fetch(); // B. 獲取該課程所有章節 $stmt = $pdo->prepare("SELECT * FROM course_materials WHERE course_id = ? ORDER BY week_number ASC"); $stmt->execute([$course_id]); $all_lessons = $stmt->fetchAll(); if (!isset($all_lessons[$day_index])) { die("找不到該章節"); } $current_lesson = $all_lessons[$day_index]; $lesson_id = $current_lesson['id']; // C. 獲取本課影片 $stmt = $pdo->prepare("SELECT * FROM lesson_videos WHERE lesson_id = ? ORDER BY video_order ASC"); $stmt->execute([$lesson_id]); $videos = $stmt->fetchAll(); // 預設播放影片邏輯 $current_video = isset($_GET['vid']) ? array_filter($videos, function($v) { return $v['id'] == $_GET['vid']; })[0] ?? ($videos[0] ?? null) : ($videos[0] ?? null); // D. 獲取作業資訊 $stmt = $pdo->prepare("SELECT * FROM assignments WHERE lesson_id = ?"); $stmt->execute([$lesson_id]); $assignment = $stmt->fetch(); // E. 檢查學生是否已提交作業 (解鎖關鍵) $is_assignment_submitted = false; if ($assignment) { // 檢查 student_assignments 表 $stmt = $pdo->prepare("SELECT id FROM student_assignments WHERE user_id = ? AND assignment_id = ?"); $stmt->execute([$student_id, $assignment['id']]); if ($stmt->rowCount() > 0) { $is_assignment_submitted = true; } } else { // 如果沒有作業，預設解鎖 $is_assignment_submitted = true; } // F. 獲取測驗題目 (僅當解鎖時顯示) $quizzes = []; if ($is_assignment_submitted) { $stmt = $pdo->prepare("SELECT * FROM quizzes WHERE lesson_id = ?"); $stmt->execute([$lesson_id]); $quizzes = $stmt->fetchAll(); } } catch (PDOException $e) { die("資料庫錯誤: " . $e->getMessage()); } ?> <?= htmlspecialchars($current_lesson['title']) ?> - <?= htmlspecialchars($course['title']) ?>

本課暫無影片

本課影片清單

共 個單元
$v): $is_active = ($current_video && $v['id'] == $current_video['id']); ?>

本週作業

已提交 未完成
立即交功課

完成上傳後，下方測驗將自動解鎖。

本課無作業

隨堂小測驗

測驗前閱讀

0): ?>
$q): ?>

Q.

本課暫無測驗題目

測驗已鎖定

請先完成上方「本週作業」上傳，系統將自動解鎖測驗與閱讀內容。