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

41 votes251 views6 answers
Time in php
PHP
0 vote268 views2 answers
Convert string to array laravel
PHP Laravel
0 vote267 views1 answer
Route pattern cannot reference variable name more than once. laravel
PHP
1 vote288 views1 answer
Supervisor configuration for laravel queue
PHP Laravel
2 votes232 views3 answers
How to get the size of an uploaded file in laravel
PHP
0 vote241 views1 answer
Laravel mix build as umd
PHP Laravel
0 vote217 views1 answer
Laravel get week dates
PHP
90 votes296 views6 answers
Php string contains
PHP
1 vote273 views1 answer
Laravel 6 make http request
PHP Laravel
4 votes231 views5 answers
Laravel route multiple middleware
PHP