jQuery DataTables with Ajax

March 23, 2020 16:46

jQuery DataTables with Ajax (edit)

Google with keywords: "xhr.dt" + "preXhr.dt" + "ajax" site:datatables.net

Template: https://jsfiddle.net/63235xk2/

Documentation: https://stackoverflow.com/questions/25207147/datatable-vs-datatable-why-is-there-a-difference-and-how-do-i-make-them-w

https://cdn.datatables.net/releases.html

https://legacy.datatables.net/

https://cdn.datatables.net/

https://github.com/fingers10/JqueryDataTablesServerSide/ (.NET Core)

https://datatables.net/examples/ajax/objects.html

$(document).ready(function() {
 $('#example').DataTable( {
 "ajax": "data/objects.txt",
 "columns": [
 { "data": "name" },
 { "data": "position" },
 { "data": "office" },
 { "data": "extn" },
 { "data": "start_date" },
 { "data": "salary" }
 ]
 });
});

https://datatables.net/reference/option/ajax

Đa ngôn ngữ: Tiếng Việt

https://viblo.asia/p/tim-hieu-datatable-E375z8ObZGW

CSS

https://mdbootstrap.com/docs/jquery/tables/datatables/

Ajax + Json (HAY HAY HAY)

https://datatables.net/reference/api/ajax.json()

var table = $('#example').DataTable( {
 ajax: "data.json"
});
 
table.on( 'xhr', function () {
 var json = table.ajax.json();
 alert( json.data.length +' row(s) were loaded' );
});

initComplete

https://datatables.net/forums/discussion/55764/ajax-reload-callback-function-doesnt-wait-until-xhr-completes

https://stackoverflow.com/questions/56346220/in-datatable-initcomplete-not-called-after-table-ajax-reload

https://stackoverflow.com/questions/33344982/jquery-datatables-resume-after-ajax-call-completed

https://datatables.net/forums/discussion/44312/call-the-same-function-for-initcomplete-and-reload (HAY HAY HAY)

function initCompleteFunction(settings, json){
 var api = new $.fn.dataTable.Api( settings );
 // ... skipped ...
}
 
$(document).ready(function(){
 $('#matable').on('xhr.dt', function ( e, settings, json, xhr ) {
 initCompleteFunction(settings, json);
 } );
 
 var tableDONNEES = $("#matable").DataTable( {
 // ... skipped ...
 });
});

https://datatables.net/forums/discussion/21096/initcomplete-table-reload

https://datatables.net/reference/option/initComplete

https://datatables.net/forums/discussion/44647/initcomplete-function-not-working-in-datatable

https://datatables.net/forums/discussion/34602/using-initcomplete

https://datatables.net/forums/discussion/34352/passing-datatable-object-to-initcomplete-callback

https://datatables.net/examples/api/api_in_init.html

https://stackoverflow.com/questions/15786572/call-a-function-in-success-of-datatable-ajax-call

StateSave

https://www.sitepoint.com/working-jquery-datatables/

AutoRefresh

https://datatables.net/reference/api/ajax.reload()

https://stackoverflow.com/questions/12934144/how-to-reload-refresh-jquery-datatable