/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

24 votes168 views4 answers
Laravel query not null
PHP Laravel
49 votes220 views6 answers
Laravel clear all cache
PHP Laravel
1 vote161 views3 answers
Required_if laravel
PHP Laravel
2 votes179 views1 answer
Laravel middleware
PHP Laravel
4 votes155 views3 answers
Laravel 7 eloquent on delete set null schema
PHP Laravel
0 vote149 views1 answer
WithErrors laravel
PHP Laravel
4 votes149 views2 answers
Delete all rows in table laravel
PHP Laravel
5 votes151 views3 answers
How get some parameter from request in laravel
PHP Laravel
3 votes149 views2 answers
Laravel where condition on relationship
PHP Laravel
2 votes191 views2 answers
Validation not exist in table laravel
PHP Laravel