Laravel Eloquent groupBy () And also returns the amount of each group

Question

I have a table that contains, among other columns, a browser version column. And I just want to find out from the recordset how many each type of browser has. So, I need in the end something like this: Total Records: 10; Internet Explorer 8: 2; Chrome 25: 4; Firefox 20: 4. (All with the addition of up to 10)

Here are my two pence:

$user_info = Usermeta::groupBy('browser')->get(); 

Of course, these are just three browsers, not the number of each. How can i do this?

Answer 1

This works for me:

 $user_info = DB::table('usermetas') ->select('browser', DB::raw('count(*) as total')) ->groupBy('browser') ->get(); 

Answer 2

This works for me (Laravel 5.1):

 $user_info = Usermeta::groupBy('browser')->select('browser', DB::raw('count(*) as total'))->get(); 

Answer 3

Thanks Antonio

I just added the lists command to the end, so it will return only one array with the key and counter:

Laravel 4

 $user_info = DB::table('usermetas') ->select('browser', DB::raw('count(*) as total')) ->groupBy('browser') ->lists('total','browser'); 

Laravel 5.1

 $user_info = DB::table('usermetas') ->select('browser', DB::raw('count(*) as total')) ->groupBy('browser') ->lists('total','browser')->all(); 

Laravel 5.2 +

 $user_info = DB::table('usermetas') ->select('browser', DB::raw('count(*) as total')) ->groupBy('browser') ->pluck('total','browser')->all(); 

Answer 4

It works the same way, a little more neatly. getQuery() simply returns a base constructor that already contains a table reference.

 $browser_total_raw = DB::raw('count(*) as total'); $user_info = Usermeta::getQuery() ->select('browser', $browser_total_raw) ->groupBy('browser') ->pluck('total','browser'); 

Answer 5

If you want a collection, groupBy and count:

 $collection = ModelName::groupBy('group_id') ->selectRaw('count(*) as total, group_id') ->get(); 

Hurrah!

Answer 6

1. Open config/database.php
2. Find strict key in mysql connection settings
3. Set the value to false

Answer 7

Here's an easier way to process a Laravel group without using raw operators.

 $sources = $sources->where('age','>', 31)->groupBy('age'); $output = null; foreach($sources as $key => $source) { foreach($source as $item) { //get each item in the group } $output[$key] = $source->count(); } 

Answer 8

Try with this

 ->groupBy('state_id','locality') ->havingRaw('count > 1 ') ->having('items.name','LIKE',"%$keyword%") ->orHavingRaw('brand LIKE ?',array("%$keyword%"))