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

4 votes210 views4 answers
Multiple middleware laravel
PHP Laravel
9 votes230 views3 answers
Pass variable to blade laravel
PHP Laravel
7 votes192 views3 answers
Php artisan serve port
PHP
0 vote176 views1 answer
Php+js,code
PHP
1 vote219 views1 answer
Cake tmp name
PHP CakePHP
0 vote183 views1 answer
Method Illuminate\Support\Collection::appends does not exist.
PHP
0 vote185 views1 answer
How to convert php code to html
PHP
6 votes188 views2 answers
How to calculate the sum of values in a list PHP
PHP
0 vote175 views2 answers
Php string max length
PHP
1 vote171 views1 answer
Change the maximum upload file size
PHP