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

1 vote355 views1 answer
Laravel websockets onclose
PHP Laravel
0 vote296 views1 answer
Laravel touches
PHP
5 votes360 views2 answers
Laravel group by with where clause
PHP Laravel
1 vote293 views1 answer
Php dom add class to element
PHP
5 votes315 views3 answers
Php get non unique values from array
PHP
2 votes319 views2 answers
Laravel relationship with for single data
PHP
29 votes291 views1 answer
Calculate date diff php
PHP
6 votes337 views3 answers
Php artisan ui auth
PHP
0 vote303 views1 answer
Laravel - Add conditional where clause in query
PHP
12 votes315 views3 answers
For else laravel
PHP Laravel