xgkblog/查看文件 - 码桶

<?php
// 1. 强制声明 $pdo 为全局变量（解决 require 作用域问题）
global $pdo;

// 2. 如果 global 之后还是 null，尝试手动引入一次 config.php
if (!$pdo instanceof PDO) {
    // 注意：请根据你的实际路径修改下面这行！
    $config_path = __DIR__ . '/../config.php'; 
    if (file_exists($config_path)) {
        require_once $config_path;
    }
}

// 3. 再次检查是否连接成功
if (!$pdo instanceof PDO) {
    die("后台统计面板错误：数据库连接失败，请检查 config.php 是否正确引入。");
}

// 4. 执行统计查询...
$sql = "SELECT 
            (SELECT COUNT(*) FROM posts) as posts,
            (SELECT COUNT(*) FROM comments WHERE status='approved') as comments,
            (SELECT COUNT(*) FROM tags) as tags,
            (SELECT COUNT(*) FROM links) as links,
            (SELECT COUNT(*) FROM pages) as pages";

$stats = $pdo->query($sql)->fetch(PDO::FETCH_ASSOC);
$stats = array_map(function($val) { return $val ?? 0; }, $stats);
?>

<!-- 统计卡片 -->
<div class="stats-grid">
    <div class="card">
        <div class="card-header"><span class="card-title">📝 总文章数</span></div>
        <div class="card-value"><?php echo $stats['posts']; ?></div>
        <span class="card-trend trend-up">网站统计文章</span>
    </div>
    
    <div class="card">
        <div class="card-header"><span class="card-title">💬 评论总数</span></div>
        <div class="card-value"><?php echo $stats['comments']; ?></div>
        <span class="card-trend trend-up">网站统计评论</span>
    </div>
    
    <div class="card">
        <div class="card-header"><span class="card-title">🏷️ 标签总数</span></div>
        <div class="card-value"><?php echo $stats['tags']; ?></div>
        <span class="card-trend trend-down">这个没有开发</span>
    </div>
    
    <div class="card">
        <div class="card-header"><span class="card-title">🔗 友链总数</span></div>
        <div class="card-value"><?php echo $stats['links']; ?></div>
        <span class="card-trend trend-up">网站统计友链</span>
    </div>

    <!-- 新增：独立页统计 -->
    <div class="card">
        <div class="card-header"><span class="card-title">📄 独立页总数</span></div>
        <div class="card-value"><?php echo $stats['pages']; ?></div>
        <span class="card-trend trend-up">网站统计页面</span>
    </div>
</div>