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 vote303 views1 answer
Static function model laravel
PHP Laravel
0 vote222 views1 answer
Str not found laravel
PHP Laravel
1 vote225 views2 answers
Use multiple database in laravel
PHP Laravel
1 vote234 views1 answer
Laravel uppercase first letter
PHP Laravel
15 votes246 views2 answers
Update column value laravel
PHP Laravel
1 vote225 views1 answer
Invalid datetime format laravel
PHP Laravel
0 vote227 views1 answer
2 days left format in laravel
PHP Laravel
-2 votes237 views3 answers
Laravel when condition
PHP Laravel
2 votes232 views3 answers
Laravel url with parameters blade
PHP Laravel
0 vote223 views1 answer
Laravel chain query builder
PHP Laravel