/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 votes141 views4 answers
Laravel has many
PHP Laravel
0 vote130 views1 answer
$this- attribute laravel
PHP Laravel
1 vote137 views1 answer
Laravel create on model
PHP Laravel
1 vote155 views1 answer
Laravel log path
PHP Laravel
0 vote133 views1 answer
Withsuccess laravel 8
PHP Laravel
0 vote139 views2 answers
Laravel allow all fillable
PHP Laravel
2 votes147 views5 answers
Laravel drop table migration
PHP Laravel
1 vote148 views1 answer
How to add an custom error to validater error in laravel
PHP Laravel
1 vote127 views1 answer
Laravel doesNotHave in model
PHP Laravel
3 votes233 views2 answers
Laravel eloquent get one column value
PHP Laravel