Level 2
Remove
count()
and then in your view
{{count($numberoftwits)}}
Dec 6, 2017
8
Level 1
New on laravel (doing a query with groupby and count)
Snippet in the controller
$numberoftwits = DB::table('twits')
->groupBy('user_id')
->count()
->get();
mysql query
SELECT COUNT(*) FROM twits GROUP BY user_id
Error Call to a member function get() on integer
What should I do in order to pass the result of the query to the compact statement in the controller?
Level 48
Or if you just want the count, remove the ->get();
$numberoftwits = DB::table('twits')
->groupBy('user_id')
->count();
1 like
Level 1
both solutions didnt not work however I was able to solve the problem by using db raw
$numberoftwits = DB::table('twits')
->select(DB::raw('count(*) as num'))
->groupBy('user_ID')
->get();
3 likes
Level 48
Both solutions work well, in both situations you get the count/total records. In your last post you changed the query requirements, thats not what you asked ;)
1 like
Level 1
actually its just the same look at my expected mysql query, i just called db raw to call it as it is :) the problem is that Im using count() the wrong way
1 like
Level 1
i have 2 tables (posts, users) and they are related with user_id column, i wanted to get the count of the posts grouped by the user_id so i did this:
Post::all()->groupBy('user_id');
it will return a collection object key => value, the key is the user_id and the value is an array of posts that are related to that user
Level 122
@abdelrhman-saeed start a question
Level 1
@Snapey actually i thought i was replaying
Please or to participate in this conversation.