how to use pagination more then 1000 records in a data table?

jamu

i have more then 2000 records in my data base.
but the datatable show only 1000 records . how can i get my remaining data?

kthorngren

That would be up to the server script DB query. It may have some sort of filtering or limit in the query.

Kevin

colin

Hi @jamu,

The count is in the response when serverSide is enabled. The best bet would be take a look at the example here, and compare those values with yours. The full information is here.

Cheers,

Colin

jamu

can you send me the example code

jamu

thank your colin for ur example

jamu

i want to get data form database. can you send me the example with database mysql?

allan

The example Colin linked you to contains the code to get the data from a MySQL database. See the PHP source code here.

Allan

colin

Hi @jamu ,

If you look at that example I posted above, there's a tab called "Server Side Script", you can use that as a template.

Cheers,

Colin

jamu

tq friends