Laravel : How to count in query

Question

I have the following query :

App\User::join('gift_sents', function($builder){ $builder->on('gift_sents.receiver_id', '=', 'users.id'); }) ->select('users.*', 'COUNT(gift_sents.receiver_id as total_posts') ->groupBy('gift_sents.id') ->orderBy('total_posts', 'ASC') ->limit(3)->get();

The count isn't working, Its supposed to be working !

The following error comes up :

Column not found: 1054 Unknown column 'COUNT(gift_sents.receiver_id' in 'field list' (SQL: selectusers.*,COUNT(gift_sents.receiver_idastotal_postsfromusersinner joingift_sentsongift_sents.receiver_id=users.idgroup bygift_sents.idorder bytotal_postsasc limit 3)

You have a typo in your select statement, make sure to close your COUNT open parenthesis. ->select('users.*', 'COUNT(gift_sents.receiver_id as total_posts)') — Everett Green
– Everett Green, Commented Jul 16, 2016 at 18:53

TheDeveloper · Accepted Answer · 2016-07-17 11:14:49Z

6

i think it should be:

 ->select('users.*', DB::raw('COUNT(gift_sents.receiver_id) as total_posts'))

see doc here - 'Raw Expressions' section

edited Jul 17, 2016 at 11:14

answered Jul 16, 2016 at 18:55

TheDeveloper

9401 gold badge16 silver badges38 bronze badges

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

Comments

Marcin Nabiałek · Accepted Answer · 2016-07-16 20:16:46Z

Instead of:

->select('users.*', 'COUNT(gift_sents.receiver_id as total_posts')

you should use:

->selectRaw('users.*, COUNT(gift_sents.receiver_id) as total_posts')

Collectives™ on Stack Overflow

Laravel : How to count in query

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related