/PHP/Laravel/Laravel count group by date

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

6 votes175 views5 answers
Laravel disable cors
PHP Laravel
30 votes144 views6 answers
Laravel migration column types
PHP Laravel
3 votes169 views6 answers
Laravel find query
PHP Laravel
2 votes145 views1 answer
Laravel crud generator
PHP Laravel
0 vote140 views1 answer
Request update password laravel
PHP Laravel
0 vote134 views1 answer
Composer new project laravel acl
PHP Laravel
1 vote102 views1 answer
Redirect from laravel controller to another link
PHP Laravel
1 vote147 views1 answer
Laravel storage check file exists
PHP Laravel
0 vote144 views1 answer
Laravel collection all
PHP Laravel
0 vote147 views2 answers
Option value selected in laravel blade
PHP Laravel