add an array of collection inside collection with Laravel 5.3

Question

I need to get all clubs that belongs to a federationPresident.

So, I have:

$federation->associations

which gets me a collection of associations,

$association->clubs that gives me a collection of clubs

I would like to do :

$federation->associations->clubs, but it doesn't work

What I did:

  foreach ($federation->associations as $association) {
       foreach ($association->clubs as $club){
           $clubs->push($club);
   }
 }

This works, but I think I'm missing something, and I could do it easilier.

Thing is I will have to do it a lot of time in my code, so, this is not very elegant...

Any Idea how to do it better?

Association Model:

public function clubs()
{
    return $this->hasMany(Club::class);
}

Do you have a model for clubs and does your association model have a method setup which relates it to clubs? — user1669496
– user1669496, Commented Sep 26, 2016 at 16:42

user1669496 · Accepted Answer · 2016-09-26 17:03:27Z

1

You can use eager loading. You use dot notation to relate nested models.

$federations = Federation::with('associations.clubs')->get();

And now everything is nested for you...

foreach ($federations as $federation) {
    foreach ($federation->associations as $association) {
        foreach ($assocation->clubs as $club) {
             ...
        }
    }
}

Another way would be to use the hasManyThrough relating method. It does work with 2 has-manies.

In your Federation model.

public function clubs()
{
    return $this->hasManyThrough(Club::class, Association::class);
}

edited Sep 26, 2016 at 17:03

answered Sep 26, 2016 at 16:44

user1669496

33.3k9 gold badges76 silver badges65 bronze badges

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

3 Comments

Juliatzin Over a year ago

this is exactly what I am doing. I am looking for something to avoid the 2 foreach

user1669496 Over a year ago

Then you can setup a relation in your federation model for clubs which would be a hasManyThrough. laravel.com/docs/5.3/eloquent-relationships#has-many-through

Juliatzin Over a year ago

yes, I think this is what I am looking, for, but I am not sure it works with 2 has many relationships

reda igbaria · Accepted Answer · 2016-09-26 16:57:57Z

1

You can try the Has Many Through relation ...

which will get you all the clubs that belongs to the associations of the federation

answered Sep 26, 2016 at 16:57

reda igbaria

1,45412 silver badges15 bronze badges

Collectives™ on Stack Overflow

add an array of collection inside collection with Laravel 5.3

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related