/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

0 vote397 views4 answers
Form::select laravel
PHP Laravel
0 vote359 views3 answers
Method put laravel
PHP Laravel
0 vote391 views1 answer
Laravel session wont update
PHP Laravel
10 votes408 views4 answers
Print last query laravel
PHP Laravel
1 vote379 views1 answer
Human readable date laravel
PHP Laravel
2 votes406 views3 answers
How to change the colum type in migration laravel
PHP Laravel
26 votes396 views6 answers
Carbon in laravel
PHP Laravel
0 vote380 views1 answer
Nuxt auth login with laravel passport
PHP Laravel
0 vote370 views2 answers
Pass guzzle client data to view laravel
PHP Laravel
1 vote411 views2 answers
If null blade laravel
PHP Laravel