jQuery Datatables pagination setting
76,925
Solution 1
try this:
$("#myDataTable").dataTables({
"bJQueryUI":true,
"bSort":false,
"bPaginate":true,
"sPaginationType":"full_numbers",
"iDisplayLength": 10
});
Solution 2
$('#example').dataTable( {
"pagingType": "full_numbers"
} );
DataTables has six built-in paging button arrangements:
numbers - Page number buttons only (1.10.8)
simple - 'Previous' and 'Next' buttons only
simple_numbers - 'Previous' and 'Next' buttons, plus page numbers
full - 'First', 'Previous', 'Next' and 'Last' buttons
full_numbers - 'First', 'Previous', 'Next' and 'Last' buttons, plus page numbers
first_last_numbers - 'First' and 'Last' buttons, plus page numbers
Author by
nielsv
Updated on July 09, 2022Comments
-
nielsv almost 2 years
I'm trying to work with the pagination of the jquery datatables. I load the data with ajax. My response is now:
aaData: [[:anonymous:, null, 2012-07-29 08:28:21, 0, 85 million, null],…] iTotalDisplayRecords: 70 iTotalRecords: 70 sEcho: 1
All of my records (70) are shown, how can I make them paginate and have for ex 10 records per page?
I tried settings iTotalDisplayRecords to 10 but it shows the same result.
My datatable init:
myDataTable = $('#datatablesresults').dataTable({ bProcessing : true, sProcessing : true, bServerSide : true, sAjaxSource : '/results/load-results?' + getParams, aoColumnDefs : [{'bSortable' : false, 'aTargets' : ['no-sort']}], // make the actions column unsortable sPaginationType : 'full_numbers', fnDrawCallback : function(oSettings) { _initTable(); } });