connect_error) {
die("Connection failed: " . $conn->connect_error);
}
/*
ACTIVE LEARNERS:
- Practiced at least once in last 7 days
*/
$sql = "
SELECT
pa.roll_no,
MAX(pa.last_attempt_at) AS last_practice_date,
DATEDIFF(NOW(), MAX(pa.last_attempt_at)) AS days_gap
FROM practice_attempts pa
GROUP BY pa.roll_no
HAVING
MAX(pa.last_attempt_at) >= NOW() - INTERVAL 7 DAY
ORDER BY last_practice_date DESC
";
$result = $conn->query($sql);
?>
Active Learners
🟢 Active Learners (Last 7 Days)
These students are maintaining learning continuity.
| Roll No |
Last Practice Date |
Days Since Last Practice |
num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo "
| {$row['roll_no']} |
{$row['last_practice_date']} |
{$row['days_gap']} day(s) |
";
}
} else {
echo "
| No active learners yet |
";
}
?>
close(); ?>