You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.06.12 03:15:55