Laravel "nested" with()

Question

I have 3 models: Article, Comment, Reaction.

Each article has many comments, and each comment has many reactions:

App\Article:

class Article extends Model
{
    public function comments() {
        return $this->hasMany('App\Comment');
    }
}

App\Comment:

class Comment extends Model
{
    public function article() {
        return $this->belongsTo('App\Article');
    }

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

App\Reaction:

class Reaction extends Model
{
    public function comment() {
        return $this->belongsTo('App\Comment');
    }
}

In my ArticleController@index I want to fetch comments and their reactions:

ArticleController:

public function index()
{
    $articles = Article::with('comments')
                ->select('articles.*')
                ->leftjoin('comments', 'comments.article_id', '=', 'articles.id')
                ->get();

    return view('wiki')->withArticles($articles);
}

I can loop through the comments ($article->comments), however I'm not sure how to do a with('reactions') for the comments? i.e.,

@foreach($article->comments as $comment)
    @foreach($comment->reactions)
        // something like this...
    @endforeach
@endforeach

Is it really necessary to use the with method? You can just as easily get all the articles using Articles::all(); — Nick Tucci
– Nick Tucci, Commented Oct 12, 2016 at 8:48
@Adherence - didn't know it joined them automatically with the all() method, thanks! — frosty
– frosty, Commented Oct 12, 2016 at 9:46

StateLess · Accepted Answer · 2016-10-12 08:58:04Z

1

you can do Nested Eager Loading

$article = Article::with('comments.reactions')
                ->leftjoin('comments', 'comments.article_id', '=', 'articles.id')
                ->select('articles.*')
                ->get();

edited Oct 12, 2016 at 8:58

answered Oct 12, 2016 at 8:49

StateLess

5,4023 gold badges22 silver badges30 bronze badges

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

2 Comments

frosty Over a year ago

What about the reactions?

StateLess Over a year ago

@frosty check now,added articles by mistake

Ronak Dattani · Accepted Answer · 2016-10-12 09:50:14Z

0

You can also do this way

ArticleController:

 public function index()
    {
        $articles = Article::with('comments')
                    ->select('articles.*')
                    ->get();

        return view('wiki')->withArticles($articles);
    }

App\Article:

class Article extends Model
{
    public function comments() {
        return $this->hasMany('App\Comment')->with('reactions');
    }
}

App\Comment:

class Comment extends Model
{
    public function article() {
        return $this->belongsTo('App\Article');
    }

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

answered Oct 12, 2016 at 9:50

Ronak Dattani

4663 silver badges10 bronze badges

Collectives™ on Stack Overflow

Laravel "nested" with()

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related