/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

1 vote119 views1 answer
Diff for seconds laravel carbon
PHP Laravel
0 vote107 views2 answers
Laravel set middleware default
PHP Laravel
0 vote136 views2 answers
Save big data with laravel
PHP Laravel
0 vote139 views1 answer
Laravel parse markdown
PHP Laravel
0 vote133 views1 answer
Dummy data in laravel
PHP Laravel
0 vote129 views1 answer
Background image in laravel blade
PHP Laravel
1 vote148 views2 answers
Faker image laravel 8
PHP Laravel
1 vote208 views3 answers
Laravel destroy or delete
PHP Laravel
6 votes121 views2 answers
Laravel check if request has value
PHP Laravel
0 vote423 views2 answers
Laravel composer sanctum
PHP Laravel