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

2 votes147 views1 answer
Attach multiple files in laravel mailable
PHP Laravel
0 vote161 views1 answer
Laravel model uploaded file name
PHP Laravel
5 votes159 views1 answer
Eloquent chunk laravel model chunk
PHP Laravel
2 votes146 views2 answers
Laravel get column field name
PHP Laravel
1 vote164 views1 answer
Copy env example to .env in laravel
PHP Laravel
0 vote214 views1 answer
Laravel httaccess for apache
PHP Laravel
0 vote155 views1 answer
Laravel collection all
PHP Laravel
4 votes200 views1 answer
Laravel before migration
PHP Laravel
2 votes148 views3 answers
Laravel public static variable
PHP Laravel
1 vote165 views1 answer
Laravel eloquent get 10 records
PHP Laravel