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

6 votes213 views2 answers
Nav active in laravel
PHP Laravel
0 vote190 views1 answer
How can get attribute without getter in laravel
PHP Laravel
5 votes189 views1 answer
Laravel model method like foreach parts of
PHP Laravel
0 vote285 views1 answer
Relationship on the base of condition in laravel
PHP Laravel
0 vote241 views2 answers
Laravel eloquent multiple join with where conditions
PHP Laravel
2 votes184 views4 answers
Laravel where in array
PHP Laravel
7 votes179 views3 answers
Laravel 8 validation unique 2 columns
PHP Laravel
1 vote190 views1 answer
Integer default value laravel
PHP Laravel
0 vote194 views1 answer
Laravel relationship retrieve data
PHP Laravel
0 vote185 views1 answer
Laravel jwt check token sent by request is valid
PHP Laravel