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

20 votes290 views4 answers
Laravel where is null
PHP Laravel
5 votes312 views3 answers
Laravel if request has
PHP Laravel
0 vote273 views1 answer
Laravel 8 redirect to previous page
PHP Laravel
7 votes284 views3 answers
Laravel where has
PHP Laravel
0 vote293 views4 answers
Laravel old value for select option
PHP Laravel
5 votes294 views2 answers
How to clear session in laravel
PHP Laravel
1 vote306 views2 answers
How to pass parameter in routes of laravel
PHP Laravel
0 vote309 views1 answer
Laravel eloquent save method return value
PHP Laravel
1 vote273 views2 answers
Laravel select columns
PHP Laravel
12 votes263 views4 answers
Laravel call controller method from another controller
PHP Laravel