/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

3 votes329 views1 answer
Laravel firstOrFail
PHP Laravel
3 votes313 views2 answers
Create .env file in laravel with cmd
PHP Laravel
0 vote274 views1 answer
Laravel sanctum Protecting routes
PHP Laravel
24 votes306 views4 answers
Clear cache command in laravel controller
PHP Laravel
13 votes316 views3 answers
How to change existing migration laravel
PHP Laravel
0 vote295 views1 answer
Laravel create pivot migration
PHP Laravel
0 vote301 views1 answer
Laravel controller and model create same file name
PHP Laravel
0 vote305 views3 answers
Laravel sync with attributes
PHP Laravel
0 vote314 views1 answer
Jwt auth laravel auth without password field
PHP Laravel
0 vote345 views1 answer
Laravel event generate
PHP Laravel