/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

8 votes254 views1 answer
How to migrate single table in laravel
PHP Laravel
5 votes243 views2 answers
Laravel access controller method from another controller
PHP Laravel
18 votes227 views4 answers
Use if in laravel blade
PHP Laravel
18 votes232 views6 answers
Laravel rename table
PHP Laravel
1 vote209 views2 answers
Class name laravel
PHP Laravel
0 vote231 views1 answer
How to create table for every user in laravel
PHP Laravel
1 vote222 views2 answers
Laravel throttle
PHP Laravel
2 votes229 views2 answers
File exist check in laravel blade
PHP Laravel
0 vote253 views1 answer
Laravel get file to browser send
PHP Laravel
18 votes231 views6 answers
Laravel unique validation
PHP Laravel