How to merge Laravel objects in controller

Question

I have a controller where I want to combine data from multiple tables with parallel structures. What I want to end up with in the end is one object I can return from the controller so I can parse it in Backbone.

I want to do something like this:

public function index()
{
    $mc = MainContact::where('verified', '=', '1')->get();
    $sm = SendMessage::where('verified', '=', '1')->get();

    $obj = (object) array_merge((array) $mc, (array) $sm);
    return $obj;
}

I'm told by another post on StackOverflow that this works in PHP 5.3+. However, this returns the following error in Laravel:

UnexpectedValueException: The Response content must be a string or object implementing
 __toString(), "object" given.

How do I implement this method in Laravel? Both $mc and sm return valid objects in Laravel.

I'm using the Laravel 4 alpha right now. I'm going to upgrade to the beta when it comes out today or Monday or whenever it comes out. — sehummel
– sehummel, Commented Jan 11, 2013 at 17:54
I tried creating a separate class with a blank __toString() method in it but don't know where to store it in Laravel 4. — sehummel
– sehummel, Commented Jan 11, 2013 at 18:07

trm42 · Accepted Answer · 2013-10-24 13:09:13Z

53

Nowadays you can use

$new_collection = $collection->merge($other_collection).

This works in Laravel 4 and seems to handle both arrays and collections.

answered Oct 24, 2013 at 13:09

trm42

2,6862 gold badges20 silver badges16 bronze badges

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

4 Comments

Ali Gajani Over a year ago

In my scenario, it eats up some rows after the collection merge.

trm42 Over a year ago

Is your collection using strings as keys? Collection::merge uses PHP's array_merge, which overwrites string keys but not integer keys. If that's a problem, you can always subclass Laravel Collection to override the implementation.

Pathros Over a year ago

In my case, only the $other_collection remains and the $collection disappears. Why???

Allan Mwesigwa Over a year ago

@AliGajani, yes it does. If a string key in the given items matches a string key in the original collection, the given items's value will overwrite the value in the original collection. But If the given items's keys are numeric, the values will be appended to the end of the collection. Check it out here: laravel.com/docs/5.7/collections#method-merge

Raftalks · Accepted Answer · 2013-01-11 21:00:24Z

36

What you can do here is merge the arrays of the two query result and then use the Response with json output like shown below.

$array = array_merge($mc->toArray(), $sm->toArray());
return Response::json($array);

answered Jan 11, 2013 at 21:00

Raftalks

2,0371 gold badge21 silver badges25 bronze badges

Comments

Ramesh Kotkar · Accepted Answer · 2014-10-17 06:39:29Z

10

We can use collection as below

$admins = User::where('type', '=', 'admin')->get();

$authors = User::where('type', '=', 'author')->get();

$admin_author_collection = $admins->merge($authors);

Also, Please refer the various collection methods to below link

http://laravel.com/api/4.2/Illuminate/Database/Eloquent/Collection.html

answered Oct 17, 2014 at 6:39

Ramesh Kotkar

7769 silver badges12 bronze badges

Comments

Jono20201 · Accepted Answer · 2014-12-08 09:39:11Z

3

Route::get('test', function(){
    $rank = Rank::get();
    $policy = Policy::get();
    $obj = (object)array_merge_recursive((array)$rank , (array)$policy);
    var_dump($obj);
});

This is working for me. Instead of array_merge use array_merge_recursive().

edited Dec 8, 2014 at 9:39

Jono20201

3,2053 gold badges22 silver badges34 bronze badges

answered Feb 2, 2014 at 17:59

Hassan Jamal

6949 silver badges12 bronze badges

Comments

Zahra Badri · Accepted Answer · 2023-05-01 08:54:03Z

0

I use concat and works for me. like this:

$role1 = User::where('role', '=', 'role1')->get();
$role2 = User::where('role', '=', 'role2')->get();
$allRoles = $role1->concat($role2);

answered May 1, 2023 at 8:54

Zahra Badri

2,0641 gold badge22 silver badges31 bronze badges

Comments

rashedcs · Accepted Answer · 2019-09-09 10:26:58Z

-4

You could simply use array_merge(firstObject,secondObject) function.

$obj = array_merge($mc, $sm);
return $obj;

answered Sep 9, 2019 at 10:26

rashedcs

3,7632 gold badges43 silver badges44 bronze badges

Collectives™ on Stack Overflow

How to merge Laravel objects in controller

6 Answers 6

4 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

4 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related