<?php
include 'koneksi.php';
$stmt = $pdo->query('SELECT is_read, sender, count(*) as cnt FROM chats GROUP BY is_read, sender');
print_r($stmt->fetchAll(PDO::FETCH_ASSOC));
$stmt2 = $pdo->query('SELECT id_occupant FROM chats WHERE is_read = 0');
print_r($stmt2->fetchAll(PDO::FETCH_ASSOC));
?>