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

0 vote144 views1 answer
Laravel set innodb scema builder
PHP Laravel
1 vote150 views1 answer
Copy env example to .env in laravel
PHP Laravel
3 votes97 views1 answer
Current time stamp in laravel
PHP Laravel
2 votes151 views1 answer
Add to url anchor tag laravel with variable
PHP Laravel
9 votes146 views2 answers
Laravel Str::random
PHP Laravel
0 vote148 views1 answer
Extensions for laravel command ubuntu 20.04
PHP Laravel
12 votes154 views1 answer
Laravel model without timestamps
PHP Laravel
11 votes148 views3 answers
How to remove composer package in laravel
PHP Laravel
35 votes155 views3 answers
Run seeder command in laravel
PHP Laravel
11 votes149 views4 answers
Laravel 8 password confirmation validation
PHP Laravel