Laravel loading two models into one list

Question

I have 3 models: User - have many Comments Article - belongs to User Comment - belongs to User, Article In user profile I would like to show all paginated actions of given user. What is best and most effective way to do it?

By actions I've meant both comments and articles added by user, and paginated - returned in Paginator class with both Comment and Article classes In it. — Hubert, Nov 21 '14 at 18:25

score 0 · Answer 1 · answered Sep 14 '15 at 22:21

0

DB::table('users')
        ->leftJoin('comments', 'users.id', '=', 'comments.user_id')
        ->leftJoin('articles', 'users.id', '=', 'articles.user_id')
        ->paginatuse(30);

answered Sep 14 '15 at 22:21

Mehrdad Hedayati

1,434
13
14

score 0 · Answer 2 · answered Sep 15 '15 at 00:26

0

$user= new User::find(1)
->with('comments')
->with('articles')
->get();

You might not need the get() , am not sure

answered Sep 15 '15 at 00:26

AlhasanIQ

183
2
9

Laravel loading two models into one list

2 Answers2