/home/techb158/workloadmatch.com/api/chat
Edit: /home/techb158/workloadmatch.com/api/chat/unread_count.php (745B)
0]);
exit;
}
$user_type = $_GET['user_type'] ?? 'manager';
$stmt = $mysqli->prepare("SELECT COUNT(*) AS cnt FROM chat_messages WHERE receiver_id = ? AND receiver_type = ? AND is_read = 0");
if (!$stmt) {
echo json_encode(['count' => 0]);
exit;
}
$stmt->bind_param("is", $userId, $user_type);
$stmt->execute();
$res = $stmt->get_result();
$row = $res->fetch_assoc();
echo json_encode(['count' => (int)$row['cnt']]);
$stmt->close();
$mysqli->close();