/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

2 votes218 views1 answer
Laravel meilisearch flush
PHP Laravel
19 votes220 views6 answers
Laravel Route Group
PHP Laravel
3 votes276 views1 answer
Laravel check if array is empty
PHP Laravel
13 votes256 views5 answers
Zsh: command not found: laravel
PHP Laravel
1 vote229 views2 answers
Laravel generate unique db token
PHP Laravel
0 vote245 views1 answer
Laravel collection collapse
PHP Laravel
0 vote254 views1 answer
Laravel hasMany with join
PHP Laravel
0 vote239 views1 answer
Laravel recursive relationships
PHP Laravel
1 vote218 views3 answers
Required_if laravel
PHP Laravel
6 votes235 views3 answers
Laravel ecommerce
PHP Laravel