Laravel grouping where

Group by laravel

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

Source: stackoverflow.com

Laravel group by with where clause

$groupedSalesCampaign = Order::with('Campaign')
            ->where('isapproved','=','Y')
            ->groupBy('campaign_id')
            ->orderBy(DB::raw('COUNT(id)','desc'))
            ->get(array(DB::raw('COUNT(id) as totalsales'),'campaign_id'));

Source: stackoverflow.com

Laravel grouping where

User::where('username','john doe')
    ->where(function($query)
    {
        $query->where('age','>',30)
        ->orWhere('email','=','johndoe@xyz.com');
    })
    ->toSql();

Source: laracasts.com

Similar codes

11 votes327 views1 answer
Example wp-config.php for Debugging
PHP
3 votes336 views3 answers
Php my admin on linux
PHP
0 vote393 views1 answer
Laravel blade get array count in Blade
PHP Laravel
11 votes344 views3 answers
Laravel get last month records
PHP
40 votes349 views3 answers
Replace all numbers in string php
PHP
0 vote374 views1 answer
Modifier laravel migration to add a comment a column (MySQL/PostgreSQL)
PHP Laravel
2 votes319 views3 answers
Laravel middleware
PHP
2 votes395 views2 answers
Xampp check php version
PHP
33 votes321 views6 answers
Laravel query builder
PHP
0 vote325 views2 answers
Set modes magento 2
PHP