How to route in Laravel DataTables

Question

I am new to Laravel DataTables and i am trying to insert my controller in the datatables but i am getting an exception.

How to get this done?

PS: When I use the normal route like user/items/'$users->id'/control, it works fine but I want to use the the route like UserController@edit, $user->id

public function getPost()
{
    $users= User::where('id', Auth::user()->id);
    return Datatables::of($users)->addColumn('action', function ($user) {
        return '<a href="{ action('UserController@edit', $user->id)}" title="edit" ><i class="fa fa-edit"></i></a>
                &nbsp;&nbsp;';

    })->make(true);     

}

@dexterb, i don't think i need to post my datatable here. I want to know if it is possible to do what i am asking in the question — LearnLaravel
– LearnLaravel, Commented Dec 15, 2017 at 8:28
try like this return '<a href="'.action('UserController@edit', ['id' => $user->id]).'" title="edit" ><i class="fa fa-edit"></i></a>'; — Shibon
– Shibon, Commented Dec 15, 2017 at 8:37

common sense · Accepted Answer · 2017-12-15 11:42:50Z

Some mentions to your code:

// this will get you only one user
$users = User::where('id', Auth::user()->id);

// therefore it does not make sense to show one user in a table, does it ;-)
return Datatables::of($users)->make(true);

To your question:

You need two actions: One to render the view and one to fetch the data for the datatables via Ajax (if you use ServerSide rendering)

Assuming you want to show a list of users:

Routes

Route::get('users', 'UserController@index');
Route::get('users-dt', 'UserController@indexDataTables')->name('users:dt');

Controller

public function index()
{
    return view('users.index');
}

public function indexDataTables()
{
    $users = User::query();

    return DataTables::eloquent($users)->toJson();
}

user/index.blade.php

<script>
    $(function() {
        $('#users-table').DataTable({
            processing: true,
            serverSide: true,
            ajax: '{!! route('users:dt') !!}',
            columns: [
                { data: 'name', name: 'name'},
            ],
        });
    })
</script>

Dexter Bengil · Accepted Answer · 2017-12-15 08:39:25Z

0

You actually forgot to specify the parameter name on the second argument of action helper.

action('UserController@edit', ['user' => $user->id]);

// Assuming that UserController@edit looks like this:

public function edit(User $user) { ... }

answered Dec 15, 2017 at 8:39

Dexter Bengil

6,7157 gold badges39 silver badges57 bronze badges

Comments

Elikill58 · Accepted Answer · 2022-02-26 09:57:06Z

0

href="'.action('UserController@edit', $user->id).'"

Just remove curly braces. with ('..')

edited Feb 26, 2022 at 9:57

Elikill58

5,04527 gold badges33 silver badges65 bronze badges

answered Feb 26, 2022 at 6:25

Gajanan Chitare

1

Collectives™ on Stack Overflow

How to route in Laravel DataTables

3 Answers 3

Routes

Controller

user/index.blade.php

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Routes

Controller

user/index.blade.php

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related