phparraysmultidimensional-arrayassociative-arraymerging-data

Merge the leaf nodes of two associative 2d arrays with identical structures


I am trying to use array_combine() to combine two multidimensional arrays, but somehow not doing it correctly.

Here is array1:

Array(
    [Nov 18, 2011] => Array(
        [C] => 107705.5792
        [I] => 44561.52
    )
    [Nov 22, 2011] => Array(
        [C] => -8992.8352
    )
)

and here is array2:

Array(
    [Nov 18, 2011] => Array(
        [C] => 3
        [I] => 1
    )
    [Nov 22, 2011] => Array(
        [C] => 2
    )
)

Here is my attempt at array_combine, which is not working:

$array1 = ($arr1);
$array2 = ($arr2);
$result = array_combine($arr1, $arr2);
echo '<pre>';
    print_r($result);
echo '</pre>';

What am I doing wrong? This is the result that I am looking for:

Array(
    [Nov 18, 2011] => Array(
        [3] => 107705.5792
        [1] => 44561.52
    )
    [Nov 22, 2011] => Array(
        [2] => -8992.8352
    )
)

I have found that if I instead use array_merge_recursive(), this is my the result that I get. Not what I was looking for, but close:

Array(
    [Nov 18, 2011] => Array(
        [C] => Array(
            [0] => 3
            [1] => 107705.5792
        )
        [I] => Array(
            [0] => 1
            [1] => 44561.52
        )
    )
    [Nov 22, 2011] => Array(
        [C] => Array(
            [0] => 2
            [1] => -8992.8352
        )
    )
)

Here is the way that I have tried to implement one of the suggestions below, however this is not working for me. What is wrong?:

function cust_array_merge(array &$array1, array $array2) {
    // loop through main array
    foreach ($array1 as $key => $val) {
        // check if $array2 has the same index
        if (array_key_exists($key, $array2)) {
            // reset $array1's indexes to $array2's values
            foreach ($array2[$key] as $subKey => $subVal) {
                if (array_key_exists($subKey, $array1[$key])) {
                    $tempVal = $array1[$key][$subKey];
                    unset($array1[$key][$subKey]);
                    $array1[$key][$subVal] = $tempVal;
                }
            }
        }
    }
}

$merged = cust_array_merge($arr_cats_per_bill_date, $arr_cvat);
echo '<pre>';
    print_r($merged);
echo '</pre>';

Solution

  • array_merge_recursive gets you very close (your "key" is in index 1 of leaf arrays, and your value is in index 0). So do it in two steps: first get the merged array, then fiddle with the branches to get it right.

    // This is a callback for array_map() which should have some more generic uses.
    // array(array('k', 'v'), ...) -> array('k' => 'v', ...)
    function flatten_branches($branches) {
        $newleaves = array();
        foreach ($branches as $leaf) {
            $newleaves[$leaf[0]] = $leaf[1];
        }
        return $newleaves;
    }
    
    function merge_flatten_branches($karray, $varray) {
        //$karray has the key-leaves, and $varray has the value-leaves
        $m1 = array_merge_recursive($karray, $varray);
        return array_map('flatten_branches', $m1);
    }
    
    $merged = merge_flatten_branches($array2, $array1);
    print_r($merged);
    

    Just for fun, here are two more approaches. Both of these are a bit slower than merge_flatten_branches, but illustrate some useful array concepts. (In other more functional-flavored languages than php, these might be preferred.)

    function merge_flatten_branches_reduce($karray, $varray) {
        //$karray has the key-leaves, and $varray has the value-leaves
        $m1 = array_merge_recursive($karray, $varray);
        return array_map('flatten_branches_reduce', $m1);
    }
    
    function merge_flatten_branches_add($karray, $varray) {
        //$karray has the key-leaves, and $varray has the value-leaves
        $m1 = array_merge_recursive($karray, $varray);
        return array_map('flatten_branches_add', $m1);
    }
    
    // The functions below are callbacks for the two above.
    
    function array_add($a1, $a2) {
        return $a1+$a2;
    }
    
    function flatten_leaf($leaf) {
        return array($leaf[0] => $leaf[1]);
    }
    
    function flatten_branches_add($branches) {
        $leaves = array_map('flatten_leaf', ($branches));
        $finalleaves = array();
        foreach ($leaves as $leaf) {
            $finalleaves += $leaf;
        }
        return $finalleaves;
    }
    
    
    function flatten_branches_reduce($branches) {
        $l = array_map('flatten_leaf', ($branches));
        return array_reduce($l, 'array_add', array());
    }