douji6735 2017-06-20 16:13
浏览 44

Ajax / Json DataTables

I have 3 files, index.php, ajax.php, and scripts.js.

This is my ajax.php:

if ( $_GET['action'] == "newUserAccountsGrid" )
{

    try
    {

        $stmt = $DB_CONN->prepare("SELECT * FROM crm_users");
        $stmt->execute();
        $i=1;
        while ( $rows = $stmt->fetch(PDO::FETCH_OBJ) )
        {
            $obj[$i]['username']        = $rows->{'username'};
            $obj[$i]['firstname']       = $rows->{'firstname'};
            $obj[$i]['lastname']        = $rows->{'lastname'};
            $obj[$i]['user_email']      = $rows->{'user_email'};
            $obj[$i]['user_level']      = $rows->{'user_level'};
            $obj[$i]['user_role']       = $rows->{'user_role'};
            $obj[$i]['date_created']    = $rows->{'date_created'};
            $i++;
        }

    }
    catch( PDOException $e )
    {
        echo $e->getMessage();
    }

    if ( is_array($obj) )
    {
        $arr['data'] = array_values($obj);
        $json = json_encode($arr, JSON_PRETTY_PRINT);
        echo $json;
    }

}

datatable javascript scripts.js :

$( "#tbl_useraccounts" ).dataTable({
    ajax: "ajax.php?action=newUserAccountsGrid",
    columns: [
        { "data": "username" },
        { "data": "firstname" },
        { "data": "lastname" },
        { "data": "user_email" },
        { "data": "user_level" },
        { "data": "user_role" },
        { "data": "date_created" },
    ],

    columnDefs: [{
        defaultContent: "-",
        targets: "_all"
    }]
});

Also index.php :

<table id="tbl_useraccounts" class="table table-striped table-hover">
    <thead>
        <tr>
            <th class="no-sort">Username</th>
            <th class="no-sort">First Name</th>
            <th class="no-sort">Last Name</th>
            <th class="no-sort">User Email</th>
            <th class="no-sort">User Level</th>
            <th class="no-sort">User Role</th>
            <th class="no-sort">Date Created</th>
        </tr>
    </thead>
    <tfoot>
        <tr>
            <th>Username</th>
            <th>First Name</th>
            <th>Last Name</th>
            <th>User Email</th>
            <th>User Level</th>
            <th>User Role</th>
            <th>Date Created</th>
        </tr>
    </tfoot>
</table>

Json is ok :

{
    "data": [
        {
            "username": "test1",
            "firstname": "Test 1",
            "lastname": "Test 1",
            "user_email": "test1@test.com",
            "user_level": "1",
            "user_role": "Broker",
            "date_created": "2017-06-19 15:10:32"
        },
        {
            "username": "test2",
            "firstname": "Test 2",
            "lastname": "Test 2",
            "user_email": "test2@test.com",
            "user_level": "1",
            "user_role": "Consulent",
            "date_created": "2017-06-19 15:10:32"
        },
        {
            "username": "test3",
            "firstname": "Test 3",
            "lastname": "Test 3",
            "user_email": "test3@test.com",
            "user_level": "1",
            "user_role": "Consulent",
            "date_created": "2017-06-19 15:10:32"
        }
    ]
}

So everything executes fine, no errors, table renders the rows, but no data is displayed. Thank you guys for your time.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 ogg dd trandata 报错
    • ¥15 高缺失率数据如何选择填充方式
    • ¥50 potsgresql15备份问题
    • ¥15 Mac系统vs code使用phpstudy如何配置debug来调试php
    • ¥15 目前主流的音乐软件,像网易云音乐,QQ音乐他们的前端和后台部分是用的什么技术实现的?求解!
    • ¥60 pb数据库修改与连接
    • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
    • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
    • ¥20 神经网络Sequential name=sequential, built=False
    • ¥16 Qphython 用xlrd读取excel报错