Group by laravel

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

Source: stackoverflow.com

Laravel db::query update

 DB::table('user')->where('email', $userEmail)->update(array('member_type' => $plan));

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 groupby and latest

//If You want the latest id of records then you can use unique() after get(),
//don't use group by if you use groupBy 
//then you lose your control from id. I hope this is useful for you

myModel::select('id','purch','name','prcvalue')
  ->where('purch','=','10234')
  ->orderBy('prcvalue','DESC')
  ->get()
  ->unique('name');

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 vote321 views2 answers
Laravel filesystem
PHP Laravel
29 votes351 views3 answers
Laravel clear page cache
PHP Laravel
0 vote385 views2 answers
Option selected in laravel blade
PHP Laravel
2 votes378 views2 answers
Increase memory laravel controller
PHP Laravel
0 vote373 views1 answer
Filter from taggable laravel
PHP Laravel
13 votes312 views6 answers
Route group in laravel
PHP Laravel
4 votes357 views3 answers
Delete all records from table using button laravel Eloquent
PHP Laravel
31 votes307 views6 answers
Update or create laravel
PHP Laravel
15 votes308 views3 answers
How to install bootstrap in laravel 8 with auth
PHP Laravel
0 vote278 views3 answers
Laravel collection sort
PHP Laravel