?????????????? ?????????????? prepare("SELECT title, total_marks FROM assignments WHERE id = ?"); $stmt->execute([$assignment_id]); $assignment = $stmt->fetch(PDO::FETCH_ASSOC); if (!$assignment) { die("Assignment not found"); } $title = $assignment['title']; $total_possible = $assignment['total_marks']; /* ------------------------------ Pagination Setup ---------------------------------*/ $limit = 10; $page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1; $offset = ($page - 1) * $limit; /* ------------------------------ Count total attempts ---------------------------------*/ $stmt = $pdo->prepare("SELECT COUNT(*) FROM student_attempts WHERE assignment_id = ?"); $stmt->execute([$assignment_id]); $total_records = $stmt->fetchColumn(); $total_pages = ceil($total_records / $limit); /* ------------------------------ Fetch paginated results ---------------------------------*/ $query = " SELECT sa.id AS attempt_id, sa.started_at, sa.submitted_at, sa.total_obtained, st.student_name, st.admission_no, st.course FROM student_attempts sa LEFT JOIN students st ON sa.student_id = st.id WHERE sa.assignment_id = ? ORDER BY sa.id DESC LIMIT $limit OFFSET $offset"; $stmt = $pdo->prepare($query); $stmt->execute([$assignment_id]); $attempts = $stmt->fetchAll(PDO::FETCH_ASSOC); ?> Add Customers | Xcel Training Institute

Results for:

Student Admission No Course Started At Submitted At Obtained Total Status Action
Pending"; } else { echo "Completed"; } ?>