phpcms ajax分页代码

$(document).ready(function() {
    var page = 1;
    var perPage = 10;

    function loadPage(pageNumber) {
        $.ajax({
            url: 'path/to/your/controller.php',
            type: 'GET',
            data: { page: pageNumber, perPage: perPage },
            success: function(data) {
                $('#content').html(data);
            },
            error: function(xhr, status, error) {
                console.error("AJAX Error: " + status + error);
            }
        });
    }

    loadPage(page);

    $(document).on('click', '.pagination a', function(e) {
        e.preventDefault();
        page = $(this).attr('data-page');
        loadPage(page);
    });
});

<?php
// 假设你有一个数据库连接
$db = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$perPage = isset($_GET['perPage']) ? intval($_GET['perPage']) : 10;
$offset = ($page - 1) * $perPage;

$stmt = $db->prepare("SELECT * FROM your_table LIMIT :limit OFFSET :offset");
$stmt->bindParam(':limit', $perPage, PDO::PARAM_INT);
$stmt->bindParam(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();

$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($results as $row) {
    // 输出你的内容
    echo '<div>' . $row['title'] . '</div>';
}

// 分页链接
$totalRows = $db->query("SELECT COUNT(*) FROM your_table")->fetchColumn();
$totalPages = ceil($totalRows / $perPage);

for ($i = 1; $i <= $totalPages; $i++) {
    echo '<a href="#" data-page="' . $i . '">' . $i . '</a> ';
}
?>