phpcms调取最新文章

<?php
// 假设这是你的数据库连接代码
$host = 'localhost';
$dbname = 'phpcms';
$user = 'root';
$password = '';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $user, $password);
} catch (PDOException $e) {
    die("数据库连接失败: " . $e->getMessage());
}

// 查询最新文章
$sql = "SELECT * FROM articles ORDER BY publish_date DESC LIMIT 10";
$stmt = $pdo->query($sql);

if ($stmt->rowCount() > 0) {
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        echo "<h2>" . htmlspecialchars($row['title']) . "</h2>";
        echo "<p>" . htmlspecialchars($row['content']) . "</p>";
        echo "<p>发布日期: " . htmlspecialchars($row['publish_date']) . "</p>";
    }
} else {
    echo "没有找到文章";
}
?>