/PHP/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

1 vote196 views1 answer
Laravel Unable to migrate or Make Seeds
PHP Laravel
1 vote168 views1 answer
Pdo transaction
PHP
3 votes164 views1 answer
Send multiple mail in laravel
PHP
0 vote175 views1 answer
Donut chart in PHP
PHP
57 votes530 views6 answers
How to create migration in laravel
PHP Laravel
45 votes174 views6 answers
Laravel outer join
PHP
11 votes163 views2 answers
Laravel log level
PHP
2 votes205 views3 answers
PHP executable not found. Install PHP and add it to your PATH or set the php.executablePath setting in linux
PHP
0 vote221 views1 answer
Push key and value in laravel
PHP Laravel
10 votes189 views3 answers
Migrate to an existing table in laravel commad
PHP Laravel