Laravel count 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 vote203 views1 answer
Date format in laravel month name day name
PHP Laravel
2 votes234 views3 answers
How to get the size of an uploaded file in laravel
PHP Laravel
0 vote155 views1 answer
Laravel eloquent mass assignments
PHP Laravel
0 vote204 views1 answer
Laravel media library regenerate
PHP Laravel
50 votes273 views6 answers
Add column in laravel migration
PHP Laravel
42 votes195 views6 answers
Laravel 8 foreign key
PHP Laravel
1 vote267 views1 answer
How to add property to the request object in laravel
PHP Laravel
4 votes213 views2 answers
Display all errors at once in laravel
PHP Laravel
0 vote200 views6 answers
Hash password decrypt laravel
PHP Laravel
16 votes253 views5 answers
Get user auth in laravel
PHP Laravel