Datatable类型错误：f未定义。

Question

JS代码：

$('#large-page-data').DataTable({
"processing":true,
"serverSide":true,
"ajax": 'getlargedataTables',
});

数据：

[{"Name":"Janet Andor","Term":"First Term","Date":"2016-09-26","Class":"J.H.S 1","Subject":"ENGLISH LANGUAGE","Exam":"CLASS WORK","Marks":"20"},{"Name":"Henry Kumi Kumson","Term":"First Term","Date":"2016-09-26","Class":"J.H.S 1","Subject":"ENGLISH LANGUAGE","Exam":"CLASS WORK","Marks":"24"},   
{"Name":"Jones Alonso","Term":"First Term","Date":"2016-09-26","Class":"J.H.S 1","Subject":"ENGLISH LANGUAGE","Exam":"CLASS WORK","Marks":"27"},{"Name":"Kingsley Offei Kumi","Term":"First Term","Date":"2016-09-26","Class":"J.H.S 1","Subject":"ENGLISH LANGUAGE","Exam":"CLASS WORK","Marks":"21"},
{"Name":"Mary Anderson","Term":"First Term","Date":"2016-09-26","Class":"J.H.S 1","Subject":"ENGLISH LANGUAGE","Exam":"CLASS WORK","Marks":"25"},{"Name":"Mary Boatemaa Duodu","Term":"First Term","Date":"2016-09-26","Class":"J.H.S 1","Subject":"ENGLISH LANGUAGE","Exam":"CLASS WORK","Marks":"22"}]

表格：

<table class="table table-hover table-striped table-bordered" id="large-page-data">
   <thead>
      <tr>
          <th>NAME</th>
          <th>TERM</th>
          <th>DATE</th>
          <th>CLASS</th>
          <th>EXAM</th>
          <th>SUBJECT</th>
          <th>MARKS</th>
     </tr>
   </thead>
</table>

我希望有人能指出我哪里做错了。

- Pingo Pongo

---

这里与PHP有什么关系？ - undefined

你到底想要做什么？你能解释一下你的项目的整体结构吗？ - undefined

"Php Data" - 这不是php，而是由PHP生成的JSON数据。 - undefined

这只是我在对数据进行编码时使用的内容，但问题是我不能够在 datatable 上进行处理。 - undefined

是的，你说得对。 - undefined

我认为你的数据格式不正确。 - undefined

Answer 1

你的JSON数据格式有误。应该像这样：

{
data: [
    ["Janet Andor","First Term","2016-09-26","J.H.S 1","ENGLISH LANGUAGE","CLASS WORK","20"],
    ["Janet Andor","First Term","2016-09-26","J.H.S 1","ENGLISH LANGUAGE","CLASS WORK","20"],
    ["Janet Andor","First Term","2016-09-26","J.H.S 1","ENGLISH LANGUAGE","CLASS WORK","20"],
    ["Janet Andor","First Term","2016-09-26","J.H.S 1","ENGLISH LANGUAGE","CLASS WORK","20"]
]}

你可以参考这个数据表格的例子：https://datatables.net/examples/data_sources/ajax.html

- vher2

Answer 2

我知道这是一个比较老的问题，但它是搜索结果中最早出现的之一。对于我来说，答案是添加 datasrc : ""，因为我使用的是ASP.NET Core Razor页面而不是MVC。

例如：

$('#BookList').DataTable({
            "ajax": {
                "url": "/api/Books/GetAllBooks",
                "method": "GET",
                "dataSrc": ""
            },
            "columns": [
                { "data": "id", "visible": false },
                { "data": "name", "title": "Name" },

            ],
            "order": [[1, "asc"]]
        });

- Kenny Mann