Jquery DataTables：无法读取未定义的属性长度

发布于08月09日

我知道这是一个流行的问题，我已经在Stack Overflow和其他网站(包括DataTables网站)上阅读了所有类似的问题.

为了澄清，我正在使用

PHP Codeigniter
Materliazecss

I have also made sure that I received the JSON array correctly:

[{"name_en":"hello","phone":"55555555"},{"name_en":"hi","phone":"00000000"}]

My HTML table looks like this:

<table id="customer_table">
     <thead>
         <tr>
            <th>Name</th>
            <th>Phone</th>
         </tr>
     </thead>
</table>

下面是我的document.ready个函数:

  $(document).ready(function(){
            //$('#customer_table').DataTable();
            $('#customer_table').DataTable( {
                "ajax": 'json',
                "dataSrc": "",
                 "columns": [
                    { "data": "email" },
                    { "data": "name_en" }
                ]
            });
  });

The error I am getting is

未捕获的TypeError:无法读取未定义的属性"Length"

推荐答案

CAUSE

这个错误通常意味着jQuery DataTables在对Ajax请求的响应中找不到数据.

默认情况下，jQuery DataTables期望数据采用如下所示的格式之一.由于数据以非默认格式返回，因此出现错误.

Array of arrays

{ 
   "data": [
      [
         "Tiger Nixon",
         "System Architect",
         "$320,800",
         "2011/04/25",
         "Edinburgh",
         "5421"
      ]
   ]
}

Array of objects

{ 
   "data": [
      {
         "name": "Tiger Nixon",
         "position": "System Architect",
         "salary": "$320,800",
         "start_date": "2011/04/25",
         "office": "Edinburgh",
         "extn": "5421"
      }
   ]
}