phpcms调用热门文章

<?php
// 假设我们有一个数据库连接
$host = 'localhost';
$dbname = 'phpcms';
$user = 'root';
$pass = '';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $user, $pass);

    // 查询热门文章，假设我们有一个字段叫做 view_count 表示浏览次数
    $stmt = $pdo->query("SELECT title, content, view_count FROM articles ORDER BY view_count DESC LIMIT 10");

    $hot_articles = $stmt->fetchAll(PDO::FETCH_ASSOC);

    foreach ($hot_articles as $article) {
        echo "<h2>{$article['title']}</h2>";
        echo "<p>{$article['content']}</p>";
        echo "<p>浏览次数: {$article['view_count']}</p>";
    }
} catch (PDOException $e) {
    echo "数据库连接失败: " . $e->getMessage();
}
?>