---

<?php
$conn = new mysqli("localhost", "root", "", "requests");

$sql = "SELECT status, COUNT(*) AS total 
        FROM requests 
        GROUP BY status";

$result = $conn->query($sql);

$stats = [];

while ($row = $result->fetch_assoc()) {
    $stats[$row['status']] = $row['total'];
}

$total = array_sum($stats);
$work = $stats['В работе'] ?? 0;
$done = $stats['Завершено'] ?? 0;
?>