/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

3 votes195 views1 answer
Laravel loop through collection
PHP Laravel
0 vote206 views2 answers
Recaptcha v3 laravel 8
PHP Laravel
0 vote190 views1 answer
Ignore user id on email validation laravel
PHP Laravel
1 vote171 views2 answers
Laravel throttle
PHP Laravel
24 votes185 views6 answers
Laravel get auth user id
PHP Laravel
0 vote179 views1 answer
Laravel pivot select fields
PHP Laravel
0 vote183 views1 answer
Show all laravel valet folders
PHP Laravel
1 vote172 views1 answer
How delete the table in laravel in the commend
PHP Laravel
0 vote177 views1 answer
Verify laravel string must be null
PHP Laravel
16 votes136 views2 answers
How to save information on pdf file in laravel project
PHP Laravel