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 vote213 views1 answer
How to separate admin and user login in laravel
PHP Laravel
0 vote216 views2 answers
Laravel collection reduce
PHP Laravel
1 vote213 views5 answers
Jobs laravel
PHP Laravel
2 votes196 views2 answers
Laravel insert timestamp now
PHP Laravel
0 vote205 views2 answers
Sweet alert confirm box laravel
PHP Laravel
1 vote219 views2 answers
Laravel compare date timestamp
PHP Laravel
2 votes169 views1 answer
Get the current route in laravel
PHP Laravel
10 votes191 views6 answers
Laravel blade date format
PHP Laravel
10 votes206 views4 answers
Compact laravel
PHP Laravel
12 votes208 views2 answers
Tomorrow carbon laravel
PHP Laravel