DataTable生成不需要的额外列
问题描述:
我想从服务器获取数据的数据,但是它生成不存在的td
我还没有定义。DataTable生成不需要的额外列
的Javascript
$('.datatable-basic').DataTable({
"processing": true,
"serverSide": false,
"ajax": {
"url": base_url + 'leave/DraftJSON/'
},
"columns": [
{ "data": "name" },
{ "data": "sd" },
{ "data": "end" },
{ "data": "id"}
]
});
HTML:
<table class="table datatable-basic" >
<thead>
<tr>
<th>Leave</th>
<th>Start</th>
<th>End</th>
<th class="text-center" col="2">Actions</th>
</tr>
</thead>
</table>
Ajax请求的响应:数据表生成
{"data":[{"id":"2","uid":"2","lid":"2","sd":"21 June, 2017","stod":"Afternoon","end":"21 June, 2017"
,"etod":"Afternoon","reason":"ddada","rid":"1","draft":"0","name":"Compassionate","person":"Ms. Ochieng
, Alphonc O"},{"id":"3","uid":"1","lid":"4","sd":"2017\/06\/20","stod":"Morning","end":"2017\/06\/22"
,"etod":"Afternoon","reason":"qeqeqeq","rid":"1","draft":"0","name":"Paternity","person":"Ms. Ochieng
, Alphonc O"}]}
HTML:
<tbody>
<tr class="odd" role="row">
<td class="sorting_1">Compassionate</td>
<td>21 June, 2017</td>
<td>21 June, 2017</td>
<td>2</td>
<td></td> //non-existent
<td></td> //non-existent
</tr>
<tr class="even" role="row">
<td class="sorting_1">Paternity</td>
<td>2017/06/20</td>
<td>2017/06/22</td>
<td>3</td>
<td></td> //non-existent
<td></td> //non-existent
</tr>
</tbody>
注释td
s被数据表格额外损坏,然后产生错误。任何见解?
答
它的工作原理here如你所愿。
当我试图美化你的json文件时,json格式化程序给我一个人物属性错误。我删除了无效的人物属性,并准备好你的json数据。
{
"data":
[
{
"id":"2",
"uid":"2",
"lid":"2",
"sd":"21 June, 2017",
"stod":"Afternoon",
"end":"21 June, 2017",
"etod":"Afternoon",
"reason":"ddada",
"rid":"1",
"draft":"0",
"name":"Compassionate",
"person":"Ms. Ochieng, Alphonc O"
},
{
"id":"3",
"uid":"1",
"lid":"4",
"sd":"2017\/06\/20",
"stod":"Morning",
"end":"2017\/06\/22",
"etod":"Afternoon",
"reason":"qeqeqeq",
"rid":"1",
"draft":"0",
"name":"Paternity",
"person":"Ms. Ochieng, Alphonc O"
}
]
}
// jQuery的
$('.datatable-basic').DataTable({
"processing": true,
"serverSide": false,
"ajax": {
"url": 'data.json'
},
"columns": [
{ "data": "name" },
{ "data": "sd" },
{ "data": "end" },
{ "data": "id"}
]
});
你应该平衡你的日和列数来解决问题 – hasan
你解决这个问题? – hasan
我认为这里的问题是,datatables生成额外的TD,OP不希望这样。 @Alphy,你使用IE的任何机会?你在另一个浏览器上试过了吗? – Sebastianb