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

16 votes285 views4 answers
Wherenotnull laravel
PHP Laravel
21 votes287 views6 answers
Laravel seeder update
PHP Laravel
1 vote298 views1 answer
Cart laravel
PHP Laravel
1 vote287 views1 answer
Laravel makeHidden
PHP Laravel
9 votes304 views5 answers
Laravel create password hash
PHP Laravel
26 votes294 views6 answers
Laravel migration rollback
PHP Laravel
7 votes290 views4 answers
$errors show this error in laravel
PHP Laravel
47 votes329 views6 answers
How to run specific seeder in laravel
PHP Laravel
5 votes279 views5 answers
Laravel csrf token off
PHP Laravel
3 votes299 views6 answers
Laravel cors
PHP Laravel