/PHP/Laravel/Laravel count group by date

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

13 votes115 views4 answers
Laravel hash
PHP Laravel
6 votes132 views2 answers
Laravel route regex except
PHP Laravel
7 votes158 views1 answer
Laravel db seed specific class
PHP Laravel
17 votes134 views4 answers
Laravel with trashed
PHP Laravel
0 vote147 views1 answer
Uncaught Error: Class 'Illuminate\Foundation\Application' in laravel bootstrap
PHP Laravel
4 votes139 views2 answers
Laravel please provide a valid cache path
PHP Laravel
0 vote129 views1 answer
Make() laravel
PHP Laravel
0 vote133 views1 answer
Laravel require vendor autoload
PHP Laravel
2 votes124 views2 answers
Truncate table laravel eloquent
PHP Laravel
10 votes126 views6 answers
Laravel blade date format
PHP Laravel