Laravel Eloquent With() With()

Question

How do I go about using multiple Eloquent With()'s?

PortalPlaylistElement Model

class PortalPlaylistElement extends Model
{
    public $primaryKey = 'code';
    public $incrementing = false;
    public $timestamps = false;

    public function AirtimePlaylists()
    {
        return $this->hasOne('App\AirtimePlaylist','id','playlist_id');
    }
}

AirtimePlaylistContent Model

class AirtimePlaylistContent extends Model
{
    protected $table = 'cc_playlistcontents';
}

AirtimePlaylistModel

class AirtimePlaylist extends Model
{
    protected $table = 'cc_playlist';

    public function PortalPlaylistElements()
    {
        return $this->belongsTo('App\PortalPlaylistElement','playlist_id');
    }

    public function AirtimePlaylistContents()
    {
        return $this->hasMany('App\AirtimePlaylistContent','playlist_id');
    }
}

I have no problems with:

AirtimePlaylist::with('AirtimePlaylistContents')->get());

or

PortalPlaylistElement::with('AirtimePlaylists')->get();

But I'd like to get all AirtimePlaylistContents, in an AirtimePlaylist that belongs to a PortalPlaylistElement.

In essence, (Pseudo code)

PortalPlaylistElement::with('AirtimePlaylists')::with('AirtimePlaylistContents')->get();

huuuk · Accepted Answer · 2016-06-01 18:56:56Z

39

You need Nested Eager Looading

PortalPlaylistElement::with('AirtimePlaylists.AirtimePlaylistContents')->get();

answered Jun 1, 2016 at 18:56

huuuk

4,8052 gold badges22 silver badges28 bronze badges

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

1 Comment

Scott Robinson Over a year ago

Spot on - Have managed to further nest the additional models aswell. Thanks so much - I'll have a read up on them now I know what to look for!

Achraf Khouadja · Accepted Answer · 2020-01-06 11:29:20Z

12

nested relations

 with('relation1.relation2.relation3')->get(); // relation1 has relation2 relation2 has relation 3

not nested relations

 with('relation1','relation2','relation3')->get(); // you model has all relations

edited Jan 6, 2020 at 11:29

answered Jun 1, 2016 at 19:03

Achraf Khouadja

6,2994 gold badges29 silver badges40 bronze badges

2 Comments

Andrew Kang Over a year ago

but 'where clauses' inside 'with' seem to be ignored.. Anyone who knows how to deal with those cases?

Achraf Khouadja Over a year ago

can you show what you already tried? so i can get a better idea on what you are trying to achieve!

Daniel Tadros · Accepted Answer · 2018-03-13 15:21:09Z

5

I would like to add this if someone needed it

 with(['relation1.relation2-1','relation1.relation2-2'])->get(); // relation1 has relation2-1 and relation1 also has relation2-2

answered Mar 13, 2018 at 15:21

Daniel Tadros

2,3571 gold badge24 silver badges29 bronze badges

Collectives™ on Stack Overflow

Laravel Eloquent With() With()

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related