problem with paging and server-side processing
problem with paging and server-side processing
hello,
I implemented the server-side process, it works correctly with filters and searches but not with paging. the next and previous buttons are not enabled even though the total number of rows are more than 2500 and "iDisplayLength" is enhanced to 20. LIMIT query works properly by 0.20 at the beginning but then I do not know how to change the page. Can you help? here's how to initialize the table:
[code]
source = "index.php?mp=PAGE_ELENCO_ORDINI_AJ";
oTab_elenco_ordini = $('#tab_elenco_ordini').dataTable( {
"bStateSave": true,
"bProcessing": true,
"bServerSide": true,
"bJQueryUI": true,
"sAjaxSource": source,
"sDom": "<'toolbar'>frtip",
"sPaginationType": "two_button",
"iDisplayLength": 20,
"aLengthMenu": [[20, 50, 100, -1], [20, 50, 100, "Tutti"]],
"oLanguage": {
"sProcessing": "Caricamento...",
"sLengthMenu": "Visualizza _MENU_ ordini",
"sZeroRecords": "La ricerca non ha portato alcun risultato.",
"sInfo": "Vista da _START_ a _END_ di _TOTAL_ ordini",
"sInfoEmpty": "Vista da 0 a 0 di 0 elementi",
"sInfoFiltered": "(filtrati da _MAX_ ordini totali)",
"sInfoPostFix": "",
"sSearch": "Cerca:",
"sUrl": "",
"oPaginate": {
"sFirst": "Inizio",
"sPrevious": "Precedente",
"sNext": "Successivo",
"sLast": "Fine"
}
}
})
[/code]
I implemented the server-side process, it works correctly with filters and searches but not with paging. the next and previous buttons are not enabled even though the total number of rows are more than 2500 and "iDisplayLength" is enhanced to 20. LIMIT query works properly by 0.20 at the beginning but then I do not know how to change the page. Can you help? here's how to initialize the table:
[code]
source = "index.php?mp=PAGE_ELENCO_ORDINI_AJ";
oTab_elenco_ordini = $('#tab_elenco_ordini').dataTable( {
"bStateSave": true,
"bProcessing": true,
"bServerSide": true,
"bJQueryUI": true,
"sAjaxSource": source,
"sDom": "<'toolbar'>frtip",
"sPaginationType": "two_button",
"iDisplayLength": 20,
"aLengthMenu": [[20, 50, 100, -1], [20, 50, 100, "Tutti"]],
"oLanguage": {
"sProcessing": "Caricamento...",
"sLengthMenu": "Visualizza _MENU_ ordini",
"sZeroRecords": "La ricerca non ha portato alcun risultato.",
"sInfo": "Vista da _START_ a _END_ di _TOTAL_ ordini",
"sInfoEmpty": "Vista da 0 a 0 di 0 elementi",
"sInfoFiltered": "(filtrati da _MAX_ ordini totali)",
"sInfoPostFix": "",
"sSearch": "Cerca:",
"sUrl": "",
"oPaginate": {
"sFirst": "Inizio",
"sPrevious": "Precedente",
"sNext": "Successivo",
"sLast": "Fine"
}
}
})
[/code]
This discussion has been closed.