Laravel query builder array change

Question

Good day all !!

I have laravel query builder array. I want to set custom value to it.

e.g.

$data = DB::table("table_name")->get();

$data->layout = 'something';
OR 
$data['layout'] = 'something';

Can we do this ? IF yes, then how, because right now I am getting error.

Alexey Mezenin · Accepted Answer · 2017-01-19 13:53:09Z

2

You need to get record from a collection or an array first and then add custom data:

$data = DB::table("table_name")->get();
$data[0]->layout = 'something';

Or:

$data = DB::table("table_name")->first();
$data->layout = 'something';

answered Jan 19, 2017 at 13:53

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

Comments

Paras · Accepted Answer · 2017-01-19 14:00:09Z

0

For array access:

DB::setFetchMode(PDO::FETCH_ASSOC);
$data = DB::table("table_name")->get();
$data[0]['layout'] = 'something';

OR

DB::setFetchMode(PDO::FETCH_ASSOC);
$data = DB::table("table_name")->first();
$data['layout'] = 'something';

For object access:

$data = DB::table("table_name")->get();
$data[0]->layout = 'something';

OR

$data = DB::table("table_name")->first();
$data->layout = 'something';

answered Jan 19, 2017 at 14:00

Paras

9,51336 silver badges56 bronze badges