Retrieve data from multiple related table in laravel

Question

I have 3 related models. 1.User

public function book(){
        return $this->hasMany('App\Book');
    }

2.Book

public function photo(){
        return $this->hasMany('App\Books_photo');
    }

    public function user(){
        return $this->belongsTo('App\User');
    }

3.Books_photo

public function book(){
        return $this->belongsTo('App\Book');
    }

The relations are

User hasmany Book

and

Book hasmany Books_photo

So I want to get all the books with their photo of a particular user.

I can get all the books of a user.I'm using this approach

$User = User::with('book')->find(decrypt($request->id));

But this returns only the data in book and user table. How can i fetch the photos too.

sjdaws · Accepted Answer · 2017-06-12 01:45:55Z

1

You're looking for nested eager loading. You will want to do this:

$User = User::with('book', 'book.photo')->find(decrypt($request->id));

The book.photo is a nested eager load that will tell eloquent to get the photo relation from the book model.

answered Jun 12, 2017 at 1:45

sjdaws

3,55619 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Retrieve data from multiple related table in laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related