How to load data in datatables from ajax?

by websourceblog · June 3, 2018

Load data in Datatables from Ajax

I was working on a project in which I had to show results in datatables with search and load data in datatable in real-time like whenever record inserted, it will show in datatables right away without refreshing page. This can be done via ajax. I achieved this requirement by following code. I am skipping table html.

var recordsTable;

recordsTable = $('#datatable-fixed-header').DataTable({
                   ajax: {
                       "url":"liveRecs.php",
                       "dataSrc": ""
                   }
            });

setInterval( function () {
    recordsTable.ajax.reload( null, true ); 
}, 10000 );

That’s it. Hope this will help.