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

12 votes135 views3 answers
Carbon in laravel documentation
PHP Laravel
1 vote141 views1 answer
Clear cache using laravel controller
PHP Laravel
-1 vote260 views1 answer
Laravel seo
PHP Laravel
3 votes138 views5 answers
How to create slug in laravel
PHP Laravel
0 vote158 views1 answer
Laravel display the date the participation was created
PHP Laravel
0 vote150 views1 answer
Laravel token logout
PHP Laravel
0 vote140 views1 answer
Laravel migration unknown column type double requested
PHP Laravel
1 vote146 views1 answer
Copy env example to .env in laravel
PHP Laravel
3 votes127 views1 answer
Laravel loop through collection
PHP Laravel
3 votes137 views4 answers
Laravel cors enable
PHP Laravel