php - Merge/Replace associative rows from one array with the associative rows of another array

Solution:

clean up your num indexed array to kv array

<?php

$base_image_array = array
(
 array("product_image_one" => ""),
 array("product_image_two" => ""),
 array("product_image_three" => ""),
 array("product_image_four" => "")
);

$db_product_images = array
(
 array("product_image_one" => "../wp-content/themes/dosco/images/products_images/355_product_image_one.jpg"),
);

function kv($a){
    $keys = array_map(current, array_map(array_keys, $a));
    $values = array_map(current, array_map(array_values, $a));

    return array_combine($keys, $values);
}

$base_image_array  = kv($base_image_array);
$db_product_images = kv($db_product_images);

$new_array = array_merge($base_image_array, $db_product_images);
print_r($new_array);
Copy code

output

Array
(
    [product_image_one] => ../wp-content/themes/dosco/images/products_images/355_product_image_one.jpg
    [product_image_two] =>
    [product_image_three] =>
    [product_image_four] =>
)
Copy code

Solution:

The problem is that the array keys in both arrays are numeric. If you want one array to overwrite the other you need to get them into a state where the array keys are strings. You could do something like this:

$array_with_four = array(...); // The large array
$new_array_with_four = format_arrays($array_with_four);

$array_with_one = array(...); // The small array
$new_array_with_one = format_arrays($array_with_one);

$merged = array_merge($new_array_with_four, $new_array_with_one); // Your new results

function format_arrays($array) {
    $return_array = array(); // Blank array
    foreach ($array as $child_key => $child_data){
        $return_array[$child_key] = $child_data;
    }
    return $return_array;
}
Copy code

There are probably better ways to loop through this with the php array functions - but this should get the job done!

Solution:

The solution was very similar to the answer by @Matthew R.

/* Base Array */
$base_image_array = array(
    array('product_image_one' => ''),
    array('product_image_two' => ''),
    array('product_image_three' => ''),
    array('product_image_four' => '')
);

/* Populated Array */
$db_product_images = array(
    array("product_image_one" => "../wp-content/themes/dosco/images/products_images/355_product_image_one.jpg")
);

function format_array($array) {
    $return_array = array();
    foreach ($array as $key => $value) {
        foreach ($value as $k => $v) {
            $return_array[$k] = $v;
        }
    }
    return $return_array;
}

$array1 = format_array($base_image_array);
$array2 = format_array($db_product_images);

$final_array = array_merge($array1, $array2);

echo '<pre>';
    print_r($final_array);
echo '</pre>';
Copy code

The resulting output was like so:

Array
(
    [product_image_one] => ../wp-content/themes/dosco/images/products_images/355_product_image_one.jpg
    [product_image_two] => 
    [product_image_three] => 
    [product_image_four] => 
)
Copy code

The final output was actually different to what I originally thought I needed.

Solution:

I recommend directly flattening the result because assuming these subarray keys are unique, there is no benefit to the depth of the data structure. You can unpack the two arrays with... (spread operator) and feed the individualized row data toarray_replace() (orarray_merge()) to achieve the same conceptual result:

Code: (Demo)

var_export(array_replace(...$base_image_array, ...$db_product_images));
Copy code

Output:

array (
  'product_image_one' => '../wp-content/themes/dosco/images/products_images/355_product_image_one.jpg',
  'product_image_two' => '',
  'product_image_three' => '',
  'product_image_four' => '',
)
Copy code

If you desperately need to keep the deep structure, you can recreate the initial depth by mapping every associative element as its own row.

var_export(
    array_map(
        fn($v) => (array) $v,
        array_replace(...$base_image_array, ...$db_product_images)
    )
);
Copy code