Laravel DataTables does not render HTML

Question

I'm using Laravel Datatables 7, but my table is not rendering HTML code. It was rendering HTML before, but when I updated to new Laravel DataTables to 7 from 6, it stopped rendering HTML in column. http://prntscr.com/e11n84

This is with Laravel DataTables 6 - http://prntscr.com/e11ph0

$(function() {
    $('#users-table').DataTable({
        processing: true,
        serverSide: true,
        ajax: {
            url: '{{ route("admin.access.user.get") }}',
            type: 'post',
            data: {status: 1, trashed: false}
        },
        columns: [
            {data: 'id', name: '{{config('access.users_table')}}.id'},
            {data: 'name', name: '{{config('access.users_table')}}.name', render: $.fn.dataTable.render.text()},
            {data: 'email', name: '{{config('access.users_table')}}.email', render: $.fn.dataTable.render.text()},
            {data: 'confirmed', name: '{{config('access.users_table')}}.confirmed'},
            {data: 'roles', name: '{{config('access.roles_table')}}.name', sortable: false},
            {data: 'created_at', name: '{{config('access.users_table')}}.created_at'},
            {data: 'updated_at', name: '{{config('access.users_table')}}.updated_at'},
            {data: 'actions', name: 'actions', searchable: false, sortable: false}
        ],
        order: [[0, "asc"]],
        searchDelay: 500
    });
});

Shoaib Khan · Accepted Answer · 2022-01-06 05:01:59Z

1

Add the column with html as shown on other answers and after all add this ->rawColumns(['html_column', 'another_html_column']) before ->toJson() to render all the html column as sent by the server

edited Jan 6, 2022 at 5:01

answered Jul 11, 2021 at 18:24

Shoaib Khan

1,0801 gold badge13 silver badges19 bronze badges

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

Comments

Akash khan · Accepted Answer · 2020-12-05 14:20:03Z

0

Try to feed data as JSON from the controller by using toJson() method.

$data= User::all();
return datatables()->of($data)
       ->addColumn('action', function ($row) {
          $html = '<a href="/users/'.$row->id.'">Edit</a> ';
          $html .= '<button data-rowid="'.$row->id.'">Del</button>';
          return $html;
        })->toJson();

Ref: https://laravelarticle.com/laravel-yajra-datatables

answered Dec 5, 2020 at 14:20

Akash khan

9892 gold badges14 silver badges27 bronze badges

Comments

Marvin Nario Machitar · Accepted Answer · 2020-12-15 17:16:33Z

0

      //im also using yajra data tables..
      //it's easy to render html from controller...

      example: 
      $query = Appointment::all();
      $table = Datatables::of($query);
      $table->editColumn('user_id', function ($row) {
            return $row->user_id ? '<span style="color: green;">ACCEPTED</span>' : 
                                   '<span style="color: red;">PENDING</span>';           
            
        });
      //then you need to add the column you want to render html
       $table->rawColumns(['user_id']);

answered Dec 15, 2020 at 17:16

Marvin Nario Machitar

851 silver badge3 bronze badges

Collectives™ on Stack Overflow

Laravel DataTables does not render HTML

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related