/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

6 votes224 views6 answers
Laravel collection pluck
PHP Laravel
7 votes235 views5 answers
Laravel remove public from url
PHP Laravel
0 vote207 views1 answer
Send image in request body laravel 6
PHP Laravel
5 votes221 views1 answer
Laravel model method like foreach parts of
PHP Laravel
0 vote220 views1 answer
Laravel select option form add please select option
PHP Laravel
3 votes280 views1 answer
Laravel check if array is empty
PHP Laravel
9 votes236 views3 answers
Laravel database seeder medium
PHP Laravel
3 votes344 views2 answers
Two condition in one laravel query
PHP Laravel
-1 vote242 views2 answers
Laravel pagination keep query string
PHP Laravel
0 vote325 views1 answer
Db connection postgres laravel
PHP Laravel