setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Fetch unique available dates from the database
$dateQuery = "
SELECT DISTINCT
CONCAT(year, '-', LPAD(month, 2, '0'), '-', LPAD(day, 2, '0')) AS full_date
FROM att_table
ORDER BY full_date DESC";
$dateStmt = $pdo->prepare($dateQuery);
$dateStmt->execute();
$dates = $dateStmt->fetchAll(PDO::FETCH_COLUMN);
} catch (PDOException $e) {
echo "Error: " . htmlspecialchars($e->getMessage()) . "
";
exit;
}
?>
Attendance Logs
CNSAT Attendance Logs
| Date |
Section |
Name / ID |
Log Type |
Time |
| Select a date to load logs. |