php - Pagination error while using datatable -


i using jquery datatable plugin. working fine except pagination part.its showing 1 10 records(filtered 22000 records).since there 10 records next , buttons not working

the following code

$(document).ready(function() { $('#example').datatable( {      "bprocessing": "true",     "bserverside": "true",     "bpaginate": "true",     "idisplaylength": 10,     "spaginationtype": "full_numbers",     "sajaxsource": "ailsdsw.php?b=<?php echo $_session['brcd_se32'] ?>";   } ); } ); 

the json ouput goe this

 {"secho":0,"itotalrecords":"22289","itotaldisplayrecords":"22289","aadata":[["301","1","40353",....]]}  

can explain me why pagination not working

the totals should ints. try w/o strings in json around values:

"itotalrecords":22289, "itotaldisplayrecords":22289 

int itotalrecords total records, before filtering (i.e. total number of records in database)

int itotaldisplayrecords total records, after filtering (i.e. total number of records after filtering has been applied - not number of records being returned in result set)


Comments