/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

10 votes202 views6 answers
Table laravel
PHP Laravel
5 votes200 views6 answers
Laravel sort collection
PHP Laravel
0 vote192 views1 answer
Pass variable in laravel ancher tag laravel 8
PHP Laravel
0 vote212 views1 answer
Laravel array search blade
PHP Laravel
24 votes292 views6 answers
Laravel create method
PHP Laravel
4 votes204 views1 answer
Create view from route laravel
PHP Laravel
0 vote198 views10 answers
Laravel relations find
PHP Laravel
1 vote195 views1 answer
Autoload file laravel
PHP Laravel
0 vote210 views4 answers
Laravel upload image
PHP Laravel
0 vote208 views1 answer
Check if column has value in laravel eloquent
PHP Laravel