PHP merge arrays by value for 2 different array value

Question

I have tried to merge two different arrays into a single array. Can any one help me please?

i have array like this

[0] (Array)#2
  [rank] "579"
  [id] "1"
[1] (Array)#4
  [rank] "251"
  [id] "2"

[0] (Array)#2
  [size] "S"
  [rank] "251"
[1] (Array)#15
  [size] "L"
  [rank] "579"

i need like this

[0] (Array)#2
  [size] "S"
  [rank] "251"
  [id] "1"
[1] (Array)#15
  [size] "L"
  [rank] "579"
  [id] "1"

Agree with @RoboRobok, if you explain the problem a bit wider there might be a better approach to prevent you to get to this point in first place :) — Ali
– Ali, Commented Jul 2, 2015 at 9:29

glend · Accepted Answer · 2015-07-02 10:23:22Z

4

Untested, but this should work, or at least get you close.

for ($array1 as $key1 => $value1) {
    for ($array2 as $key2 => $value2) {
        if ($value1['rank'] == $value2['rank']) {
            $result[$key1] = [$value2['size'], $value1['rank'], $value1['id']];
        };
    };
};

edited Jul 2, 2015 at 10:23

answered Jul 2, 2015 at 7:26

glend

1,6222 gold badges21 silver badges40 bronze badges

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

2 Comments

Ali Over a year ago

This will change one of the arrays ($array1). you have to make sure that's accepted based on your criteria. usually a merge process should leave both original roots intact and create a new (third) entity as the result

glend Over a year ago

Fixed, we/i could make it figure out the keys it needs to copy. Don't see any reason to add that as of yet.

Ali · Accepted Answer · 2015-07-02 10:22:16Z

1

foreach($arr1 as $key1 => $data1){
    foreach($arr2 as $key2 => $data2){
        if($data1['rank']==$data2['rank']){
            $result[] = array_merge($data1, $data2);
        }
    }
}
print_r($result);

edited Jul 2, 2015 at 10:22

Ali

3,0814 gold badges23 silver badges43 bronze badges

answered Jul 2, 2015 at 7:36

Ambal Mani

3151 gold badge5 silver badges16 bronze badges

3 Comments

Ali Over a year ago

a proper merge solution but you are assuming the rank key is always present and unique in both arrays (which is fine as far as thats the case :) )

Ambal Mani Over a year ago

if you have any unique key mens you used that one otherwise you don't need to check if condion and seconf for loop. :)

Ali Over a year ago

Agreed, as far our assumption around the rank is valid ;)

splash58 · Accepted Answer · 2015-07-02 08:17:06Z

0

//save keys of ranks in the 1st array
$keys = array(); 
foreach($arr1 as $k => $v)
   $keys[$v['rank']] = $k;

$res = array();
// Walk through the 2nd array and make result
foreach($arr2 as $k => $v) 
 if (isset($keys[$v['rank']])) 
    $res[] = array_merge($arr1[$keys[$v['rank']]], $v);

print_r($res);

edited Jul 2, 2015 at 8:17

answered Jul 2, 2015 at 7:40

splash58

26.2k3 gold badges25 silver badges35 bronze badges

Comments

Ali · Accepted Answer · 2015-07-02 09:01:01Z

Looking at your provided arrays, I'm assuming you want to use the key rank as the joining point (which doesn't seems such a good idea, and question will be if their unique or not) if they are unique then a tiny method can help to fetch element based on their rank and the rest is just assembling the result :

<?php

$arr1 = [
    [
        'rank' => 579,
        'id' => 1
    ],
    [
        'rank' => 251,
        'id' => 2
    ],
];

$arr2 = [
    [
        'size' => 'S',
        'rank' => 251
    ],
    [
        'size' => 'L',
        'rank' => 579
    ],
];

function getItemByRank($array, $rank)
{
    foreach ($array as $item){
        if ($item['rank'] === $rank) {
            return $item;
        }
    }
}


$result = [];
foreach ($arr1 as $k => $item) {

    $match = getItemByRank($arr2, $item['rank']);

    if (isset($match)) {
        $result[$k] = $item;
        $result[$k]['size'] = $match['size'];
    }
}

print_r($result);

output:

Array
(
    [0] => Array
        (
            [rank] => 579
            [id] => 1
            [size] => L
        )

    [1] => Array
        (
            [rank] => 251
            [id] => 2
            [size] => S
        )

)

jbe · Accepted Answer · 2015-07-02 10:22:02Z

0

While I do not understand why you want to merge the arrays this way, here's a way to merge the arrays by their sequences. so the first child of array1 will be merged with the first child of array2 etc.

<?php

$array1 = [
    [
        'rank' => 579,
        'id' => 1
    ],
    [
        'rank' => 251,
        'id' => 2
    ]
];

$array2 = [
    [
        'size' => 'S',
        'rank' => 251
    ],
    [
        'size' => 'L',
        'rank' => 579
    ]
];


foreach ($array1 as $key => &$data) {
    if (isset($array2[$key])) {
        $data = array_merge($data, $array2[$key]);    
    }
}

var_dump($array1);

edited Jul 2, 2015 at 10:22

answered Jul 2, 2015 at 7:24

jbe

1,8121 gold badge13 silver badges20 bronze badges

2 Comments

Sougata Bose Over a year ago

What if the sequences are not same?

Ali Over a year ago

if what most of answers assumed is the case and @user3686600 want to use the rank as a joining point the this solution will be incorrect

Collectives™ on Stack Overflow

PHP merge arrays by value for 2 different array value

5 Answers 5

2 Comments

3 Comments

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

3 Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related