加载内容并逐个显示php ajax

Question

<script>
    function getfilter(str){
        if (str==""){
            document.getElementById("result").innerHTML="";
            return;
        }

        $.ajax({
            url: "Views/pfolioresult.php?q="+str,
            type: "GET",
            //  data: serializedData,
            success: function ( responseText ) {
                $("#result").html(responseText); 
            }
        });
    }
</script>

This code works correctly. But suppose I have 10,000 data in database. This code show all data at once after loading. How is it possible to show data one by one depending on load time. That means when one item is loaded then show it, and other continuously show.

Answer 1

Some idea, on how this could be done:

function show(skip)
{
    $.ajax({
        url: "Views/pfolioresult.php?skip=" + skip + "q="+str,
        type: "GET",
    //  data: serializedData,
        success: function ( responseText ) {
    $("#result").html(responseText); 
            skip++;
            show(skip);
        }
    });
}

show(0);

and your query in php should look like:

SELECT *
FROM a
LIMIT $skip, 1