在php中对ajax应用jQuery分页

<script src="https://cdn.jsdelivr.net/jquery/3.6.0/jquery.min.js"></script>

<div id="pagination"></div>

// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");

// 获取总记录数
$result = mysqli_query($conn, "SELECT COUNT(*) as total FROM table");
$row = mysqli_fetch_assoc($result);
$totalRecords = $row['total'];

// 每页显示的记录数
$recordsPerPage = 10;

// 计算总页数
$totalPages = ceil($totalRecords / $recordsPerPage);

// 获取当前页数
if (isset($_GET['page'])) {
    $currentPage = $_GET['page'];
} else {
    $currentPage = 1;
}

// 计算查询的起始位置
$start = ($currentPage - 1) * $recordsPerPage;

// 查询数据
$query = "SELECT * FROM table LIMIT $start, $recordsPerPage";
$result = mysqli_query($conn, $query);

// 处理查询结果
while ($row = mysqli_fetch_assoc($result)) {
    // 处理每条记录
}

$(document).ready(function() {
    function loadPage(page) {
        $.ajax({
            url: 'pagination.php',
            type: 'GET',
            data: { page: page },
            success: function(response) {
                $('#pagination').html(response);
            }
        });
    }

    // 初始化加载第一页数据
    loadPage(1);

    // 处理分页链接的点击事件
    $(document).on('click', '#pagination a', function(e) {
        e.preventDefault();
        var page = $(this).data('page');
        loadPage(page);
    });
});

// 生成分页链接
$pagination = '';
for ($i = 1; $i <= $totalPages; $i++) {
    $active = ($i == $currentPage) ? 'active' : '';
    $pagination .= '<a href="#" class="' . $active . '" data-page="' . $i . '">' . $i . '</a>';
}

// 返回分页链接
echo $pagination;