/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

1 vote191 views2 answers
Add laravel sail build as alias
PHP Laravel
0 vote212 views1 answer
Laravel post request search query
PHP Laravel
0 vote206 views1 answer
Laravel dingo api response
PHP Laravel
0 vote213 views2 answers
Access paginator object attribute in laravel
PHP Laravel
4 votes188 views4 answers
Laravel check if table has column
PHP Laravel
1 vote190 views2 answers
Laravel ckeditor
PHP Laravel
3 votes215 views2 answers
Laravel 8 Target class [FormController] does not exist.
PHP Laravel
2 votes177 views2 answers
Laravel create migration file
PHP Laravel
1 vote206 views1 answer
Laravel emial unique igration error
PHP Laravel
1 vote173 views2 answers
Laravel return response view
PHP Laravel