我正在从SQL中检索数据以包含在表中。我的代码返回错误“DataTables warning:table id = example - 无法重新初始化DataTable。有关此错误的更多信息,请参阅http://datatables.net/tn/3”
这是我的代码如下。 html和脚本。帮助将不胜感激。
column 1column 2column 3column 4column 5column 6column 7column 8
$(document).ready(function() {
$('#example').DataTable( {
"processing": true,
"serverSide": true,
"ajax":{
url :"employee-grid-data.php", // json datasource
type: "post", // method , by default get
error: function(){ // error handling
$(".employee-grid-error").html("");
$("#example").append('
No data found in the server');$("#example_processing").css("display","none");
}
}
"columnDefs": [
{ "visible": false, searchable: true, "targets": [5,6] }
],
"order": [[ 2, 'asc' ]],
"displayLength": 25,
"drawCallback": function ( settings ) {
var api = this.api();
var rows = api.rows( {page:'current'} ).nodes();
var last=null;
api.column(6, {page:'current'} ).data().each( function ( group, i ) {
if ( last !== group ) {
$(rows).eq( i ).before(
'
'+group+'');
last = group;
}
} );
}
} ); } );