Search
 
SCRIPT & CODE EXAMPLE
 

PHP

group by laravel

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

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'));
Comment

PREVIOUS NEXT
Code Example
Php :: send html email laravel 
Php :: sanctum auth check? 
Php :: php not recognized 
Php :: laravel socialite 
Php :: Server Requirements in laraavel 9 
Php :: laravel unique column except self 
Php :: laravel-medialibrary packagist 
Php :: php convert string to boolean 
Php :: laravel migrate specific table 
Php :: how to make doctrine schema update in symfony 2.8 
Php :: php unset reference 
Php :: how get query logs in laravel 
Php :: get database columns laravel 
Php :: exec output php 
Php :: php clone datetime 
Php :: php save array in mysql database 
Php :: changing created_at to short date time 
Php :: how to use stored procedure in laravel 
Php :: infinite cookie good php ? 
Php :: php list directory files by date 
Php :: textarea laravel migration 
Php :: how to take last entry in database in laravel Method Two 
Php :: php file extension 
Php :: adding days in datetime php 
Php :: square root php 
Php :: 0 
Php :: get object tyhpe php 
Php :: laravel get parent from child 
Php :: how to stop laravel server 
Php :: destory session in laravel 
ADD CONTENT
Topic
Content
Source link
Name
6+9 =