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

0 vote257 views1 answer
Cloudinary laravel
PHP Laravel
3 votes306 views2 answers
Laravel request integer
PHP Laravel
0 vote268 views1 answer
->store() laravel change name
PHP Laravel
2 votes308 views3 answers
Laravel web php request to redirect to another page
PHP Laravel
4 votes294 views3 answers
Laravel return json header json
PHP Laravel
0 vote267 views1 answer
Call to a member function setcookie() on null laravel middleware
PHP Laravel
6 votes294 views4 answers
Laravel set config
PHP Laravel
0 vote288 views1 answer
Laravel fetch max value
PHP Laravel
2 votes272 views1 answer
Laravel validate integer between
PHP Laravel
48 votes346 views6 answers
Laravel joins
PHP Laravel