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 vote156 views1 answer
Disable laravel passport
PHP Laravel
2 votes153 views5 answers
Laravel drop table migration
PHP Laravel
0 vote181 views2 answers
Laravel lumen
PHP Laravel
8 votes167 views5 answers
Laravel belongs to
PHP Laravel
0 vote163 views1 answer
Laravel collection intersectKey
PHP Laravel
0 vote143 views1 answer
Laravel model isdirty
PHP Laravel
3 votes148 views3 answers
Where with and and or in a laravel
PHP Laravel
4 votes97 views2 answers
Laravel get current route in app.js
PHP Laravel
2 votes154 views1 answer
Count() parameter must be an array or an object that implements countable laravel
PHP Laravel
5 votes160 views4 answers
App url laravel
PHP Laravel