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

2 votes198 views3 answers
Laravel fortify
PHP Laravel
5 votes200 views6 answers
Csrf token laravel
PHP Laravel
0 vote183 views1 answer
Optimize clear laravel not working
PHP Laravel
0 vote210 views1 answer
Select max id laravel
PHP Laravel
3 votes203 views2 answers
Create .env file in laravel with cmd
PHP Laravel
18 votes186 views6 answers
Laravel rename table
PHP Laravel
22 votes200 views2 answers
Where status is null sql in laravel
PHP Laravel
0 vote211 views2 answers
Laravel get url without domain in blade
PHP Laravel
0 vote214 views1 answer
Laravel stack script
PHP Laravel
0 vote202 views1 answer
Return single row from eloquent all collection laravel
PHP Laravel