'; exit;
}
// --------------------------
$pdo = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME.";charset=utf8mb4", DB_USER, DB_PASS);
$total = $pdo->query("SELECT visits FROM counter WHERE id=1")->fetchColumn();
// visite ultimi 30 giorni
$data = $pdo->query("
SELECT visit_date, COUNT(*) as unici
FROM counter_log
WHERE visit_date >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)
GROUP BY visit_date ORDER BY visit_date ASC
")->fetchAll(PDO::FETCH_ASSOC);
$labels = json_encode(array_column($data, 'visit_date'));
$values = json_encode(array_column($data, 'unici'));
?>
Stats Contatore