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

6 votes233 views3 answers
Laravel ide-helper
PHP Laravel
0 vote192 views1 answer
Verta sample jalali laravel problem return object
PHP Laravel
1 vote185 views1 answer
Publishing laravel module package
PHP Laravel
2 votes183 views1 answer
Laravel eager loading where clause
PHP Laravel
3 votes194 views2 answers
Clear log file laravel command
PHP Laravel
-1 vote183 views1 answer
Create new record via model in laravel
PHP Laravel
46 votes240 views5 answers
Add column migration laravel
PHP Laravel
1 vote191 views2 answers
Laravel check if object is empty
PHP Laravel
0 vote200 views1 answer
Laravel telescope redirect to localhost
PHP Laravel
1 vote189 views1 answer
Human readable date laravel
PHP Laravel