/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 vote303 views1 answer
Json whereIn laravel
PHP Laravel
50 votes414 views6 answers
Add column in laravel migration
PHP Laravel
0 vote340 views1 answer
Get data from model in chunks laravel
PHP Laravel
0 vote295 views2 answers
Laravel same route different group
PHP Laravel
11 votes321 views2 answers
How login one user with id in laravel
PHP Laravel
12 votes318 views5 answers
Laravel transactions
PHP Laravel
2 votes294 views1 answer
Delete confirmation destroy laravel
PHP Laravel
15 votes326 views6 answers
Install laravel
PHP Laravel
0 vote307 views2 answers
Laravel 8 query builder, Left Join / Right Join Clause
PHP Laravel
2 votes305 views1 answer
Laravel force login by id
PHP Laravel