PHP mapping and splitting multi-dimensional arrays

Question

I am working on 2 multi-dimensional arrays:

$array1 = array(
    0 => array(
        'items' => array(
            1 => array('79-' => 'abc','80-'=>'123'),
            2 => array('79-' => 'Mapping item1','80-'=>'123'),
            3 => array('79-' => 'abc','80-'=>'123')
        )
    ),
    1 => array(
        'items' => array(
            1 => array('79-' => 'Mapping item2','80-'=>'123'),
        )
    )
);

This is the second array:

$array2 = array(
    2 => array(
        "A" => 'Mapping item1',
        "B" => array(1 => 'product1', 2 => 'product2', 3 => 'product3')
    ),
    3 => array(
        "A" => 'Mapping item2',
        "B" => array(1 => 'product4', 2 => 'product5', 3 => 'product6')
    )
);

I am trying to map the 2 arrays by the key value 79-, and make changes to the array1. Here is my code.

foreach ($array1 as $key => $orders) {
    $items = $orders['items'];
    $itemIndex = 1;
    foreach ($items as $k => $item) {
        foreach ($array2 as $row) {
            if (strpos($item['79-'], $row['A']) !== false) {
                foreach ($row['B'] as $ite) {
                    items[ $itemIndex ]['79-'] = $ite;
                    $itemIndex++;
                }
            }
        }
        $itemIndex++;
    }

    $orders['items'] = $items;
    $array1[ $key ] = $orders;
}

I want to return an array as below but my code doesn't work.

$expectedArray = array(
    [0]=> array(
       ['items'] => array(
          [1]=>array('79-'=>'abc','80-'=>'123'),
          [2]=>array('79-'=>'product1','80-'=>'123'),
          [3]=>array('79-'=>'product2','80-'=>'123'),
          [4]=>array('79-'=>'product3','80-'=>'123'),
          [5]=>array('79-'=>'abc','80-'=>'123')
       )
    ),
    [1]=>array(
       ['items'] => array(
          [1]=>array('79-'=>'product4','80-'=>'123'),
          [2]=>array('79-'=>'product5','80-'=>'123'),
          [3]=>array('79-'=>'product6','80-'=>'123'),          
       )
    )
);

Anyone knows how to solve this problem, please help. I've been working on this for hours.

change [A] to ["A"].. idem B / items[ $itemIndex ]['79-'] to $items / 'product6 to 'product6' — Maxi Schvindt
– Maxi Schvindt, Commented Sep 19, 2017 at 3:08
I just edited the typing mistakes, but it is not the solution. — Tedxxxx
– Tedxxxx, Commented Sep 19, 2017 at 3:17
Can you post a expected result? I'm having problems understanding what needs to be done. — Andreas
– Andreas, Commented Sep 19, 2017 at 3:29

Sahil Gulati · Accepted Answer · 2017-09-19 05:23:17Z

1

Hope this one will be helpful. Here we are using foreach, array_column and array_map

Try this code snippet here

$column=array_column($array2,"B","A");
foreach ($array1 as $key => $itemsArray)
{
    $finalArray=array();//maintaining a final array
    foreach($itemsArray["items"] as $itemKey => $item)
    {
        if(isset($column[$item["79-"]]))//checking key in the column array
        {
            $result=array_map(function($value) use($item){
               unset($item["79-"]);
               return array("79-"=>$value)+$item;
            },$column[$item["79-"]]);
            $finalArray=$finalArray+$result;//appending array with + operator
        }
        else
        {
            $finalArray[]=$item;
        }
    }
    $array1[$key]["items"]=$finalArray;//overwriting final array to existing one
}
print_r($array1);

edited Sep 19, 2017 at 5:23

answered Sep 19, 2017 at 3:46

Sahil Gulati

15.2k4 gold badges28 silver badges43 bronze badges

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

6 Comments

Tedxxxx Over a year ago

As I checked, the $finalArray does not contain the value of $result?

Sahil Gulati Over a year ago

@Tedxxxx Yes it contains, Can you check your expected output and my snippet?

Tedxxxx Over a year ago

Yes I checked, the final result doesn't contrain value in the $result array such as 'product1', 'product2', etc. It doesn't replace the old data.

Tedxxxx Over a year ago

Oh your code returns the correct result, but I am sorry that I had a mistake in the input array. Besides '-79', I also have another element '80-', but with your snip code, It only returns '-79'. I will accept your answer due to my mistake. But could you help me with the above one.

Tedxxxx Over a year ago

right now, the output result is like this: eval.in/863954. But I want to keep the value '80-' in all new element that has been added.

|

Collectives™ on Stack Overflow

PHP mapping and splitting multi-dimensional arrays

1 Answer 1

6 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Related