/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 vote209 views1 answer
Php mess detector laravel
PHP Laravel
2 votes203 views1 answer
Laravel request validation rules for create and update
PHP Laravel
2 votes219 views2 answers
Laravel list of models
PHP Laravel
0 vote208 views1 answer
Onclick call route laravel
PHP Laravel
3 votes226 views2 answers
Laravel 7 view @php
PHP Laravel
1 vote204 views1 answer
Laravel password verification
PHP Laravel
31 votes187 views3 answers
Carbon laravel use
PHP Laravel
2 votes194 views1 answer
Laravel asset
PHP Laravel
0 vote199 views1 answer
Laravel assign class dynamically if condition true
PHP Laravel
3 votes272 views2 answers
Valdidate laravel if falid
PHP Laravel