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

44 votes182 views4 answers
Laravel random string
PHP Laravel
33 votes210 views6 answers
Laravel carbon
PHP Laravel
1 vote198 views1 answer
Get user with role laravel
PHP Laravel
0 vote199 views1 answer
How to update a table based on three columns laravel
PHP Laravel
0 vote226 views2 answers
Laravel collection search
PHP Laravel
15 votes201 views3 answers
Laravel timezone
PHP Laravel
0 vote183 views4 answers
Laravel collection contains
PHP Laravel
0 vote190 views1 answer
Laravel flutter save image in data
PHP Laravel
10 votes177 views6 answers
Laravel Pagination
PHP Laravel
0 vote189 views2 answers
Laravel livewire-datatable delete column pop up issue
PHP Laravel