/PHP/Laravel/Laravel count group by date

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 votes224 views3 answers
Format date laravel timestamp view
PHP Laravel
0 vote271 views1 answer
Laravel mail success or failure
PHP Laravel
0 vote239 views1 answer
Laravel in array blade
PHP Laravel
4 votes225 views2 answers
How validate hash string in laravel
PHP Laravel
1 vote202 views1 answer
Trim laravel
PHP Laravel
1 vote225 views2 answers
Get ip address in laravel
PHP Laravel
16 votes227 views5 answers
Laravel one command for model table and controller
PHP Laravel
42 votes222 views5 answers
Laravel create controller command
PHP Laravel
0 vote212 views1 answer
Laravel validatrion check should be null
PHP Laravel
0 vote277 views1 answer
How to calculate age using query builder in laravel?
PHP Laravel