使用PHP Ajax从数据库加载更多搜索到的行加载相同的行

// PHP后端代码示例
$page = isset($_POST['page']) ? intval($_POST['page']) : 1;
$limit = 10; // 每页显示的行数
$offset = ($page - 1) * $limit;

$sql = "SELECT * FROM your_table WHERE condition LIMIT $limit OFFSET $offset";
$result = mysqli_query($conn, $sql);

$sql = "SELECT DISTINCT column_name FROM your_table WHERE condition LIMIT $limit OFFSET $offset";

// JavaScript Ajax请求示例
$.ajax({
    url: 'your_php_script.php',
    type: 'POST',
    data: { page: currentPage },
    cache: false, // 禁用缓存
    success: function(response) {
        // 处理响应数据
    }
});

let uniqueData = [];
response.forEach(item => {
    if (!uniqueData.some(uniqueItem => uniqueItem.id === item.id)) {
        uniqueData.push(item);
    }
});

<?php
$page = isset($_POST['page']) ? intval($_POST['page']) : 1;
$limit = 10;
$offset = ($page - 1) * $limit;

$sql = "SELECT DISTINCT * FROM your_table WHERE condition LIMIT $limit OFFSET $offset";
$result = mysqli_query($conn, $sql);

$data = [];
while ($row = mysqli_fetch_assoc($result)) {
    $data[] = $row;
}

echo json_encode($data);
?>

let currentPage = 1;

function loadMoreData() {
    $.ajax({
        url: 'your_php_script.php',
        type: 'POST',
        data: { page: currentPage },
        cache: false,
        success: function(response) {
            let uniqueData = [];
            response.forEach(item => {
                if (!uniqueData.some(uniqueItem => uniqueItem.id === item.id)) {
                    uniqueData.push(item);
                }
            });
            // 更新页面内容
            currentPage++;
        }
    });
}

// 绑定滚动事件或其他触发条件
$(window).scroll(function() {
    if ($(window).scrollTop() + $(window).height() == $(document).height()) {
        loadMoreData();
    }
});