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

1 vote271 views1 answer
How to return data in json format in laravel
PHP Laravel
0 vote273 views1 answer
Les étape d'integration du templates adminlte de Laravel pour application
PHP Laravel
2 votes258 views6 answers
Laravel sanctum authentication
PHP Laravel
0 vote267 views1 answer
Laravel Exclude URI from csrf token verification
PHP Laravel
26 votes268 views4 answers
Where is cache file in laravel
PHP Laravel
14 votes242 views5 answers
Laravel debugbar
PHP Laravel
12 votes273 views6 answers
Laravel model where
PHP Laravel
0 vote302 views1 answer
Laravelda urlga requestlarni cheklash
PHP Laravel
0 vote232 views1 answer
Laravel token logout
PHP Laravel
0 vote217 views1 answer
Refresh laravel model
PHP Laravel