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

1 vote280 views2 answers
Laravel eloquent with query extra parameter
PHP Laravel
0 vote252 views1 answer
Laravel collection tap
PHP Laravel
2 votes302 views3 answers
Laravel web php request to redirect to another page
PHP Laravel
2 votes283 views1 answer
Laravel migration with primary key
PHP Laravel
0 vote298 views1 answer
Laravel telescope tutorial
PHP Laravel
0 vote254 views1 answer
Lazy loading in laravel
PHP Laravel
1 vote263 views1 answer
Cart laravel
PHP Laravel
0 vote289 views1 answer
Laravel subtract date
PHP Laravel
1 vote293 views1 answer
How to check exist in array in rule validation laravel
PHP Laravel
0 vote307 views2 answers
Laravel tinker to test email on server
PHP Laravel