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

1 vote275 views1 answer
Php get index of current item array_reduce
PHP
39 votes290 views6 answers
Create table laravel
PHP Laravel
32 votes278 views6 answers
Date in php
PHP
-2 votes275 views3 answers
Php force array keys to lowercase
PHP
12 votes337 views3 answers
How to remove composer package in laravel
PHP
32 votes300 views4 answers
Php json encode
PHP
9 votes271 views5 answers
Get Current Page URL in PHP
PHP
5 votes286 views4 answers
Php exec
PHP
4 votes301 views2 answers
Laravel eloquent sum column
PHP
0 vote264 views1 answer
Hou to fill value in input box using php
PHP