Donations Appreciated

When we give cheerfully and accept gratefully, everyone is blessed. - Maya Angelou

Click here to lend your support to: Laravel Datatables and make a donation at pledgie.com !

FluentController.php - Basic Demo

IMPORTANT: When using make(), the package will rely filtering and sorting based on the index/arrangement of your select query.


NEVER USE SELECT(*) when using this approach or your DataTables filtering/sorting may not work properly.

Id Name Email Created At Updated At

FluentController.php

    public function getBasic()
    {
        return view('datatables.fluent.basic');
    }

    public function getBasicData()
    {
        $users = DB::table('users')->select(['id', 'name', 'email', 'created_at', 'updated_at']);

        return Datatables::of($users)->make();
    }

Javascript

    $('#users-table').DataTable({
        processing: true,
        serverSide: true,
        ajax: 'https://datatables.yajrabox.com/fluent/basic-data'
    });