Laravel count 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

4 votes171 views2 answers
Switch in laravel
PHP Laravel
0 vote180 views1 answer
Check if variable is set and not empty laravel
PHP Laravel
0 vote190 views1 answer
Laravel get host with http
PHP Laravel
0 vote191 views1 answer
Laravel make migration controller resource mcr
PHP Laravel
7 votes169 views1 answer
Ternary operator laravel blade
PHP Laravel
-1 vote172 views2 answers
Adminlte 3 laravel
PHP Laravel
0 vote199 views1 answer
Laravel add model to one to many relationship
PHP Laravel
1 vote159 views1 answer
Getoriginal laravel
PHP Laravel
-1 vote162 views2 answers
How to Delete Multiple Records using Checkbox in Laravel
PHP Laravel
0 vote192 views1 answer
Laravel count group by date
PHP Laravel