phpcms 分页调用

<?php
// 假设我们有一个数据库连接
$db = new PDO('mysql:host=localhost;dbname=phpcms', 'username', 'password');

// 获取当前页码，默认为第一页
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$pagesize = 10; // 每页显示的记录数

// 计算偏移量
$offset = ($page - 1) * $pagesize;

// 查询数据
$sql = "SELECT * FROM articles LIMIT :offset, :pagesize";
$stmt = $db->prepare($sql);
$stmt->bindParam(':offset', $offset, PDO::PARAM_INT);
$stmt->bindParam(':pagesize', $pagesize, PDO::PARAM_INT);
$stmt->execute();

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

// 获取总记录数
$total_sql = "SELECT COUNT(*) FROM articles";
$total_stmt = $db->query($total_sql);
$total = $total_stmt->fetchColumn();

// 计算总页数
$total_pages = ceil($total / $pagesize);

// 输出分页链接
for ($i = 1; $i <= $total_pages; $i++) {
    echo "<a href='?page=$i'>$i</a> ";
}

// 输出数据
foreach ($articles as $article) {
    echo "<h2>{$article['title']}</h2>";
    echo "<p>{$article['content']}</p>";
}
?>