/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

1 vote301 views6 answers
Laravel get url parameters in controller
PHP Laravel
0 vote301 views1 answer
Create a custom method laravel model
PHP Laravel
12 votes286 views6 answers
Laravel redirect back with input
PHP Laravel
4 votes270 views1 answer
Disable register laravel
PHP Laravel
6 votes278 views3 answers
Laravel foreach loop index from 1
PHP Laravel
1 vote302 views5 answers
Laravel jobs tutorial
PHP Laravel
1 vote327 views1 answer
Laravel add (s) at the end of text based on how many data
PHP Laravel
7 votes306 views3 answers
How to show validation error in laravel blade
PHP Laravel
3 votes300 views2 answers
Laravel required if another field has value
PHP Laravel
4 votes312 views3 answers
Laravel cmd command to watch logs
PHP Laravel