/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 vote211 views1 answer
Check for headers laravel
PHP Laravel
-1 vote224 views2 answers
Laravel model save get id
PHP Laravel
0 vote211 views1 answer
Menyimpan get di laravel
PHP Laravel
1 vote200 views1 answer
Config smp gamil laravel
PHP Laravel
0 vote219 views1 answer
Laravel change string to text
PHP Laravel
2 votes197 views1 answer
Laravel set appends
PHP Laravel
15 votes203 views4 answers
Change existing migration laravel
PHP Laravel
5 votes193 views1 answer
Laravel rate limit
PHP Laravel
4 votes212 views2 answers
Laravel reduce
PHP Laravel
5 votes196 views4 answers
Laravel auth register false
PHP Laravel