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

0 vote332 views1 answer
Codeigniter remote queries very slow
PHP
2 votes276 views2 answers
Carbon days ago
PHP
5 votes414 views2 answers
Laravel APP_ENV config
PHP
22 votes301 views2 answers
Php if elseif endif
PHP
1 vote329 views3 answers
How to store array in variable php
PHP
1 vote292 views1 answer
TreeBuilder::getRootNode()" before creating the root node is not supported, migrate to the new constructor signature instead.
PHP
0 vote267 views1 answer
Wordpress create post programmatically
PHP
0 vote309 views4 answers
How to host laravel project on local server
PHP
6 votes320 views2 answers
Create migration model and seeder laravel at once
PHP Laravel
1 vote344 views3 answers
Laravel JSON query
PHP