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

1 vote248 views1 answer
Laravel pagination publish command
PHP Laravel
2 votes181 views1 answer
Laravel abort
PHP Laravel
1 vote169 views1 answer
Check which database connect laravel
PHP Laravel
19 votes177 views6 answers
Laravel query builder join
PHP Laravel
10 votes172 views2 answers
Laravel list routes
PHP Laravel
0 vote227 views1 answer
Dummy data in laravel
PHP Laravel
2 votes207 views2 answers
In PackageManifest.php line 131: Undefined index: name laravel 7
PHP Laravel
0 vote208 views1 answer
Laravel api cors localhost issue
PHP Laravel
15 votes172 views3 answers
Pass data to blade laravel
PHP Laravel
0 vote163 views2 answers
Laravel 8 query builder, Left Join / Right Join Clause
PHP Laravel