laravel - Get last comments with unique user

Question

how I can get fetch my 10 last comments with just 1 comment per user in laravel

I saw this but I want do it with eloquent in clean way

what are you trying to achieve? if you designed your tables wrong it is most likely that you will need to loop outside of Eloquent. — Anil M, Mar 22 '18 at 13:44

Anil M · Answer 1 · 2018-03-22T15:53:48.700

1

Did you try

Comment::groupBy('user_id')->limit(10)->get();

If you want to get latest comments, create a class called UserComment and store latest comment_id for each user and update it for each new comment created, then You can fetch latest 10 comments by

UserComment::orderBy('updated_at')->limit(10)->get();

edited Mar 22 '18 at 15:53

answered Mar 22 '18 at 13:37

Anil M

100
8

1

groupBy isn't solution because not return latest comments – Mahdi Majidzadeh Mar 22 '18 at 15:47

score 0 · Answer 2 · answered Mar 22 '18 at 14:35

0

This is the logic:

Comment::groupBy('user_id')->orderBy('id', 'desc')->first();

answered Mar 22 '18 at 14:35

Eazy Sam

288
1
2
9

`skip(0)->take(10);` is missing – Eazy Sam Mar 22 '18 at 14:43
groupBy isn't solution because not return latest comments – Mahdi Majidzadeh Mar 22 '18 at 15:47
`orderBy('id', 'desc')` OR `orderBy('id', 'created_at')` will take latest records, now its **how to fetch 10 comments 1 per each?**. You sure not to do a PHP iteration with the collection? – Eazy Sam Mar 23 '18 at 05:14

score 0 · Answer 3 · answered Mar 22 '18 at 14:53

0

If you can find the latest comments by the highest ids:

$ids = Comment::selectRaw('MAX(id) id')->groupBy('user_id')->take(10)->pluck('id');
$comments = Comment::whereIn('id', $ids)->orderByDesc('id')->get();

answered Mar 22 '18 at 14:53

Jonas Staudenmeir

24,815
6
63
109

same as others, groupBy isn't solution because not return latest comments – Mahdi Majidzadeh Mar 22 '18 at 15:51
That's achieved by `MAX(id)`. Did you try it? – Jonas Staudenmeir Mar 22 '18 at 15:53

laravel - Get last comments with unique user

3 Answers3