How to add object to existing Laravel Query?

Question

What I want to do is add an object to the existing query.

This is my work in progress right now:

$users = ModelUser::where('date_created', $date)->get();

foreach($users as $user){
  $obj = ['test1'=> 'val1','test2' => 'val2','test3'=> 'val3',];
  $users['items'] = $obj;
}
return $users;

what I'm hoping is a result is like this.

{"username":'Username1', "Fname":'fname1', "items":['test1' = 'val1','test3' = 'val3','test3' = 'val3']
"username":'Username2', "Fname":'fname2', "items":['test1' = 'val1','test3' = 'val3','test3' = 'val3']
"username":'Username3', "Fname":'fname3', "items":['test1' = 'val1','test3' = 'val3','test3' = 'val3']
"username":'Username4', "Fname":'fname4', "items":['test1' = 'val1','test3' = 'val3','test3' = 'val3']
}

Where the items are like in a sub object.

array and collection are treated differently.

Abdulla Nilam
– Abdulla Nilam

2022-09-19 07:13:36 +00:00
Commented Sep 19, 2022 at 7:13 — Abdulla Nilam
– Abdulla Nilam, Commented Sep 19, 2022 at 7:13

Muhammad Sajidul Islam · Accepted Answer · 2022-09-19 05:04:09Z

1

Convert it into a collection and push into it

https://laravel.com/docs/9.x/collections#method-push

edited Sep 19, 2022 at 5:04

answered Sep 19, 2022 at 5:03

Muhammad Sajidul Islam

2802 silver badges9 bronze badges

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

Comments

josedaian · Accepted Answer · 2022-09-19 04:06:07Z

0

Just to understand a bit more, does the "items" element you want to add to the user object have any relationship at the database level? If so, it would be better to define a relationship within the ModelUser https://laravel.com/docs/9.x/eloquent-relationships#defining-relationships

In case not, I see you're using a $user as an array, but actually $user is a ModelUser element. So a trick, definitely not recommended, would be:

$user->items = $obj;

answered Sep 19, 2022 at 4:06

josedaian

672 silver badges7 bronze badges

Comments

hcb · Accepted Answer · 2022-09-19 07:07:33Z

0

You can use laravel map as

$users = ModelUser::where('date_created', $date)->get();

will return a collection. So your expected code will be something like the following

 $users = $users
    ->map(function ($user) use ($obj) {
         return $user->items = $obj;
      })
    );

answered Sep 19, 2022 at 7:07

hcb

3263 silver badges12 bronze badges

Collectives™ on Stack Overflow

How to add object to existing Laravel Query?

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