Laravel count data wise

    $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 vote246 views2 answers
Laravel JWTAuthentication
PHP Laravel
2 votes190 views3 answers
Foreach loop laravel
PHP Laravel
0 vote217 views1 answer
Laravel migration add contraint to other database
PHP Laravel
16 votes203 views4 answers
Add foreign key column laravel 5.8
PHP Laravel
3 votes212 views2 answers
Two condition in one laravel query
PHP Laravel
15 votes200 views3 answers
Get id user login laravel
PHP Laravel
2 votes189 views2 answers
Get message validator failed laravel
PHP Laravel
3 votes210 views2 answers
Laravel find by field
PHP Laravel
0 vote229 views1 answer
Laravel latest from relationship
PHP Laravel
11 votes185 views4 answers
Laravel create resource controller
PHP Laravel