dedecms 分页

// 确保分页参数正确传递
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$pagesize = 10; // 每页显示的记录数

// 查询数据时使用LIMIT进行分页
$sql = "SELECT * FROM `dede_archives` LIMIT " . ($page - 1) * $pagesize . ", $pagesize";
$result = mysqli_query($conn, $sql);

// 获取总记录数
$total_sql = "SELECT COUNT(*) FROM `dede_archives`";
$total_result = mysqli_query($conn, $total_sql);
$total_rows = mysqli_fetch_row($total_result)[0];

// 生成分页链接
$page_links = '';
$total_pages = ceil($total_rows / $pagesize);
for ($i = 1; $i <= $total_pages; $i++) {
    $page_links .= "<a href='?page=$i'>$i</a> ";
}

// 确保LIMIT参数正确
$sql = "SELECT * FROM `dede_archives` ORDER BY id DESC LIMIT " . ($page - 1) * $pagesize . ", $pagesize";
$result = mysqli_query($conn, $sql);

// 使用覆盖索引优化查询
$sql = "SELECT id, title FROM `dede_archives` ORDER BY id DESC LIMIT " . ($page - 1) * $pagesize . ", $pagesize";
$result = mysqli_query($conn, $sql);