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

21 votes219 views4 answers
Laravel where not
PHP Laravel
46 votes227 views6 answers
Clear laravel cache
PHP Laravel
1 vote253 views1 answer
Get year in laravel 8
PHP Laravel
0 vote207 views2 answers
Where () laravel Eloquent
PHP Laravel
0 vote236 views1 answer
Laravel check if primary key exists
PHP Laravel
9 votes234 views2 answers
Laravel query count raw
PHP Laravel
0 vote215 views1 answer
Delete image s3 laravel
PHP Laravel
0 vote220 views1 answer
Curl failed laravel centos
PHP Laravel
0 vote235 views1 answer
Laravel has one of many relationship
PHP Laravel
16 votes235 views3 answers
Make a forign key in migrations using laravel 8
PHP Laravel