xgkblog/查看文件 - 码桶

大佬论坛
妙笔生花 / xgkblog 公开
main
xgkblog/page.php
page.php3.1 KB
<?php
// 1. 引入配置文件并连接数据库
if (!file_exists(__DIR__ . '/config.php')) {
    die('系统未安装！请先访问 <a href="install/">安装向导</a>');
}
require __DIR__ . '/config.php';

try {
    $dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=utf8mb4";
    $pdo = new PDO($dsn, DB_USER, DB_PASS, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
} catch (PDOException $e) {
    die("数据库连接失败：" . $e->getMessage());
}

// 2. 获取 URL 中的 slug 参数
$slug = $_GET['slug'] ?? null;

if (!$slug) {
    http_response_code(404);
    die('未指定页面路径');
}

// 3. 使用预处理语句查询数据库（防止 SQL 注入）
$stmt = $pdo->prepare("SELECT title, content FROM pages WHERE slug = :slug LIMIT 1");
$stmt->execute([':slug' => $slug]);
$page = $stmt->fetch(PDO::FETCH_ASSOC);

// 4. 如果查不到数据，返回 404
if (!$page) {
    http_response_code(404);
    die('页面不存在或已被删除');
}
?>

<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <!-- 动态设置页面标题 -->
    <title><?php echo htmlspecialchars($page['title']); ?> - 我的 PHP 博客</title>
    <style>
       
        nav ul { list-style: none; margin: 0; padding: 0; display: flex; gap: 5px; }
        nav ul li a { display: block; padding: 8px 12px; color: #ddd; text-decoration: none; font-size: 14px; border-radius: 4px; transition: 0.3s; }
        nav ul li a:hover { background-color: #555; color: #fff; }
        
       
        /* 文章内容样式 */
        
        .page-card { background: #fff; border-radius: 8px; box-shadow: 0 2px 5px rgba(0,0,0,0.05); padding: 35px; margin-bottom: 20px; }
        .page-title { font-size: 28px; margin: 0 0 20px; border-bottom: 2px solid #eee; padding-bottom: 15px; color: #222; }
        .page-content { font-size: 16px; line-height: 1.8; color: #444; }
        .page-content img { max-width: 100%; height: auto; border-radius: 4px; margin: 15px 0; }
        .back-home { display: inline-block; margin-top: 20px; color: #007bff; text-decoration: none; font-size: 14px; }
        .back-home:hover { text-decoration: underline; }
    </style>
</head>
<body>
   
<!-- 搜索弹窗 -->
    <?php require_once __DIR__ . '/search-tc.php'; ?>
    <div class="container">
        
        <?php require_once __DIR__ . '/header.php'; ?>
         <div class="main-content">
            <div class="content-left">
        
        <div class="page-card">
            <h2 class="page-title"><?php echo htmlspecialchars($page['title']); ?></h2>
            <div class="page-content">
                <!-- 直接输出正文内容 -->
                <?php echo $page['content']; ?> 
            </div>
          
        </div>
    </div>
    
    
    
    
   
    
      <?php require_once __DIR__ . '/sidebar-right.php'; ?>
        </div>
    
      <!-- 【结构优化】将 footer 移出 container，使其能够横跨整个屏幕宽度 -->
    <?php require_once __DIR__ . '/footer.php'; ?>
    </div>
    
   
    
    
    
    
</body>
</html>