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

0 vote195 views1 answer
Laravel weekly data
PHP Laravel
12 votes192 views3 answers
Displaying errors in laravel
PHP Laravel
0 vote223 views1 answer
Db connection postgres laravel
PHP Laravel
0 vote161 views1 answer
Laravel allow null records relationship
PHP Laravel
5 votes164 views5 answers
Laravel file permissions
PHP Laravel
0 vote153 views1 answer
Laravel permission create role
PHP Laravel
4 votes156 views4 answers
Laravel 8 carbon if date is today
PHP Laravel
1 vote155 views1 answer
How to create controler in laravel
PHP Laravel
2 votes160 views3 answers
Laravel model particular column
PHP Laravel
1 vote176 views2 answers
How console log laravel
PHP Laravel