how to load nested relationships in laravel

Question

i have 3 models that i want to start from a and load the relation with b and i want to load the relation betwen b and c there in a too is that possible ?? here is what i want to do in code :

AccommodationRoomModel which is the B model:
public function accommodation(){
        return $this->belongsTo(Accommodation::class);
    }

  public function roomPricingHistory(){
    return $this->hasMany(RoomPricingHistory::class);
}

and in The accomodation model :

public function accommodationRoom()
{
    return $this->Hasmany(AccommodationRoom::class);
}

and finaly in the room pricingHistory :

 public function accommodationRoom(){
    return $this->belongsTo(AccommodationRoom::class);
}

now in my accomodation controller i want to get All the accomodation with the room and from room i want to get the price so here is it

A = Accomodation
B = Room
C = price

and i want to call somehow like this

From A get B and The relation Of it with C and show all in A

Remul · Accepted Answer · 2019-04-29 12:56:43Z

2

You can use Laravels nested eager loading for this:

From the docs:

To eager load nested relationships, you may use "dot" syntax. For example, let's eager load all of the book's authors and all of the author's personal contacts in one Eloquent statement:

$books = App\Book::with('author.contacts')->get();

In your case:

$accomodations = Accomodation::with('accommodationRoom.roomPricingHistory')->get();

answered Apr 29, 2019 at 12:56

Remul

8,3221 gold badge16 silver badges31 bronze badges

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

Comments

Ahmed Aboud · Accepted Answer · 2019-04-29 12:51:47Z

1

nested-eager-loading

A::with('B.C');

answered Apr 29, 2019 at 12:51

Ahmed Aboud

1,34218 silver badges22 bronze badges

Collectives™ on Stack Overflow

how to load nested relationships in laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related