Laravel count 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 vote117 views1 answer
Check if delete query was successful laravel
PHP Laravel
0 vote129 views1 answer
Pusher in laravel array_merge(): Argument #2 is not an array
PHP Laravel
0 vote126 views1 answer
Rule for radio button in laravel
PHP Laravel
0 vote135 views1 answer
How to remove updated_at or use only created_at laravel eloquent ORM
PHP Laravel
1 vote110 views1 answer
Laravel command parameter optional
PHP Laravel
0 vote120 views1 answer
Laravel post request page csrf disable
PHP Laravel
1 vote110 views1 answer
Paystack gateway integration laravel
PHP Laravel
0 vote110 views2 answers
Laravel join query sum example
PHP Laravel
9 votes116 views3 answers
Laravel download
PHP Laravel
1 vote119 views1 answer
Get age with carbon in laravel
PHP Laravel