dqoag62688 2017-07-19 11:31
浏览 107
已采纳

如何使用Laravel 5.4显示来自Datatables的数据?

I'm stuck with datatables and the plugin yajrabox for Laravel 5.4. The goal is to load with ajax and the plugin the data from the users tables in my database, but it just shows me this error :

DataTables warning: table id=listingUsers - Requested unknown parameter '0' for row 0, column 0. 

I can't find out where it's coming from and i'm not sure I wrote the code right..

Here is my code.

Controller :

 public function index() {
    $users = User::latest()->count();

    return view('admin.users.index', compact('users'));
}

 public function ajaxListing() {
    $users = User::select(['id', 'username', 'email']);
        return Datatables::of($users)->make(true);
}

Routes :

Route::resource('users', 'Admin\UsersController');
Route::any('user-data', 'Admin\UsersController@ajaxListing')->name('datatables.data');

View : `

<table class="table table-bordered table-responsive" id="listingUsers">
    <thead>
        <th>ID</th>
        <th>Nom</th>
        <th>Email</th>
    </thead>

    <tbody></tbody>
</table>

@push('scripts')
<script>
    $(document).ready(function () {
        $('#listingUsers').DataTable({
            processing: true,
            serverSide: true,
            ajax: '{!! route('datatables.data') !!}',
            columns: [
                {data: 0, name: 'id'},
                {data: 1, name: 'name'},
                {data: 2, name: 'email'}
            ]
        });
    });

</script>
@endpush`

WHen i'm searching the error in the console and the network the data comes right but just doesn't show in the table.

Can someone tell me what t'im doing wrong and how to fix it ?

  • 写回答

1条回答 默认 最新

  • douyanjing0822 2017-07-19 12:11
    关注

    In data, you need to specify the column name, like that:

    columns: [
        {data: 'id', name: 'id'},
        {data: 'username', name: 'username'},
        {data: 'email, name: 'email'}
    ]
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 爬取豆瓣电影相关处理
  • ¥15 手机淘宝抓清除消息接口
  • ¥15 C#无selenium
  • ¥15 LD衰减计算的结果过大
  • ¥15 用机器学习方法帮助保险公司预测哪些是欺诈行为
  • ¥15 计算300m以内的LD衰减
  • ¥15 数据爬取,python
  • ¥15 怎么看 cst中一个面的功率分布图,请说明详细步骤。类似下图
  • ¥15 为什么我的pycharm无法用pyqt6的QtWebEngine
  • ¥15 FOR循环语句显示查询超过300S错误怎么办