ajax - 渲染数据表上的 ajax 数据卡在进度中并出现错误“TypeError：数据未定义”

Question

我正在尝试用我用 codeigniter 填充的数据填充我的数据表。

这是我得到的对象

[{"checkbox":"<input type='checkbox' name='chk[]' id='expense_'185' value='185'\/>","expense_id":"185","category":"Others","description":"Payment Of Service For Sep $ October 2018","amount":"ksh.2,000","name":"Caroline Zachaeus","date":"27 Nov 2018"}, {"checkbox":"<input type='checkbox' name='chk[]' id='expense_'185' value='185'\/>","expense_id":"185","category":"Others","description":"Payment Of Service For Sep $ October 2018","amount":"ksh.2,000","name":"Caroline Zachaeus","date":"27 Nov 2018"}]

渲染时，它说

类型错误：数据未定义

这是我的ajax代码

 var table = $("#datatable").DataTable({

        "columnDefs" : [{"targets" : [ 7,0] , "orderable" : false},

                        {"targets" : [1], "visible": false}, 
        ],


        "fixedHeader": true,

        "aLengthMenu": [[25, 50, 100, 200, -1], [25, 50, 100, 200, "All"]],

        "iDisplayLength": 25,

        "order": [],

        'processing': true,
        'serverSide': true,
        'serverMethod': 'get',
        'ajax': {
            'url':'<?=base_url()?>index.php/expenses/data'  
        },

        "columns" : [
            "checkbox",
            "expense_id",
            "category",
            "description",
            "amount",
            "name",
            "date",
            "action",
        ],  
    })

这是我的页面截图

标签： ajaxcodeigniterdatatabledatatables

Answer 1

您的控制器功能在哪里我认为您正在从控制器 json 类型发布数据并且您必须设置 ajax datatype:'json' 然后它将为您工作