dedecms php首页分页

// 假设我们有一个文章表 article，包含 id, title, content 等字段
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$pagesize = 10; // 每页显示10条记录
$offset = ($page - 1) * $pagesize;

$sql = "SELECT id, title FROM article ORDER BY id DESC LIMIT $offset, $pagesize";
$result = mysqli_query($conn, $sql);

$articles = [];
while ($row = mysqli_fetch_assoc($result)) {
    $articles[] = $row;
}

$sql = "SELECT COUNT(*) as total FROM article";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$total = $row['total'];
$totalPages = ceil($total / $pagesize);

<div>
    <ul>
        <?php foreach ($articles as $article): ?>
            <li><a href="article.php?id=<?php echo $article['id']; ?>"><?php echo $article['title']; ?></a></li>
        <?php endforeach; ?>
    </ul>
</div>

<div class="pagination">
    <?php for ($i = 1; $i <= $totalPages; $i++): ?>
        <a href="index.php?page=<?php echo $i; ?>"><?php echo $i; ?></a>
    <?php endfor; ?>
</div>