/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 vote194 views1 answer
Laravel carbon Could not parse '28/09/2021, 12:00:00 pm': DateTime::__construct(): Failed to parse time string (28/09/2021, 12:00:00 pm) at position 0 (2): Unexpected character
PHP Laravel
0 vote207 views1 answer
Media library laravel maximum allowed size
PHP Laravel
42 votes166 views6 answers
Laravel 8 foreign key
PHP Laravel
0 vote182 views1 answer
Laravel 8 get app folder
PHP Laravel
5 votes181 views2 answers
Route() and with() in laravel
PHP Laravel
0 vote182 views2 answers
Send html from datatable in laravel
PHP Laravel
1 vote172 views4 answers
Laravel form request validation api
PHP Laravel
2 votes161 views4 answers
Laravel storage get file path
PHP Laravel
1 vote187 views1 answer
How to add dummy records using factory in laravel 8
PHP Laravel
0 vote199 views1 answer
Laravel new line in language file
PHP Laravel