/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

7 votes229 views3 answers
Laravel seed migrate
PHP Laravel
0 vote208 views1 answer
PaymentIntent::create laravel
PHP Laravel
0 vote207 views1 answer
Copy file from one directory to another Laravel
PHP Laravel
-1 vote191 views1 answer
Create new record via model in laravel
PHP Laravel
0 vote184 views1 answer
Clear from faild_jobs laravel
PHP Laravel
1 vote200 views1 answer
Why storage link do not work in host for laravel
PHP Laravel
0 vote196 views1 answer
Why phpunit don't work in commend laravel
PHP Laravel
3 votes278 views2 answers
Laravel validate telephone number
PHP Laravel
0 vote184 views1 answer
Laravel print executed query
PHP Laravel
1 vote213 views3 answers
How to create controller in specific folder laravel
PHP Laravel