/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

3 votes209 views4 answers
Input if not null laravel
PHP Laravel
0 vote213 views2 answers
Laravel required_if fileld has value
PHP Laravel
13 votes190 views6 answers
Find auth laravel
PHP Laravel
0 vote206 views1 answer
Laravel check if model relation exists
PHP Laravel
6 votes209 views2 answers
Laravel migrations generator laravel
PHP Laravel
2 votes213 views2 answers
Laravel sidebar menu active
PHP Laravel
10 votes270 views4 answers
Laravel migration change column default
PHP Laravel
0 vote172 views1 answer
How to pass parameter to middleware from route in laravel
PHP Laravel
0 vote210 views1 answer
Laravel favicon
PHP Laravel
13 votes196 views3 answers
Laravel string
PHP Laravel