Guest User

Untitled

a guest
May 27th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.29 KB | None | 0 0
  1. <table id="myTable" class="display" style="width:100%">
  2. <thead>
  3. <tr>
  4. <th>Name</th>
  5. <th>Last_name</th>
  6. </tr>
  7. </thead>
  8. </table>
  9.  
  10. $(document).ready(function(){
  11. $('#myTable').DataTable( {
  12. "processing": true,
  13. "serverSide": true,
  14. "order":[],
  15. "ajax": {
  16. "url": '<?= base_url('main/getData');?>',
  17. "type": "POST",
  18. "data": { '<?php echo $csrf_token_name; ?>' : '<?php echo $csrf_token_hash; ?>' }
  19. },
  20. });
  21. })
  22.  
  23. public function getData()
  24. {
  25. $this->security->get_csrf_token_name();
  26. $this->security->get_csrf_hash();
  27. $table = $this->main_model->data();
  28. if (count($table) > 0)
  29. {
  30. foreach ($table as $row)
  31. {
  32. $tab = array();
  33. $tab["name"] = $row->name;
  34. $tab["last_name"] = $row->last_name;
  35. $r_tab[] = $tab;
  36. }
  37. echo json_encode($r_tab);
  38. }
  39.  
  40. $(document).ready(function(){
  41. $('#myTable').DataTable( {
  42. "processing": true,
  43. "serverSide": true,
  44. "order":[],
  45. "ajax": {
  46. "url": '<?= base_url('main/getData');?>',
  47. "type": "POST",
  48. "data": { '<?php echo $csrf_token_name; ?>' : '<?php echo $csrf_token_hash; ?>' }
  49. },
  50. 'columns': [
  51. { "data": "name", "name": "name"},
  52. { "data": "last_name", "name": "last_name"},
  53. ]
  54. });
  55. });
  56.  
  57. public function getData()
  58. {
  59. $data['csrf_token_name'] = $this->security->get_csrf_token_name();
  60. $data['csrf_token_hash'] = $this->security->get_csrf_hash();
  61.  
  62. $table = $this->main_model->data();
  63. if (count($table) > 0)
  64. {
  65. foreach ($table as $row)
  66. {
  67. $tab = array();
  68. $tab["name"] = $row->name;
  69. $tab["last_name"] = $row->last_name;
  70. $r_tab[] = $tab;
  71. }
  72.  
  73. $output = array(
  74. "draw" => $_POST['draw'],
  75. "recordsTotal" => 200, // modify this
  76. "recordsFiltered" => 200, // modify this
  77. "data" => $r_tab
  78. );
  79.  
  80. echo json_encode($output);
  81. }
Add Comment
Please, Sign In to add comment