phpcms获取网站访问量

<?php
// 假设我们有一个数据库表 'visits'，包含字段 'id', 'page', 'visits'

// 连接数据库
$db = pc_base::load_config('database');
$mysqli = new mysqli($db['hostname'], $db['username'], $db['password'], $db['database']);

// 获取总访问量
$total_visits_query = "SELECT SUM(visits) AS total_visits FROM visits";
$total_visits_result = $mysqli->query($total_visits_query);
$total_visits_row = $total_visits_result->fetch_assoc();
$total_visits = $total_visits_row['total_visits'];

// 获取独立访客数
$unique_visitors_query = "SELECT COUNT(DISTINCT ip) AS unique_visitors FROM visits WHERE timestamp >= NOW() - INTERVAL 1 DAY";
$unique_visitors_result = $mysqli->query($unique_visitors_query);
$unique_visitors_row = $unique_visitors_result->fetch_assoc();
$unique_visitors = $unique_visitors_row['unique_visitors'];

// 获取页面浏览量
$page_views_query = "SELECT page, visits FROM visits ORDER BY visits DESC LIMIT 10";
$page_views_result = $mysqli->query($page_views_query);
$page_views = [];
while ($page_views_row = $page_views_result->fetch_assoc()) {
    $page_views[] = $page_views_row;
}

// 关闭数据库连接
$mysqli->close();

// 输出结果
echo "总访问量: " . $total_visits . "<br>";
echo "独立访客数: " . $unique_visitors . "<br>";
echo "页面浏览量: <br>";
foreach ($page_views as $view) {
    echo $view['page'] . ": " . $view['visits'] . "<br>";
}
?>