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

2 votes355 views2 answers
How get query from url in laravel
PHP Laravel
0 vote268 views1 answer
Laravel 2 queries similar reuse code
PHP Laravel
0 vote300 views1 answer
Laravel model where set fields laravel
PHP Laravel
0 vote346 views3 answers
Laravel tinker factory
PHP Laravel
0 vote389 views1 answer
Laravel A row must be an array or a TableSeparator instance.
PHP Laravel
0 vote333 views1 answer
Laravel automatically generate unique username
PHP Laravel
8 votes342 views1 answer
Laravel command to create symlink storage
PHP Laravel
0 vote354 views1 answer
Laravel latest from relationship
PHP Laravel
0 vote349 views1 answer
Access-control-allow-origin php laravel
PHP Laravel
2 votes358 views1 answer
Migrations required field laravel
PHP Laravel