php - data tables showing all records instead of pagination while giving data through server json -
this json output.
{     "draw": 0,     "recordstotal": 130,     "recordsfiltered": 130,     "data": [         {             "order_id": "32",             "location_address": "xyz road delhi delhi",             "order_status": "0",             "created_by": "5",             "from_date": "mar-30-2015",             "emp_name": " ",             "actions": "\r\n\t\t\t\t\t<a onclick=\"show_edit()\" class=\"btn default btn-xs purple \">\r\n                                               <i class=\"fa fa-edit\" ></i> edit </a>"         },         {             "order_id": "33",             "location_address": "xyz road delhi delhi",             "order_status": "0",             "created_by": "5",             "from_date": "mar-30-2015",             "emp_name": " ranjeet thakur, abhijeet thakur",             "actions": "\r\n\t\t\t\t\t<a onclick=\"show_edit()\" class=\"btn default btn-xs purple \">\r\n                                               <i class=\"fa fa-edit\" ></i> edit </a>"         },         {             "order_id": "34",             "location_address": "xyz road delhi delhi",             "order_status": "0",             "created_by": "5",             "from_date": "mar-31-2015",             "emp_name": " ",             "actions": "\r\n\t\t\t\t\t<a onclick=\"show_edit()\" class=\"btn default btn-xs purple \">\r\n                                               <i class=\"fa fa-edit\" ></i> edit </a>"         },         {             "order_id": "35",             "location_address": "xyz road delhi delhi",             "order_status": "0",             "created_by": "5",             "from_date": "mar-31-2015",             "emp_name": " super employee",             "actions": "\r\n\t\t\t\t\t<a onclick=\"show_edit()\" class=\"btn default btn-xs purple \">\r\n                                               <i class=\"fa fa-edit\" ></i> edit </a>"         },         {             "order_id": "36",             "location_address": "xyz road delhi delhi",             "order_status": "0",             "created_by": "5",             "from_date": "mar-31-2015",             "emp_name": " ",             "actions": "\r\n\t\t\t\t\t<a onclick=\"show_edit()\" class=\"btn default btn-xs purple \">\r\n                                               <i class=\"fa fa-edit\" ></i> edit </a>"         }     ] }   "pagelength": 10 (it should show 10 records on single page.)
still showing 130 records on 1 page. want show 10 records on single page.. how can show..?
initialization of plugin :-
datatable: {                  "lengthmenu": [                     [10, 20, 50, 100, 150, -1],                     [10, 20, 50, 100, 150, "all"]                  ],                 "pagelength": 10,     aocolumns: [     { mdata: 'order_id'},     { mdata: 'user_name'},     { mdata: 'location_address'},     { mdata: 'from_date'},     { mdata: 'assign_to'},        { mdata: 'order_status'},     { mdata: 'actions'}     ],  "ajax": {                     "url": page.php,                 }   any appreciated.
thank in advance.
 
 
  
Comments
Post a Comment