prepare("SELECT * FROM users WHERE username = ?"); $stmt->execute([$username]); $user = $stmt->fetch(); // Fetch user attendance $stmt = db()->prepare("SELECT attendance_date, status FROM attendance WHERE user_id = ? ORDER BY attendance_date DESC"); $stmt->execute([$user['id']]); $attendance_records = $stmt->fetchAll(); ?>
Name:
Username:
Role:
| Date | Status |
|---|---|
| No attendance records found. | |