/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

0 vote126 views1 answer
Insert value in session in laravel
PHP Laravel
0 vote109 views2 answers
Foreach limit laravel
PHP Laravel
18 votes121 views4 answers
Laravel create model controller and migration on line
PHP Laravel
12 votes114 views6 answers
Laravel validation
PHP Laravel
18 votes112 views6 answers
Wherein laravel
PHP Laravel
5 votes132 views3 answers
Laravel validation time hours minutes format
PHP Laravel
0 vote147 views1 answer
How to check current URL inside @if statement in Laravel
PHP Laravel
0 vote135 views1 answer
Laravel list all tbales
PHP Laravel
7 votes491 views3 answers
Laravel active menu item
PHP Laravel
0 vote106 views1 answer
Case inside laravel query
PHP Laravel