Laravel count group 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 votes335 views2 answers
Laravel switch
PHP
1 vote308 views1 answer
Php artisan add row in table
PHP
0 vote384 views1 answer
At C:\Users\Kamyar\web-pages\telebot\vendor\symfony\process\Pipes\WindowsPipes.php:63 laravel error
PHP Symfony
2 votes357 views1 answer
Laravel create search
PHP
0 vote350 views1 answer
Return pdft download and back with msg in laravel
PHP Laravel
1 vote327 views1 answer
Codeigniter where date interval
PHP
2 votes321 views1 answer
Php make array to certain length
PHP
3 votes330 views4 answers
How to hide .php extension using .htaccess
PHP
1 vote355 views1 answer
Laravel websockets onclose
PHP Laravel
0 vote319 views3 answers
Lookup token information in vault
PHP