Laravel count 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 vote325 views1 answer
Laravel npm build production
PHP Laravel
2 votes300 views2 answers
Importing current year in laravel blade
PHP Laravel
0 vote364 views1 answer
Combine 2 columns search query laravel
PHP Laravel
-1 vote408 views1 answer
When to create a service in laravel
PHP Laravel
7 votes354 views1 answer
Laravel not in query
PHP Laravel
4 votes364 views4 answers
Laravel 8 carbon if date is today
PHP Laravel
0 vote374 views1 answer
Laravel faker select between options
PHP Laravel
7 votes341 views3 answers
Laravel migration seed fresh
PHP Laravel
0 vote354 views1 answer
Laravel Add regx on password
PHP Laravel
3 votes358 views1 answer
Enie letter validation laravel regex
PHP Laravel