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

16 votes247 views6 answers
Laravel run migration
PHP Laravel
2 votes266 views3 answers
Laravel Create Custom Artisan Command
PHP Laravel
5 votes216 views3 answers
Laravel permission denied storage log
PHP Laravel
0 vote258 views1 answer
Add variables to line in laravel notification
PHP Laravel
17 votes239 views6 answers
Update query laravel
PHP Laravel
0 vote203 views1 answer
Laravel blade trim whitespace
PHP Laravel
0 vote255 views1 answer
Laravel run php server by ipv4
PHP Laravel
0 vote261 views1 answer
How to loop array in laravel
PHP Laravel
0 vote231 views1 answer
Make() laravel
PHP Laravel
0 vote227 views1 answer
Laravel change string to text
PHP Laravel