Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

jQuery Datatables pagination setting

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();
    }
});
like image 915
nielsv Avatar asked Dec 06 '13 11:12

nielsv


2 Answers

try this:

$("#myDataTable").dataTables({
     "bJQueryUI":true,
      "bSort":false,
      "bPaginate":true,
      "sPaginationType":"full_numbers",
       "iDisplayLength": 10
});
like image 159
Mr.G Avatar answered Oct 24 '22 00:10

Mr.G


$('#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
like image 38
Hasnain Mehmood Avatar answered Oct 23 '22 23:10

Hasnain Mehmood