prepare("SELECT id, name FROM courses WHERE teacher_id = ?");
$stmt->execute([$teacher_id]);
return $stmt->fetchAll(PDO::FETCH_ASSOC);
}
// Function to get student activities for a course
function getStudentActivities($course_id) {
$pdo = db();
$stmt = $pdo->prepare("
SELECT u.email, a.activity_name, a.grade, a.activity_date
FROM activities a
JOIN enrollments e ON a.enrollment_id = e.id
JOIN users u ON e.student_id = u.id
WHERE e.course_id = ?
ORDER BY a.activity_date DESC
");
$stmt->execute([$course_id]);
return $stmt->fetchAll(PDO::FETCH_ASSOC);
}
$courses = getTeacherCourses($_SESSION['user_id']);
$activities = [];
foreach ($courses as $course) {
$activities[$course['name']] = getStudentActivities($course['id']);
}
}
?>