/PHP/Laravel/Get all users created in a month laravel

Get all users created in a month laravel

$users = User::select('id', 'created_at')
->get()
->groupBy(function($date) {
    //return Carbon::parse($date->created_at)->format('Y'); // grouping by years
    return Carbon::parse($date->created_at)->format('m'); // grouping by months
});

$usermcount = [];
$userArr = [];

foreach ($users as $key => $value) {
    $usermcount[(int)$key] = count($value);
}

for($i = 1; $i <= 12; $i++){
    if(!empty($usermcount[$i])){
        $userArr[$i] = $usermcount[$i];    
    }else{
        $userArr[$i] = 0;    
    }
}

Source: stackoverflow.com

Similar codes

0 vote225 views1 answer
How to put external file in laravel listener class
PHP Laravel
1 vote241 views1 answer
Parametre grouping laravel quert
PHP Laravel
7 votes255 views1 answer
Laravel db seed specific class
PHP Laravel
31 votes194 views6 answers
Update or create laravel
PHP Laravel
29 votes211 views6 answers
Where like laravel
PHP Laravel
0 vote233 views1 answer
Laravel imap - Get message attachments
PHP Laravel
0 vote207 views1 answer
Migrate only one table laravel
PHP Laravel
0 vote229 views2 answers
Reload page laravel
PHP Laravel
0 vote223 views1 answer
How to share count of things to sidebar in laravel
PHP Laravel
0 vote244 views1 answer
Comparison of two tables in laravel using model
PHP Laravel