How to combine 2 arrays based on same value of same key

Question

I want to merge/combine 2 arrays based on the same key/value pair.

To be more clear, what I'm searching for is kind of a join function known in MySQL. The first array should be "joined" by the second one, based on the ID, which is the key/value pair 'name'.

How can I do this?

1. ARRAY

 [0] => Array
        (
            [name] => first
            [logo] => url
            [cat] => abc
        )
[1] => Array
        (
            [name] => second
            [logo] => url
            [cat] => abc
        )

2. ARRAY

 [0] => Array
        (
            [name] => first
            [menu] => true
            [key] => value
        )

NEW ARRAY (Expexted Result):

[0] => Array
       (
           [name] => first
           [logo] => url
           [cat] => abc
           [menu] => true
           [key] => value
       )

As you an see, it's quite self-explaining. In this case, the 'name' key is like an ID (for both arrays).

to be more clear: what i'm searching for is kind of a join function known in MySQL..the first array should be "joined" by the second one, based on the ID, which is the key/value pair 'name' — Dave18
– Dave18, Commented Mar 15, 2018 at 19:29

Don't Panic · Accepted Answer · 2018-03-15 19:40:04Z

1

If you reindex your second array by name first, it will be easier to get those values from it.

$second = array_column($second, null, 'name');

(It's okay to do this if 'name' is unique in the array. I assume that's the case since you said it's "like an ID". If 'name' isn't unique then you'll lose some rows when you reindex, because array keys have to be unique.)

Then iterate your first array and merge any corresponding values in the second array into the result.

foreach ($first as $key => $value) {
    if (isset($second[$value['name']])) {
        $result[$key] = array_merge($value, $second[$value['name']]);
    }
}

This would be like an inner join in SQL, where the result would only include rows where the value exists in both tables. If you wanted it to work more like a left join, then you'd need to merge a set of empty values for the keys in the second array if a matching name value wasn't found there.

foreach ($first as $key => $value) {
    if (isset($second[$value['name']])) {
        $result[$key] = array_merge($value, $second[$value['name']]);
    } else {
        $result[$key] = array_merge($value, ['menu' => null, 'key' => null]);
    }
}

Working example at 3v4l.org.

edited Mar 15, 2018 at 19:40

answered Mar 15, 2018 at 19:18

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

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

2 Comments

Dave18 Over a year ago

thanks, but some values get lost, like 'logo', also, "It looks like you wanted the result to only contain names that existed in both arrays"...no, thats not what i want. Basicly, the first array is important, the second should only add additional key/values.

Don't Panic Over a year ago

@Dave18 updated the answer. I added a link to a executable example. Just let me know if I'm still not understanding it properly.

masatar · Accepted Answer · 2018-03-15 20:01:26Z

0

Try this

$mergedArray = array_merge_recursive ($firstArray,$secondArray);

$newArray = [];
foreach( $mergedArray as $subArr ) {
    $newArray = array_merge($subArr,$newArray);
}

edited Mar 15, 2018 at 20:01

answered Mar 15, 2018 at 19:51

masatar

886 bronze badges

Collectives™ on Stack Overflow

How to combine 2 arrays based on same value of same key

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related