lara123's avatar

i am using datatable packages in laravel ,refresh a page every time getting "DataTables warning: table id=users - Cannot reinitialise DataTable." error why? please help.

Id Business_Name City Address Phone Email Action 
</thead>
$(document).ready(function() { oTable = $('#users').DataTable({ "processing": true, "serverSide": true, "pageLength": 10, "ajax": "{{ URL::to('admin/datatable-getposts') }}", 
  "columns": [
            {data: 'id'},
            {data: 'Business_Name'},
            {data: 'City'},
            {data: 'Address'},
            {data: 'Phone'},
            {data: 'Email'},
            {defaultContent: '<img src="{{ URL::asset('img/adminicon/delete.png') }}" data-toggle="tooltip" data-placement="left" title="Delete" alt="Delete"  class="Delete" height="20" width="24" style="margin-left: 10px;font-size: 17px; data-value="">'},
            ],
    });
});
0 likes
2 replies
lara123's avatar

$(document).ready(function(){ var date = '2017-10-03'; $("#date_filter").keyup(function(){ // alert("hh") var dataSet = {"status":1,"message":"sucesss","data":[{"name":"wdw1","email":"[email protected]","created_at":"2017-10-02 17:02:01"},{"name":"ewrew2","email":"[email protected]","created_at":"2017-10-03 17:02:40"},{"name":"dsfsdf3","email":"[email protected]","created_at":"2017-10-03 17:03:43"},{"name":"dsfdsf4","email":"[email protected]","created_at":"2017-10-02 17:04:14"},{"name":"dfdsfds5","email":"[email protected]","created_at":"2017-10-02 17:04:42"},{"name":"tryrty6","email":"[email protected]","created_at":"2017-10-02 17:12:14"}]}; var trHTML = ''; /* $.each(dataSet.data, function (i, item) { trHTML += '' + item.name + '' + item.email + '' + item.created_at + ''; // alert(item) });

  $('#datatable tbody').html(trHTML);
  // $('#datatable tbody').html(trHTML);

   var table;
     table = $('#datatable').DataTable();

table.draw(); */ var table; table = $('#datatable').DataTable(); table.clear(); if(dataSet.data!='') {

    $.each(dataSet.data, function(i, item) {
    table.row.add([ item.name, item.email, item.created_at ]);
    /*trHTML += '<tr><td>' + item.name + '</td><td>' + item.email + '</td><td>' + item.created_at + '</td></tr>';
    */
    });    

  $('#datatable tbody').html(trHTML);         
  }
  else {
  $('#datatable').html('<h3>No users are available</h3>');
  }

  table.draw();

  });
  });

Please or to participate in this conversation.