Jquery datatables server side pagination
Jquery datatables server side pagination
I have been using jquery datatables. I want to do pagination from server side. If I have 100 records in my database and my page size is 20, I would retrieve only 20 records at a time. So my pagination now should have five buttons, one previous button and one next button. I am using bootstratp pagination. Whenever I click on a pagination button, the data should be fetched from database.
But I am not able to achieve. Please suggest me a way forward. Any help would be appreciated.
Answers
You'd need to supply some more information on this, does the paging event fire? Can you see in your browser (firebug or other debugging console) the request to the server? What parameters are being passed and what is the server response? I'd suggest using Firefox and firebug to let you see what's going on initially then post some more information when you have it.