PHP : How to load data page by page in paging

Question

I have a 500 item data array, taken from the partner Database . I have finished pagination .

But the counterpart Database is very weak if it loads 500 item at a time, it is very heavy. Is there a way to finish downloading 30 item and then downloading the next 30 item?

To not load 500 items times .

Please help me, thank you !

Use Datatable, see here for more details : https://datatables.net/examples/data_sources/server_side — BhAvik Gajjar, Nov 04 '20 at 04:15
possible duplicate: https://stackoverflow.com/questions/3705318/simple-php-pagination-script — Suresh Kamrushi, Nov 05 '20 at 09:15

score 0 · Accepted Answer · answered Nov 04 '20 at 08:35

Load your first 30 datasets from the database, Then when the page has finished loading use ajax to send a request to the server to fetch the remaining records in batches of 30.

// ajax call to PHP script for processing.
var n= 1;
(function yourfunction () 
{

    $.ajax
    ({
        url:"yourphpscript.php",
        type:"POST",
        data:{'n':n},
        success:function(response)
        {
                        
            $("#the-display-area").append(response); 
            n+=1;//counter increement
        }
     })
})();

//PHP code to accept the post data of n from the ajax call and use it to query the 
database 

$n=$_POST["n"];
$n=$n*30;

    
$query = "SELECT * FROM yourtable LIMIT 30 OFFSET $n";

PHP : How to load data page by page in paging

1 Answers1