Laravel-datatables protection

Question

I'm using https://github.com/yajra/laravel-datatables currently to send ajax request for my datatable but noticed this:

columns: [
              { data: 'first_name'  },
                { data: 'last_name' },
                { data: 'email' },                  
        ]

but those are lines in my javascript document. I'm currently providing data like this:

return Datatables::of(User::all())->make(true);

That means if someone change lines in my js file he can view columns that he is not supposed to. Now if you take a look at github documentation you can see that this package can also accept collection or query. Is it possible to target only certain columns from database with collection or query ?

Pankit Gami · Accepted Answer · 2017-04-16 16:48:26Z

1

You can fetch only necessary columns from database like this:

return Datatables::of(User::all(['first_name','last_name','email']))->make(true);

answered Apr 16, 2017 at 16:48

Pankit Gami

2,55313 silver badges19 bronze badges

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

1 Comment

Michael Over a year ago

DataTables warning: table id=DataTables_Table_0 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

Collectives™ on Stack Overflow

Laravel-datatables protection

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related