8 lines
294 B
PHP
8 lines
294 B
PHP
<?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));
|
|
?>
|