提问者:小点点

DataTable不显示AJAX JSON数据


我正在DataTable的帮助下进行一个简单的项目,使用AJAX显示POST数据。数据显示但列出了所有记录,而没有分页。JSON数据根据DataTable要求和JQuery中的其他设置。

在此方面的任何帮助都将不胜感激。代码如下所示

<table id="dataTable" class="display" style="width:100%">
    <thead>
    <tr>
        <th>ID</th>
        <th>Qualification</th>
    </tr>
    </thead>
    <tfoot>
    <tr>
        <th>ID</th>
        <th>Qualification</th>
    </tr>
    </tfoot>
</table>
 $(document).ready(function () {
        $('#dataTable').DataTable({
            "searching": false,
            info: false,
            "pageLength": 5,
            "lengthMenu": [[5, 10, 20, -1], [5, 10, 20, "All"]],
            "processing": true,
            "serverSide": true,
            "ajax": {
                "url": "scripts/post.php",
                "type": "POST",
                "dataType": "json",
                "dataSrc": "data",
                "data": {
                    table: 'tbl_qualification'
                },
                "success": function (data) {
                    console.log(data);
                }
            },
            "columns": [
                {"data": "pk_int_qualificationID"},
                {"data": "txt_qualificationName"}
            ]
        })
    })
$table=$_POST['table'];
$result=ConnectSQL::GetQuick($table,array(),array());
$result['recordsTotal']=$result['count'];
unset($result['count']);
$result['data']=$result['rows'];
unset($result['rows']);
print_r(json_encode($result));
return json_encode($result);
{
    "recordsTotal": 27,
    "data": [{
        "pk_int_qualificationID": "1",
        "txt_qualificationName": "Doctor of Medicine"
    }, {
        "pk_int_qualificationID": "2",
        "txt_qualificationName": "Internship"
    }, {
        "pk_int_qualificationID": "3",
        "txt_qualificationName": "OMSB Speciality"
    }, {
        "pk_int_qualificationID": "4",
        "txt_qualificationName": "OMSB Compelition"
    }, {
        "pk_int_qualificationID": "5",
        "txt_qualificationName": "IELTS"
    }, {
        "pk_int_qualificationID": "6",
        "txt_qualificationName": "abc"
    }, {
        "pk_int_qualificationID": "7",
        "txt_qualificationName": "abc"
    }, {
        "pk_int_qualificationID": "8",
        "txt_qualificationName": "abc"
    }, {
        "pk_int_qualificationID": "9",
        "txt_qualificationName": "abc"
    }, {
        "pk_int_qualificationID": "10",
        "txt_qualificationName": "amir"
    }, {
        "pk_int_qualificationID": "11",
        "txt_qualificationName": "Sameer"
    }, {
        "pk_int_qualificationID": "12",
        "txt_qualificationName": "amir1234"
    }, {
        "pk_int_qualificationID": "13",
        "txt_qualificationName": "Sameer5"
    }, {
        "pk_int_qualificationID": "14",
        "txt_qualificationName": "Amir12346"
    }, {
        "pk_int_qualificationID": "15",
        "txt_qualificationName": "Zubair"
    }, {
        "pk_int_qualificationID": "16",
        "txt_qualificationName": "dd"
    }, {
        "pk_int_qualificationID": "17",
        "txt_qualificationName": "dsd1"
    }, {
        "pk_int_qualificationID": "18",
        "txt_qualificationName": "abc1"
    }, {
        "pk_int_qualificationID": "19",
        "txt_qualificationName": "Abc123"
    }, {
        "pk_int_qualificationID": "20",
        "txt_qualificationName": "Sameer"
    }, {
        "pk_int_qualificationID": "21",
        "txt_qualificationName": "Sameer"
    }, {
        "pk_int_qualificationID": "22",
        "txt_qualificationName": "abc145"
    }, {
        "pk_int_qualificationID": "23",
        "txt_qualificationName": "abc"
    }, {
        "pk_int_qualificationID": "24",
        "txt_qualificationName": "abc123"
    }, {
        "pk_int_qualificationID": "25",
        "txt_qualificationName": "Sameer123"
    }, {
        "pk_int_qualificationID": "26",
        "txt_qualificationName": "dasda"
    }, {
        "pk_int_qualificationID": "29",
        "txt_qualificationName": "abc14567"
    }]
}


共2个答案

匿名用户

serverside设置为false(或将其删除),或者将分页和排序信息添加到ajax请求中。

匿名用户

尝试添加分页:true。另外,您应该在info周围加上引号:"info":false参考