add new element in laravel collection object

Question

I want to add new element in $items array, I don't want to use joins for certain reasons.

$items = DB::select(DB::raw('SELECT * FROM items WHERE items.id = '.$id.'  ;'));         foreach($items as $item){             $product = DB::select(DB::raw(' select * from product                    where product_id = '. $id.';' ));              $item->push($product);         } 

What should I do?

Answer 1

It looks like you have everything correct according to Laravel docs, but you have a typo

$item->push($product); 

Should be

$items->push($product); 

push method appends an item to the end of the collection:

I also want to think the actual method you're looking for is put

$items->put('products', $product); 

put method sets the given key and value in the collection

Answer 2

As mentioned above if you wish to add as a new element your queried collection you can use:

    $items = DB::select(DB::raw('SELECT * FROM items WHERE items.id = '.$id.'  ;'));     foreach($items as $item){         $product = DB::select(DB::raw(' select * from product                where product_id = '. $id.';' ));          $items->push($product);         // or          // $items->put('products', $product);     } 

but if you wish to add new element to each queried element you need to do like:

    $items = DB::select(DB::raw('SELECT * FROM items WHERE items.id = '.$id.'  ;'));     foreach($items as $item){            $product = DB::select(DB::raw(' select * from product                  where product_id = '. $id.';' ));                $item->add_whatever_element_you_want = $product;     } 

add_whatever_element_you_want can be whatever you wish that your element is named (like product for example).