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

3 votes179 views2 answers
Set image asset path in laravel
PHP Laravel
0 vote173 views1 answer
Laravel How to access imagen uploaded in storage
PHP Laravel
4 votes192 views4 answers
Raw queries in laravel
PHP Laravel
7 votes164 views2 answers
Laravel seeder with relationships
PHP Laravel
39 votes169 views6 answers
Create table laravel
PHP Laravel
0 vote177 views1 answer
How check the time of operation in laravel
PHP Laravel
9 votes170 views3 answers
Laravel download
PHP Laravel
37 votes183 views6 answers
Laravel order by
PHP Laravel
2 votes176 views2 answers
Laravel websockets
PHP Laravel
31 votes163 views6 answers
Laravel update
PHP Laravel