/PHP/Laravel/Laravel count group by date

Laravel count group by date

    $usersData = User::select(DB::raw('DATE(created_at) as date'), DB::raw('count(*) as total'))
            ->groupBy('date')
            ->orderBy('date', 'desc')
            ->take(7)
            ->get();

Similar codes

33 votes119 views6 answers
How to run a specific migration in laravel
PHP Laravel
18 votes131 views6 answers
Laravel model
PHP Laravel
1 vote130 views1 answer
Laravel select all except some columns
PHP Laravel
0 vote126 views1 answer
Pagination in api laravel
PHP Laravel
1 vote139 views1 answer
Increment single column laravel
PHP Laravel
5 votes119 views3 answers
Laravel permission denied storage log
PHP Laravel
0 vote123 views1 answer
Laravel count distance lat/longtidue
PHP Laravel
1 vote128 views1 answer
Laravel redirect external url
PHP Laravel
-1 vote126 views1 answer
Add method to laravel blade
PHP Laravel
0 vote153 views1 answer
Count number of rows laravel controller
PHP Laravel