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

0 vote328 views1 answer
Laravel migration first or model first
PHP Laravel
3 votes364 views2 answers
Laravel route multiple methods
PHP Laravel
3 votes364 views1 answer
Laravel back button
PHP Laravel
0 vote361 views1 answer
Laravel 404 not found not showing error
PHP Laravel
0 vote370 views1 answer
Add controller to laravel with requests
PHP Laravel
5 votes340 views1 answer
Laravel model method like foreach parts of
PHP Laravel
1 vote367 views1 answer
Laravel php artisan make:controller in subfolder
PHP Laravel
0 vote395 views2 answers
Laravel collection search
PHP Laravel
14 votes389 views6 answers
Laravel create model and migration
PHP Laravel
0 vote384 views1 answer
Laravel app service provider why eloquent model error
PHP Laravel