/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

1 vote227 views1 answer
Laravel validation on fields inside array in request
PHP Laravel
5 votes275 views4 answers
Laravel response redirect
PHP Laravel
5 votes295 views3 answers
Crrate model in laravel
PHP Laravel
0 vote295 views1 answer
File original extensions laravel
PHP Laravel
-4 votes320 views1 answer
Alert laravel 7
PHP Laravel
26 votes318 views6 answers
Carbon in laravel
PHP Laravel
4 votes307 views3 answers
Laravel migration index
PHP Laravel
49 votes342 views6 answers
Laravel clear all cache
PHP Laravel
5 votes285 views3 answers
Display all errors in blade laravel
PHP Laravel
-1 vote252 views1 answer
Check request method laravel
PHP Laravel