/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

1 vote389 views1 answer
Run jobs laravel
PHP Laravel
1 vote405 views1 answer
Laravel start que listener
PHP Laravel
9 votes330 views6 answers
Laravel ui auth
PHP Laravel
0 vote421 views1 answer
What is actullay work model in laravel
PHP Laravel
0 vote375 views1 answer
Copy file from one directory to another Laravel
PHP Laravel
0 vote373 views1 answer
Laravel change string to text
PHP Laravel
3 votes383 views6 answers
Laravel cors
PHP Laravel
0 vote402 views2 answers
Access paginator object attribute in laravel
PHP Laravel
15 votes342 views6 answers
Laravel custom validation message
PHP Laravel
3 votes379 views2 answers
Set image asset path in laravel
PHP Laravel