Add to array with the same values within loop

Question

I have a array of settings from database and I need to sort them by days. There are day start and day end periods ir each row and each day can have multiple periods so monday can have multiple records in database. results from database I have under $settings variable. This is my loop.

$items = [];
foreach($settings as $setting){
   $items[] = [
     'day' = $setting->day,
     'periods' = [
       'start' => $setting->start,
       'end' => $setting->end
      ]
   ];
}

Current result:

$items = [
  [
  'day' => 1,
  'periods' => [
    'start' => 08:00,
  'end' => 17:00
  ],
 [
  'day' => 2,
  'periods' => [
    'start' => 08:00,
  'end' => 12:00
  ],
 [
  'day' => 2,
  'periods' => [
    'start' => 14:00,
  'end' => 17:00
  ]
  
];

Desired result:

 $items = [
  [
  'day' => 1,
  'periods' => [
    'start' => 08:00,
    'end' => 17:00
   ],
 [
  'day' => 2,
  'periods' => 
    [
      'start' => 08:00,
      'end' => 12:00
    ],
    [
    'start' => 14:00,
    'end' => 17:00
    ]
  
];

José Carlos PHP · Accepted Answer · 2021-12-01 16:07:43Z

1

For me the best way of getting the result you want is using ->day as keys :

    foreach($settings as $setting){
        if (empty($items[$setting->day])) {
            $items[$setting->day] = [
                'day' => $setting->day,
                'periods' => [],
            ];
        }

        $items[$setting->day]['periods'][] = [
            'start' => $setting->start,
            'end' => $setting->end
            ];
    }

So you can test if the array for each day already exist (using key), if not, create it. If there is already something for this day, push a new entry in ->periods.

edited Dec 1, 2021 at 16:07

José Carlos PHP

1,4972 gold badges14 silver badges23 bronze badges

answered Dec 1, 2021 at 15:55

Camille

8891 gold badge9 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add to array with the same values within loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related