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 votes94 views1 answer
Php remove query param from url
PHP
0 vote110 views1 answer
Laravel permit only some inputs
PHP Laravel
1 vote92 views1 answer
How to add dummy records using factory in laravel 8
PHP
0 vote86 views2 answers
Old codestar textarea field
PHP
6 votes97 views2 answers
Laravel migration integer
PHP
50 votes98 views6 answers
Left join laravel
PHP
-2 votes110 views3 answers
Connect database using php
PHP
0 vote105 views1 answer
Laravel blade dynamic class loop foreach
PHP Laravel
0 vote125 views1 answer
Livewire modal to datetime-local
PHP
0 vote96 views1 answer
Php define variable type
PHP