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

7 votes302 views3 answers
Php combine values of two arrays
PHP
1 vote338 views2 answers
Laravel migration check if table has column
PHP
0 vote330 views1 answer
Upload image to mysqli database
PHP
-1 vote276 views1 answer
Phpunit/phpunit[6.0.0, ..., 6.5.14] require php ^7.0 -> your php version (8.0.0) does not satisfy that requirement.
PHP
3 votes318 views3 answers
Laravel csrf-token in view
PHP Laravel
-1 vote293 views3 answers
Unsplash php api
PHP
0 vote327 views1 answer
Date hour php
PHP
0 vote316 views1 answer
How to add a css class to login page in wordpress
PHP Wordpress
2 votes282 views1 answer
Add id to route name in laravel blade
PHP
0 vote278 views1 answer
Symfony Expected argument of type "string", "null" given
PHP