prepare(" SELECT id, username, nama_lengkap, alamat, wa, tgl_lahir, role, foto FROM users WHERE role <> 'admin' ORDER BY (nama_lengkap <> ''), nama_lengkap ASC, username ASC "); $stmt->execute(); $anggota = $stmt->fetchAll(PDO::FETCH_ASSOC); $totalAnggota = count($anggota); } catch (Throwable $e) { $anggota = []; $totalAnggota = 0; } /* ========================= * Counter sederhana * ========================= */ $totalPengurus = 0; $totalAnggotaBiasa = 0; foreach ($anggota as $a) { if (($a['role'] ?? '') === 'pengurus') { $totalPengurus++; } else { $totalAnggotaBiasa++; } } ?>
