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

3 votes114 views1 answer
Php proper function comments
PHP
0 vote136 views4 answers
Join table laravel count
PHP
0 vote97 views1 answer
How convert the string to int in laravel function event
PHP Laravel
0 vote126 views1 answer
Get value from stdclass object
PHP
2 votes126 views1 answer
Yii2 migration add column
PHP
113 votes307 views6 answers
Date time in php
PHP
0 vote125 views1 answer
Show widget using the shortcode from php
PHP
0 vote127 views1 answer
Fgets in php
PHP
0 vote136 views1 answer
Php check if checkbox isset
PHP
0 vote145 views1 answer
Wordpress wp_query orderby random
PHP Wordpress