/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

0 vote171 views1 answer
Laravel exclude field
PHP Laravel
0 vote153 views1 answer
Laravel routes options
PHP Laravel
14 votes169 views6 answers
Laravel debug
PHP Laravel
4 votes167 views2 answers
Laravel collection random
PHP Laravel
2 votes151 views4 answers
Laravel storage get file path
PHP Laravel
0 vote115 views1 answer
Laravel middleware in controller
PHP Laravel
1 vote160 views1 answer
Array_last in laravel 8
PHP Laravel
0 vote169 views2 answers
Laravel query where and
PHP Laravel
12 votes154 views4 answers
Count in laravel'
PHP Laravel
1 vote165 views1 answer
Laravel where equal
PHP Laravel