/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

1 vote144 views1 answer
How validate the value of object in arraye in laravel
PHP Laravel
0 vote145 views1 answer
Fast excel export laravel
PHP Laravel
1 vote158 views1 answer
Laravel nigerian time zone
PHP Laravel
0 vote140 views1 answer
Laravel hiding attributes JSON
PHP Laravel
4 votes136 views2 answers
Laravel carbon get month name español
PHP Laravel
0 vote144 views1 answer
Laravel - Add conditional where clause in query
PHP Laravel
0 vote137 views1 answer
Laravel migrate error default character 199 boot
PHP Laravel
1 vote155 views1 answer
Increment single column laravel
PHP Laravel
-1 vote146 views4 answers
How to include file in laravel blade
PHP Laravel
0 vote171 views1 answer
Laravel get file to browser send
PHP Laravel