jQuery Datatable: Server side processing to fetch data from DB on click of Next

Question

I used a datatable to display records which i fetch from DB, now i have to customize it so that a new DB call is made to fetch the next 10 records from DB (Server side) on click of Next button provided by datatable.

Does anyone have any idea about this?

Thanks.

have a look at `iDisplayStart` and `iDisplayLength` – markpsmith Sep 08 '14 at 16:17 — markpsmith, Sep 08 '14 at 16:17

score 0 · Answer 1 · answered Sep 08 '14 at 07:57

I never tried this but I think you can assign a var in jquery which gets increased by 10 whenever the Ajax call is success and fetches Data from DB. Send this var to the called function by Ajax and accordingly you can create SQL statement with rownum value as this var of jQuery.

score 0 · Answer 2 · edited May 23 '17 at 10:29

0

You may use fnDrawCallback or fnInfoCallback to detect changes, when next is clicked both of them are fired.

But beware,page changes are not the only source that can fire those callbacks.

Detect page change on DataTable

edited May 23 '17 at 10:29

Community

1
1

answered Feb 06 '17 at 06:48

usama

31
4

jQuery Datatable: Server side processing to fetch data from DB on click of Next

2 Answers2