query("SELECT COUNT(*) FROM usuarios")->fetchColumn(); $totalColabs = $pdo->query("SELECT COUNT(*) FROM usuarios WHERE tipo='colaborador'")->fetchColumn(); $totalAtivos = $pdo->query("SELECT COUNT(*) FROM usuarios WHERE ativo=1")->fetchColumn(); $recentLogins = $pdo->query("SELECT l.*, u.nome, u.email, u.tipo FROM log_acessos l JOIN usuarios u ON l.usuario_id=u.id ORDER BY l.data_hora DESC LIMIT 10")->fetchAll(); require_once __DIR__ . '/../includes/header.php'; ?>
| UsuÔrio | Tipo | Ação | IP | Data/Hora |
|---|---|---|---|---|
| = sanitize($log['nome']) ?> | = $log['tipo'] ?> | = sanitize($log['acao']) ?> | = sanitize($log['ip']) ?> | = date('d/m/Y H:i', strtotime($log['data_hora'])) ?> |
| Nenhum acesso registrado | ||||