SyntaxFix

[laravel] Laravel Eloquent groupBy() AND also return count of each group

Thanks Antonio,

I've just added the lists command at the end so it will only return one array with key and count:

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();

Examples related to laravel

• Parameter binding on left joins with array in Laravel Query Builder • Laravel 4 with Sentry 2 add user to a group on Registration • Target class controller does not exist - Laravel 8 • Visual Studio Code PHP Intelephense Keep Showing Not Necessary Error • The POST method is not supported for this route. Supported methods: GET, HEAD. Laravel • How to fix 'Unchecked runtime.lastError: The message port closed before a response was received' chrome issue? • Post request in Laravel - Error - 419 Sorry, your session/ 419 your page has expired • Expected response code 250 but got code "530", with message "530 5.7.1 Authentication required • How can I run specific migration in laravel • Laravel 5 show ErrorException file_put_contents failed to open stream: No such file or directory

Examples related to laravel-4

• Parameter binding on left joins with array in Laravel Query Builder • Laravel 4 with Sentry 2 add user to a group on Registration • 'Malformed UTF-8 characters, possibly incorrectly encoded' in Laravel • Can I do Model->where('id', ARRAY) multiple where conditions? • how to fix stream_socket_enable_crypto(): SSL operation failed with code 1 • Rollback one specific migration in Laravel • How can I resolve "Your requirements could not be resolved to an installable set of packages" error? • Define the selected option with the old input in Laravel / Blade • Redirect to external URL with return in laravel • laravel the requested url was not found on this server

Examples related to eloquent

• Eloquent: find() and where() usage laravel • How to select specific columns in laravel eloquent • Laravel Eloquent where field is X or null • Laravel Eloquent limit and offset • laravel collection to array • Eloquent get only one column as an array • Laravel 5.2 - Use a String as a Custom Primary Key for Eloquent Table becomes 0 • Laravel 5.2 - pluck() method returns array • Eloquent ORM laravel 5 Get Array of ids • eloquent laravel: How to get a row count from a ->get()