/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 vote160 views2 answers
Laravel get path to storage folder
PHP Laravel
0 vote133 views1 answer
Can we use 2 select in a query laravel
PHP Laravel
4 votes121 views2 answers
Laravel carbon get month name español
PHP Laravel
0 vote130 views1 answer
Excel return integer from date column laravel
PHP Laravel
2 votes88 views1 answer
Laravel slug route
PHP Laravel
0 vote123 views1 answer
Compile custom/plain css with mix in laravel
PHP Laravel
8 votes139 views3 answers
Laravel change column
PHP Laravel
0 vote126 views3 answers
GetClientOriginalExtension laravel
PHP Laravel
7 votes129 views2 answers
Laravel 8 query builder, Inner Join Clause
PHP Laravel
-1 vote146 views2 answers
Laravel eloquent update multiple records
PHP Laravel