How to convert mysql query to laravel query builder?

Question

I have 2 tables and in first comments and article id, in second article title, id , category of article. I want has a title of article which has the most comments.

SELECT comments.article_id, news.title, news.category_id,
    COUNT(comments.id) as counts 
  FROM comments 
  JOIN news ON news.id = comments.article_id 
  GROUP BY(article_id) 
  ORDER BY counts DESC 
  LIMIT 3

I tried this:

  $articles = DB::table('comments')
        ->join('news', 'news.id', '=', ' comments.article_id')
        ->select(comments.article_id', 'news.title', ' news.category_id')
        ->count('comments.id')
        ->groupBy('article_id')
        ->orderBy(DB::raw('count(comments.id)', 'desc')
        ->limit(3)
        ->get();

But had:

Call to a member function groupBy() on integer

Anwar · Accepted Answer · 2018-08-06 12:29:58Z

2

You are using a "finisher", which means ->count('comments.id') does not return an instance of QueryBuilder anymore but a regular type (integer).

As integers in PHP are not classes, you are trying to perform a method on an non-class, which led to display this error message.

You surely know others finishers like ->sum(), ->all(), ->get(), ...

Just remove your line ->count('comments.id') and you will be good to go:

$articles = DB::table('comments')
  ->join('news', 'news.id', '=', ' comments.article_id')
  ->select('comments.article_id', 'news.title', ' news.category_id')
  ->groupBy('article_id')
  ->orderBy(DB::raw('count(comments.id)', 'desc')
  ->limit(3)
  ->get();

edited Aug 6, 2018 at 12:29

answered Aug 6, 2018 at 11:53

Anwar

4,3065 gold badges46 silver badges67 bronze badges

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

Comments

Harshavardhan · Accepted Answer · 2018-08-06 11:58:31Z

0

DB::table('comments')
->join('news', 'news.id', '=', ' comments.article_id')
->selectRaw('comments.article_id', 'news.title', ' news.category_id', 'count(comments.id) as countsxyz')
->groupBy('article_id')
->orderBy(DB::raw('countsxyz'), 'desc')
->limit(3)
->get();

try this and let me know if you still face any issue.

answered Aug 6, 2018 at 11:58

Harshavardhan

3821 silver badge6 bronze badges

1 Comment

Ksym Over a year ago

"selectRaw() must be of the type array, string given " again error

Collectives™ on Stack Overflow

How to convert mysql query to laravel query builder?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related