query("
SELECT COUNT(*)
FROM ocorrencias
WHERE status<>'Finalizada'
")->fetchColumn();
$totalViaturas = $pdo->query("
SELECT COUNT(*)
FROM viaturas
WHERE status='Disponivel'
")->fetchColumn();
$totalBombeiros = $pdo->query("
SELECT COUNT(*)
FROM bombeiros
")->fetchColumn();
$ocorrencias = $pdo->query("
SELECT
numero_ocorrencia,
tipo_ocorrencia,
bairro,
status
FROM ocorrencias
ORDER BY id DESC
LIMIT 10
")->fetchAll(PDO::FETCH_ASSOC);
?>
Central Operacional