Breaking News: Grepper is joining You.com. Read the official announcement!

how to get posts that have most comments with laravel

Poor Pygmy answered on June 11, 2023 Popularity 3/10 Helpfulness 1/10

answer how to get posts that have most comments with laravel

how to get posts that have most comments with laravel

Comment

$posts = Post::withCount('comments')
                ->orderBy('comments_count', 'desc')
                ->get();
                return $posts;
                
                Post::withCount('comments'): This line retrieves all the posts using the Post model. The withCount() method is used to include a count of the related comments for each post. It creates a new attribute named comments_count on each Post model instance, which represents the number of associated comments.

->orderBy('comments_count', 'desc'): This line sorts the retrieved posts based on the comments_count attribute in descending order. It ensures that the posts with the highest comment count appear first in the result set.

->get(): This line executes the query and retrieves the results. It returns a collection of Post models, sorted by the number of comments in descending order.

Popularity 3/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: comments get laravel php posts

Link to this answer
Share Copy Link

Contributed on Jun 11 2023

Poor Pygmy

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

how to get posts that have most comments with laravel

Contents

More Related Answers

how to get posts that have most comments with laravel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.