$status) { $stmt = $db->prepare("INSERT INTO attendance (student_id, class_id, status, attendance_date) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE status = ?"); $stmt->execute([(int)$student_id, $class_id, $status, $date, $status]); } $message = "Absensi berhasil disimpan untuk tanggal $date."; } $class = $db->prepare("SELECT * FROM classes WHERE id = ?"); $class->execute([$class_id]); $classData = $class->fetch(); $students = $db->prepare("SELECT s.id, s.full_name, a.status FROM students s LEFT JOIN attendance a ON s.id = a.student_id AND a.attendance_date = ? WHERE s.class_id = ?"); $students->execute([$date, $class_id]); $studentList = $students->fetchAll(); ?> Absensi — <?= htmlspecialchars($classData['name'] ?? 'Kelas') ?>

Absensi Kelas:

Nama Siswa	Status