dedecms 留言分页

// 数据库查询语句
$sql = "SELECT * FROM `dede_feedback` LIMIT $offset, $pagesize";
$result = mysqli_query($conn, $sql);

// 获取总记录数
$total_sql = "SELECT COUNT(*) AS total FROM `dede_feedback`";
$total_result = mysqli_query($conn, $total_sql);
$total_row = mysqli_fetch_assoc($total_result);
$total = $total_row['total'];

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

// 显示分页控件
for ($i = 1; $i <= $total_pages; $i++) {
    echo "<a href='?page=$i'>$i</a> ";
}

// 获取当前页码
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;

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

// 数据库查询语句
$sql = "SELECT * FROM `dede_feedback` LIMIT $offset, $pagesize";
$result = mysqli_query($conn, $sql);