Add HTML attribute in Laravel Datatable

Question

I need ID attribute in HTML table of Laravel Datatable (https://github.com/yajra/laravel-datatables) like below.

I am using Laravel 5.4 and Datatable 7.x. I am using AdminLTE also. My controller is like below. I need the ID attribute.

UsersController.php

<?php
namespace App\Http\Controllers;
use DB;
use Validator;
use Datatables;
use App\Http\Requests;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Input;
use App\Users;

class UsersController extends Controller
{
    public function __construct()
    {
        $this->middleware('auth');
    }    
    /**
     * Show the application dashboard.
     *
     * @return Response
     */
    public function index()
    {
        return view('adminlte::users');
    }    
    /**
     * return data for dashboard.
     *
     * @return Response
     */
    public function get_users()
    {
        $users = Users::select(['id','name', 'user_name', 'email',]);

        return Datatables::of($users)
            ->addColumn('action', function ($users) {
                return '<button class="edit-modal btn btn-xs btn-primary">
                            <span class="glyphicon glyphicon-edit"></span> Edit
                        </button>';
            })
            ->make(true);
    }    
}

My JavaScript code is like below.

<script type="text/javascript">
    //Display datatable
    $(function() {
        $('#users').DataTable({
            processing: true,
            serverSide: true,
            ajax: "{{ route('get_users') }}",
            columns: [
                {data: 'id', name: 'id'},
                {data: 'name', name: 'name'},
                {data: 'email', name: 'email'},
                {data: 'action', name: 'action', orderable: false, searchable: false}
            ]
        });
    });
</script>

How can I get the output ?

I m not clear what u mean but is that what u want? yajrabox.com/docs/laravel-datatables/master/row-options#row-id — Ye Lwin Soe
– Ye Lwin Soe, Commented Aug 14, 2017 at 8:08
Thanks for your reply @YeLwinSoe. This one is working for me ->setRowId('id'). Thanks — abu abu
– abu abu, Commented Aug 14, 2017 at 8:18

Chirag Shah · Accepted Answer · 2019-03-11 05:27:23Z

1

Use this one

return Datatables::of($posts)
         ->setRowId('post_id')
         ->make(true);

Ref: https://yajrabox.com/docs/laravel-datatables/master/row-options#row-id

answered Mar 11, 2019 at 5:27

Chirag Shah

1,4742 gold badges18 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add HTML attribute in Laravel Datatable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related