/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 vote239 views2 answers
Adminlte con laravel 8
PHP Laravel
4 votes257 views2 answers
Laravel attach
PHP Laravel
2 votes244 views2 answers
Get users other than specific role laravel role spatie
PHP Laravel
1 vote230 views1 answer
How to return with open model popup in laravel
PHP Laravel
4 votes230 views2 answers
Switch in laravel
PHP Laravel
5 votes215 views2 answers
Laravel vue
PHP Laravel
5 votes230 views2 answers
Laravel chmod
PHP Laravel
13 votes214 views6 answers
Laravel delete
PHP Laravel
5 votes229 views2 answers
Laravel redirect with message to section
PHP Laravel
2 votes212 views1 answer
Proper permission webserver laravel
PHP Laravel