phpcms的ajax分页流程

function loadPage(pageNumber) {
    $.ajax({
        url: 'path/to/your/controller',
        type: 'GET',
        data: { page: pageNumber },
        dataType: 'json',
        success: function(data) {
            // 更新页面内容
            $('#content').html(data.content);
            // 更新分页链接
            $('#pagination').html(data.pagination);
        },
        error: function(xhr, status, error) {
            console.error('Error loading page:', error);
        }
    });
}

<?php
// 假设使用的是 phpCMS 框架
class YourController extends Controller {
    public function index() {
        $page = $_GET['page'] ? intval($_GET['page']) : 1;
        $limit = 10; // 每页显示的记录数
        $offset = ($page - 1) * $limit;

        // 查询数据库
        $sql = "SELECT * FROM your_table LIMIT $limit OFFSET $offset";
        $result = $this->db->query($sql);

        $data = [];
        while ($row = $result->fetch_assoc()) {
            $data[] = $row;
        }

        // 获取总记录数
        $totalSql = "SELECT COUNT(*) AS total FROM your_table";
        $totalResult = $this->db->query($totalSql);
        $total = $totalResult->fetch_assoc()['total'];

        // 计算总页数
        $totalPages = ceil($total / $limit);

        // 生成分页链接
        $pagination = '';
        for ($i = 1; $i <= $totalPages; $i++) {
            $pagination .= '<a href="#" onclick="loadPage(' . $i . ')">' . $i . '</a> ';
        }

        // 返回数据
        echo json_encode([
            'content' => $this->template->fetch('your_template', ['data' => $data]),
            'pagination' => $pagination
        ]);
    }
}
?>