Adding Checkbox to Datatables - Jquery & Laravel

Question

I am trying to add a checkbox to my DataTable but when I run my project it returns the checkbox in text as it is shown in my controller. How can I get this done from my controller?

When i run the project, i get the checkbox does not render in the template but shows raw text. What is happening ?

public function getItem()
{
  $items = Item::all();
  return Datatables::of($items)->addColumn('checkbox', function ($item) {
    return '<input type="checkbox" id="'.item->id.'" name="someCheckbox" />';
  })->make(true);     
}

View

 oTable = $('#users-table').DataTable({
        "processing": true,
        "serverSide": true,
        "ajax": "{{ route('datatable.getitems') }}",
        "columns": [
            {data: 'checkbox', name: 'checkbox', orderable: false, searchable: false},      
            {data: 'name', name: 'name'},
            {data: 'action', name: 'action', orderable: false, searchable: false}        
        ],

    });

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

1

You have an error in your code:

return '<input type="checkbox" id="'.item->id.'" // should be $item

The Laravel Datatables package escapes the content of all columns by default – except for action column. To exclude your checkbox column from escaping you have two options:

In config/datatables.php search for action and add checkbox to that array. Note: this will exclude this column globally from escaping
add ->rawColumns(['action', 'checkbox']) to your definition

answered Dec 15, 2017 at 11:15

common sense

3,9106 gold badges26 silver badges35 bronze badges

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

1 Comment

Junior Frogie Over a year ago

how do it get id of the selected row?

Sylar · Accepted Answer · 2021-10-27 13:24:20Z

1

it is not necessary to modify the config / datatables.php file, you can modify it directly in the return datatable instruction, adding:

->rawColumns(['checkbox','name_column'])

You can put it like this:

public function getItem()
{
  $items = Item::all();
  return Datatables::of($items)->addColumn('checkbox', function ($item) {
    return '<input type="checkbox" id="'.item->id.'" name="someCheckbox" />';
  })
  ->rawColumns(['checkbox'])
  ->make(true);     
}

answered Oct 27, 2021 at 13:24

Sylar

3052 silver badges20 bronze badges

Comments

user13782721 · Accepted Answer · 2020-06-23 17:23:42Z

0

->editColumn('select_orders', static function ($row) {
            return '<input type="checkbox" name="registrations[]" value="'.$row->id.'"/>';
        })->rawColumns(['select_orders'])

The Laravel Datatables package escapes the content of all columns by default – except for action column. To exclude your checkbox column from escaping you have two options:

In config/datatables.php search for action and add checkbox to that array. Note: this will exclude this column globally from escaping

'raw' => ['action', 'checkbox'],

Inside your datatable.js file

{data: 'select_orders', name: 'select_orders', searchable: false, orderable: false},

answered Jun 23, 2020 at 17:23

user13782721

Collectives™ on Stack Overflow

Adding Checkbox to Datatables - Jquery & Laravel

3 Answers 3

1 Comment

Comments

The Laravel Datatables package escapes the content of all columns by default – except for action column. To exclude your checkbox column from escaping you have two options:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

The Laravel Datatables package escapes the content of all columns by default – except for action column. To exclude your checkbox column from escaping you have two options:

Comments

Your Answer

Sign up or log in

Post as a guest

Related