我设法直接从ajax显示Datatable。但唯一的问题是。该表未按原样显示数据。
来自report_ajax.php json的数据
{"data":[
["22:00:00","16dee076f62ce35f3b64ee14d8fec748","0"],
["22:15:00","8aa57813201bc78849baa56eafb0f04c","0"],
["22:15:00","17b6bd8adfc11c4efe571edacc528d58","0"],
["22:15:00","a4048f751f4f9e4b2779aa52dfcf5903","0"],
["22:30:00","c39624dca09de650ae28b4e68f09f7a1","0"],
["22:45:00","3a471c7b5204ae0d6fd510006c67b89b","0"],
["23:00:00","202dc747da31af7b70a714823df35fbc","0"],
["23:25:00","71ad04376d1a2b6e0d5fbb88d2efcafe","0"],
["23:30:00","b87c8dc8789fdb0b947b8bfb39efd88c","0"],
["23:45:00","0f1cab9da99f3da84efd62cee0d447e8","0"],
["00:05:00","6a601ce30d73cb3525cae8269e658140","0"],
["00:15:00","99bf53fb6c458d23060846a7478c23ef","0"],
["00:30:00","c9e42098c79fadbcfeb8f2137b5d6b27","0"],
["00:45:00","ba87e8493eed4768384123e1e242b2a7","0"],
["00:50:00","9d55061b4af7116732260c6c3f505b9a","0"]
.
.
.
]}如您所见,第一个数组是time。我希望datatable将与此订单一起显示。但结果是,它对我的数据进行了排序,并且可以很好地在00:00和23:45之间运行。
这是我的jquery:
var table=$('#dataTable').DataTable( {
ajax: "report_ajax.php",
//stateSave: true,
"pageLength": 25,
});我希望datatable显示的数据与发送到的数据完全相同。我应该修复什么?
发布于 2021-07-14 23:09:51
您只需添加一个参数,它将不会对初始列表中的数据进行排序
"order": []所以你的代码应该是
var table=$('#dataTable').DataTable( {
ajax: "report_ajax.php",
//stateSave: true,
"pageLength": 25,
"order": []
});https://stackoverflow.com/questions/68380557
复制相似问题