/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

0 vote247 views1 answer
Laravel impossible to create the root directory
PHP Laravel
0 vote269 views1 answer
Onclick call route laravel
PHP Laravel
1 vote267 views1 answer
How send parameter with command in laravel
PHP Laravel
2 votes253 views2 answers
Laravel blade auth check
PHP Laravel
1 vote241 views1 answer
Do artisan laravel in code
PHP Laravel
0 vote284 views3 answers
Laravel 7 factory tinker
PHP Laravel
2 votes233 views4 answers
Laravel redirect action
PHP Laravel
0 vote275 views2 answers
Laravel collection search by value
PHP Laravel
1 vote258 views1 answer
Install tymon jwt laravel
PHP Laravel
1 vote263 views4 answers
Create json laravel
PHP Laravel