Datatables分页失效问题:点击分页后表格无法更新
Datatables分页控件点击后持续加载无更新问题
正在进行基于jQuery/Datatables/CodeIgniter的网站升级项目,旧版本中Datatable运行正常,升级后分页功能异常:表格首次加载成功,但选择每页显示条数的下拉框、点击页码时,页面持续加载,表格内容无任何更新。
头部HTML代码
<script src="https://dev.vmc.w3.uvm.edu/xana/CI4/js/jquery-3.7.1.min.js" type="text/javascript"></script> <script src="https://dev.vmc.w3.uvm.edu/xana/CI4/js/jquery-ui-1.13.2.js" type="text/javascript"></script> <script src="https://dev.vmc.w3.uvm.edu/xana/CI4/js/bootstrap-4.1.3/bootstrap.min.js" type="text/javascript"></script> <script src="https://dev.vmc.w3.uvm.edu/xana/CI4/js/vendor/mustache/0.5.0-dev/mustache.js" type="text/javascript"></script> <script type="text/javascript" src="https://dev.vmc.w3.uvm.edu/xana/CI4/js/dataTables-2.0.8/datatables.min.js"></script> <link type="text/css" rel="stylesheet" href="https://dev.vmc.w3.uvm.edu/xana/CI4/css/bootstrap-4.1.3/bootstrap.min.css"/> <link href="https://dev.vmc.w3.uvm.edu/xana/CI4/js/jquery-ui-1.11.2.custom/jquery-ui.min.css" rel="stylesheet" type="text/css" /> <link rel="stylesheet" type="text/css" href="https://dev.vmc.w3.uvm.edu/xana/CI4/js/dataTables-2.0.8/datatables.min.css"/>
Datatable初始化JavaScript代码
datat = $('#data-table').DataTable({ "processing": true, "serverSide": true, "ajax": { "url": "<?php echo site_url('manage/versions/getRecordsInfo');?>", "type": "POST", "data": data }, "drawCallback": function (settings) { // Here the response var response = settings.json; console.log(response); }, "searching": false, "ordering": false, "columns": JSON.parse(result.cols), //result.cols, "stateSave": true, "scrollY": '50vh', "scrollCollapse": true, "scrollX": true });
接口返回数据(点击分页控件时)
{ "draw": 1, "recordsTotal": 10426, "recordsFiltered": 10426, "data": [ { "pkLocationLookupID": "1", "fkLocationID": "1001", "fkLookupID": "1000", "fldOriginalCode": "", "fldOriginalValue": "", "fldSortOrder": "" }, { "pkLocationLookupID": "2", "fkLocationID": "1002", "fkLookupID": "1000", "fldOriginalCode": "", "fldOriginalValue": "", "fldSortOrder": "" }, { "pkLocationLookupID": "3", "fkLocationID": "1003", "fkLookupID": "1000", "fldOriginalCode": "", "fldOriginalValue": "", "fldSortOrder": "" }, { "pkLocationLookupID": "4", "fkLocationID": "1004", "fkLookupID": "1000", "fldOriginalCode": "", "fldOriginalValue": "", "fldSortOrder": "" }, { "pkLocationLookupID": "5", "fkLocationID": "1005", "fkLookupID": "1000", "fldOriginalCode": "", "fldOriginalValue": "", "fldSortOrder": "" }, { "pkLocationLookupID": "6", "fkLocationID": "1006", "fkLookupID": "1000", "fldOriginalCode": "", "fldOriginalValue": "", "fldSortOrder": "" }, { "pkLocationLookupID": "7", "fkLocationID": "1007", "fkLookupID": "1000", "fldOriginalCode": "", "fldOriginalValue": "", "fldSortOrder": "" }, { "pkLocationLookupID": "8", "fkLocationID": "1008", "fkLookupID": "1002", "fldOriginalCode": "", "fldOriginalValue": "", "fldSortOrder": "" }, { "pkLocationLookupID": "9", "fkLocationID": "1009", "fkLookupID": "1003", "fldOriginalCode": "", "fldOriginalValue": "", "fldSortOrder": "" }, { "pkLocationLookupID": "10", "fkLocationID": "1010", "fkLookupID": "1003", "fldOriginalCode": "", "fldOriginalValue": "", "fldSortOrder": "" } ], "columns": "[{ \"data\": \"pkLocationLookupID\" },{ \"data\": \"fkLocationID\" },{ \"data\": \"fkLookupID\" },{ \"data\": \"fldOriginalCode\" },{ \"data\": \"fldOriginalValue\" },{ \"data\": \"fldSortOrder\" }]" }
浏览器网络面板显示接口已成功返回数据,格式看起来有效,但Datatable无法更新表格内容。需要排查方向,如需更多信息可提供。
内容的提问来源于stack exchange,提问作者xanabobana
相关产品推荐
相关产品推荐

