???????????????????? ?????????????????? ÿØÿà JFIF    ÿÛ C    !"$"$ÿÛ C  ÿ p " ÿÄ     ÿÄ   ÿÚ   ÕÔË® (% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤  @ adadasdasdasasdasdas .....................................................................................................................................???????????????????? ?????????????????? ÿØÿà JFIF    ÿÛ C    !"$"$ÿÛ C  ÿ p " ÿÄ     ÿÄ   ÿÚ   ÕÔË® (% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤  @ adadasdasdasasdasdas .....................................................................................................................................prepare("SELECT * FROM assignments WHERE id=?"); $stmt->execute([$assignment_id]); $assignment = $stmt->fetch(PDO::FETCH_ASSOC); if (!$assignment) die("Assignment not found."); // Pagination $limit = 10; $page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1; $offset = ($page - 1) * $limit; // Count total attempts $countStmt = $pdo->prepare("SELECT COUNT(*) FROM student_attempts WHERE assignment_id=?"); $countStmt->execute([$assignment_id]); $total_rows = $countStmt->fetchColumn(); // Fetch attempts $attemptStmt = $pdo->prepare(" SELECT sa.id AS attempt_id, sa.started_at, sa.submitted_at, sa.total_obtained, st.student_name, st.admission_no, st.course, a.total_marks AS total_possible FROM student_attempts sa JOIN students st ON sa.student_id = st.id JOIN assignments a ON sa.assignment_id = a.id WHERE sa.assignment_id = ? ORDER BY sa.id DESC LIMIT $limit OFFSET $offset "); $attemptStmt->execute([$assignment_id]); $attempts = $attemptStmt->fetchAll(PDO::FETCH_ASSOC); // ==================== CSV EXPORT =================== if (isset($_GET['export']) && $_GET['export'] == "csv") { header("Content-Type: text/csv"); header("Content-Disposition: attachment; filename=\"assignment_{$assignment_id}_results.csv\""); header("Pragma: no-cache"); header("Expires: 0"); $output = fopen("php://output", "w"); // Header fputcsv($output, [ "Student Name","Admission No","Course","Started At","Submitted At", "Total Obtained","Total Possible","Status" ]); $expStmt = $pdo->prepare(" SELECT sa.id AS attempt_id, sa.started_at, sa.submitted_at, sa.total_obtained, st.student_name, st.admission_no, st.course, a.total_marks AS total_possible FROM student_attempts sa JOIN students st ON sa.student_id = st.id JOIN assignments a ON sa.assignment_id = a.id WHERE sa.assignment_id = ? ORDER BY sa.id DESC "); $expStmt->execute([$assignment_id]); while ($r = $expStmt->fetch(PDO::FETCH_ASSOC)) { $status = $r['submitted_at'] ? "Submitted" : "In Progress"; fputcsv($output, [ $r['name'], $r['admission_no'], $r['course'], $r['started_at'], $r['submitted_at'], $r['total_obtained'], $r['total_possible'], $status ]); } fclose($output); exit; } ?> Add Customers | Xcel Training Institute

Add User

Results for Assignment:

Export CSV
Student Name Admission No Course Started Submitted Obtained Possible Status Action