prepare("SELECT * FROM pages WHERE slug = 'about' AND status = 'published' LIMIT 1"); $stmt->execute(); $page = $stmt->fetch(); $title = $page['title'] ?? getSetting('about_title', '关于'); $content = $page['content_html'] ?? ''; if (empty($content) && !empty($page['content'])) { $content = parseMarkdown($page['content']); } if (empty($content)) { $content = '

' . nl2br(h(getSetting('about_content', '欢迎来到我的私人日记空间。'))) . '

'; } // 获取一些统计 $postCount = (int)$db->query("SELECT COUNT(*) FROM posts WHERE status = 'published' AND is_public = 1")->fetchColumn(); $commentCount = (int)$db->query("SELECT COUNT(*) FROM comments WHERE status = 'approved'")->fetchColumn(); $tagCount = (int)$db->query("SELECT COUNT(*) FROM tags")->fetchColumn(); // 获取用户信息 $user = $db->query("SELECT * FROM users WHERE role = 'admin' ORDER BY id ASC LIMIT 1")->fetch(); $pageTitle = $title; include ROOT_PATH . '/includes/header.php'; ?>
头像
person

日记
留言
标签