Get data through pivot table in Laravel

Question

I got 3 tables. Table 1 & 2 has their ids as foreign keys in third one(pivot).

Relations for first one is

$this->hasMany("App\Pivot","game_id");

, second is

$this->belongsToMany("App\Pivot","army_id");

and pivot has relationships with both of them i.e belongsTo.

My schema:

I tried accessing it in controller of first one like this:

$games= Game::with("armies")->get();

Result that i get is array of games where instead of individual army data , i get collection from pivot table.

I can loop through it and get it that way, is there more elegant way of doing it?

Dharman · Accepted Answer · 2020-09-29 23:20:48Z

3

If you are using pivot table this is the way how to do it.

Games Model

public function armies()
{
    return $this->belongsToMany(App\Armies::class, 'pivot_table', 'game_id', 'army_id');
}

Armies Model

public function armies()
{
    return $this->belongsToMany(App\Games::class, 'pivot_table', 'army_id', 'game_id');
}

Access the relationship like this..

Controller

App\Games::first()->armies()->get();
or
App\Games::first()->armies
or
App\Games::find(1)->armies

edited Sep 29, 2020 at 23:20

Dharman♦

34k27 gold badges106 silver badges157 bronze badges

answered Sep 29, 2020 at 23:15

Kenneth

3,0134 gold badges27 silver badges53 bronze badges

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

2 Comments

Veljko Stefanovic Over a year ago

It works. I am using $games = Game::with("armies")->get();. I just want to ask you couple of follow ups. In array of armies, singular object has property pivots. Is it byproduct of relationship or is it removable? Second: If i remove 'army_id' from first one you are written, it shows exactly the same data as with it. Why is that?

Kenneth Over a year ago

laravel.com/docs/8.x/eloquent-relationships#many-to-many

Giovanni S · Accepted Answer · 2020-09-29 23:03:26Z

1

If you're going to use an intermediate table like that I'd probably do something like this:

Games model

    public function armies()
    {
        return $this->belongsToMany('App\Armies');
    }

Armies model

    public function games()
    {
        return $this->belongsToMany('App\Games');
    }

I'd keep the table structures all the same but rename the "pivot" table to armies_games since this is what Laravel will look for by default. If you want to keep it named Pivots, you'll need to pass it in as the second argument in belongsToMany.

With this, you don't really need the Pivot model, you should just be able to do:

$armies = Game::first()->armies()->get();

or

$armies = Game::find(3)->armies()->orderBy('name')->get();

or

$game = Game::first();
foreach ($game->armies as $army) {
  //
}

etc.

answered Sep 29, 2020 at 23:03

Giovanni S

2,13018 silver badges34 bronze badges

3 Comments

Veljko Stefanovic Over a year ago

Not really applicable. I don't "know" in advance id. Plus it for all 'games' respectively. I said i'm trying avoiding loops and searching more "laravel way" of doing it.

Giovanni S Over a year ago

The answer posted 10 minutes after mine explains exactly what I explained almost verbatim. I'm curious as why mine is "not applicable" but the other was accepted?

Veljko Stefanovic Over a year ago

Because my pivot table is called "pivot", not standard Laravel naming i.e. "army_game". This is my fault. Didn't know about pivot table naming convection. Your would work if it were standard named.

Collectives™ on Stack Overflow

Get data through pivot table in Laravel

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related