Mapping array to new array

Question

I have an array which has an array within it, and I want to create a new array for each of the array values of 'power'. What is the best way to do this?

Original array:

Array
(
    [0] => Array
        (
            [date] => 2019-09-16 15:16:03
            [stid] => 64
            [beam] => 1
            [power] => {1,3,7,8,9}
            [gates] => 5
)

   [1] => Array
        (
            [date] => 2019-09-16 15:17:03
            [stid] => 64
            [beam] => 1
            [power] => {14,15,16}
            [gates] => 3
)
)

Edit: Output array should increment gate started from 1

Array
(
    [0] => Array
        (
            [date] => 2019-09-16 15:16:03
            [gate] => 1
            [power] => 1
        )

   [1] => Array
        (
            [date] => 2019-09-16 15:16:03
            [gate] => 2
            [power] => 3
         )

   [2] => Array
        (
            [date] => 2019-09-16 15:16:03
            [gate] => 3
            [power] => 7
         )

   [3] => Array
        (
            [date] => 2019-09-16 15:16:03
            [gate] => 4
            [power] => 8
         )


   [4] => Array
        (
            [date] => 2019-09-16 15:16:03
            [gate] => 5
            [power] => 9
         )

   [5] => Array
        (
            [date] => 2019-09-16 15:17:03
            [gate] => 1
            [power] => 14
         )

   [6] => Array
        (
            [date] => 2019-09-16 15:17:03
            [gate] => 2
            [power] => 15
         )

   [7] => Array
        (
            [date] => 2019-09-16 15:17:03
            [gate] => 3
            [power] => 16
         )
)

Continued for all 8 (5 and 3) power values, such that the resultant array is an array of 8 arrays.

dazed-and-confused · Accepted Answer · 2019-09-18 16:07:42Z

1

# Original Data Structure
$arr = 
[
    [
        'date' => '2019-09-16 15:16:03',
        'stid' => 64,
        'beam' => 1,
        'power' => '{1,3,7,8,9}',
        'gates' => 5
    ],
    [
        'date' => '2019-09-16 15:17:03',
        'stid' => 64,
        'beam' => 1,
        'power' => '{14,15,16}',
        'gates' => 3
    ]
];

$output = [];
foreach ($arr as $a)
{
    $gateCount = 0;
    foreach (explode(',', trim($a['power'], '{}')) as $p) 
    {
        $output[] = [
            'date' => $a['date'],
            'gate' => $gateCount++ % $a['gates'] + 1,
            'power' => $p
        ];
    }
}
print_r($output);

Output:

Array
(
    [0] => Array
        (
            [date] => 2019-09-16 15:16:03
            [gate] => 1
            [power] => 1
        )

    [1] => Array
        (
            [date] => 2019-09-16 15:16:03
            [gate] => 2
            [power] => 3
        )

    [2] => Array
        (
            [date] => 2019-09-16 15:16:03
            [gate] => 3
            [power] => 7
        )

    [3] => Array
        (
            [date] => 2019-09-16 15:16:03
            [gate] => 4
            [power] => 8
        )

    [4] => Array
        (
            [date] => 2019-09-16 15:16:03
            [gate] => 5
            [power] => 9
        )

    [5] => Array
        (
            [date] => 2019-09-16 15:17:03
            [gate] => 1
            [power] => 14
        )

    [6] => Array
        (
            [date] => 2019-09-16 15:17:03
            [gate] => 2
            [power] => 15
        )

    [7] => Array
        (
            [date] => 2019-09-16 15:17:03
            [gate] => 3
            [power] => 16
        )

)

Note:

['beam'] and ['stid'] have been left off as per your sample. Can easily be added if you need them.

edited Sep 18, 2019 at 16:07

answered Sep 17, 2019 at 20:20

dazed-and-confused

1,3332 gold badges12 silver badges21 bronze badges

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

16 Comments

dazed-and-confused Over a year ago

This is true. In my sample recreation of the data structure, I simply made it an array,

dazed-and-confused Over a year ago

I modified my answer to have the structure use the {x,y} format and the foreach accordingly.

mcook16 Over a year ago

Also, gate should equal 0,1,2,3,4,5,0,1,2 in this example. How would I make that addition?

Progrock Over a year ago

@mcook16, edit your original question to specify how the gate index should be populated.

dazed-and-confused Over a year ago

@mcook16 How do you want your 'gate' defined?

|

failedCoder · Accepted Answer · 2019-09-17 20:11:17Z

0

You can do this:

$newArray = [];
foreach ($oldArray as $element) {
   foreach ($element['power'] as $power) {
      $element['power'] = $power;
      $newArray[] = $element;
   }
}

answered Sep 17, 2019 at 20:11

failedCoder

1,4241 gold badge18 silver badges40 bronze badges

Collectives™ on Stack Overflow

Mapping array to new array

2 Answers 2

16 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

16 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related