dedecms sql怎么分页

<?php
// 假设每页显示10条记录
$pagesize = 10;
// 获取当前页码，默认为第一页
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
// 计算偏移量
$offset = ($page - 1) * $pagesize;

// 构建SQL查询语句
$sql = "SELECT * FROM `dede_archives` LIMIT $offset, $pagesize";

// 执行查询
$result = mysqli_query($conn, $sql);

// 处理查询结果
while ($row = mysqli_fetch_assoc($result)) {
    // 输出数据
    echo $row['title'] . "<br>";
}

// 构建分页链接
$total_rows = mysqli_num_rows(mysqli_query($conn, "SELECT COUNT(*) FROM `dede_archives`"));
$total_pages = ceil($total_rows / $pagesize);
for ($i = 1; $i <= $total_pages; $i++) {
    echo "<a href='?page=$i'>$i</a> ";
}
?>