phpcms 随机文章

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

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

// 随机获取指定数量的文章
$articleCount = 5; // 想要获取的文章数量
$sql = "SELECT * FROM articles ORDER BY RAND() LIMIT :count";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':count', $articleCount, PDO::PARAM_INT);
$stmt->execute();
$articles = $stmt->fetchAll(PDO::FETCH_ASSOC);

// 输出文章列表
foreach ($articles as $article) {
    echo '<h2>' . htmlspecialchars($article['title']) . '</h2>';
    echo '<p>' . htmlspecialchars($article['content']) . '</p>';
}
?>

// 获取文章总数
$totalRows = $pdo->query('SELECT COUNT(*) FROM articles')->fetchColumn();
// 随机获取起始ID
$startId = mt_rand(0, $totalRows - $articleCount);
// 根据起始ID获取文章
$sql = "SELECT * FROM articles WHERE id >= :startId ORDER BY id ASC LIMIT :count";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':startId', $startId, PDO::PARAM_INT);
$stmt->bindParam(':count', $articleCount, PDO::PARAM_INT);
$stmt->execute();
$articles = $stmt->fetchAll(PDO::FETCH_ASSOC);

// 假设你有一个方法来获取上次展示的文章ID列表
$lastShownIds = getLastShownArticleIds();

// 在查询时排除这些ID
$sql = "SELECT * FROM articles WHERE id NOT IN (:ids) ORDER BY RAND() LIMIT :count";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':ids', implode(',', $lastShownIds), PDO::PARAM_STR);
$stmt->bindParam(':count', $articleCount, PDO::PARAM_INT);
$stmt->execute();
$articles = $stmt->fetchAll(PDO::FETCH_ASSOC);