DataTable-无法读取属性'长度'为null

DataTable - Cannot read property 'length' of null

本文关键字:长度 null 属性 DataTable- 读取      更新时间:2023-09-26

我有数据表:

function drawRadnici() {
                $('#tableradnici').dataTable({ 
                    "ajax": {
               "url": 'track_radnici.php',
               "type": 'POST',
               "data": {ajdi:ajdi},
               },
                    paging: false,
                    //"dom":' <"search"f><"top"l>rt<"bottom"ip><"clear">',
                    // end ,
                    "columns": [ {
                            "data": "datum"}, {
                            "data": "radnik"},{
                            "data": "radnih_sati"},{
                            "data": "cena"},{
                            "data": "ukupno"},{
                            "data": "ID"}
                    ],
                    "columnDefs": [
                            {
                        "targets": 5,
                        "data": "ID",
                        "render": function(data, type, full, meta) {
                            // return data; 
                            return '<i value="'+data+'" class="fa fa-times"></i>';
                        }
                            }

    ]
                });
            };

并且工作正常,但当我从数据库中得到空的JSON数据时,我会得到:

Uncaught TypeError: Cannot read property 'length' of null

当我没有数据时,我的json是:

{data:null}

我试图做的事情——我试图为ajax添加成功功能:

"ajax": {
               "url": 'track_radnici.php',
               "type": 'POST',
               "data": {ajdi:ajdi},
"success": function (data) {
if (data == null) {
$('#tabeleradnici').html('No result');
}
}
               },

所以当我没有数据时,我会尝试只向#tabeleradnici添加文本。。。但这也不起作用。。。

您可以检查其是否为null并使其为空,因此长度仍然有效:

"success": function (data) {
    data = data || [];
}

更新:

function drawRadnici() {
    $('#tableradnici').dataTable({
        "ajax": {
            "url": 'track_radnici.php',
            "type": 'POST',
            "dataSrc": function (json) {
                if(!json.data){
            $('#tabeleradnici').html('No result');
            json.data = [];
        }
                return json.data;
            },     
            "data": {
                ajdi: ajdi
            }
        },
        paging: false,
        //"dom":' <"search"f><"top"l>rt<"bottom"ip><"clear">',
        // end ,
        "columns": [{
            "data": "datum"
        }, {
            "data": "radnik"
        }, {
            "data": "radnih_sati"
        }, {
            "data": "cena"
        }, {
            "data": "ukupno"
        }, {
            "data": "ID"
        }],
        "columnDefs": [
            {
                "targets": 5,
                "data": "ID",
                "render": function(data, type, full, meta) {
                    // return data; 
                    return '<i value="' + data + '" class="fa fa-times"></i>';
                }
            }

        ]
    });
};