How to Effectively Merge Associative Arrays and Handle Missing Columns in PHP?-PHP Tutorial-php.cn

How to Effectively Merge Associative Arrays and Handle Missing Columns in PHP?

Linda Hamilton

Release： 2024-10-20 21:42:02

Original

579 people have browsed it

How to Effectively Merge Associative Arrays and Handle Missing Columns in PHP?

Merging Associative Arrays and Completing Missing Columns with Default Values

Consider the following code:

<code class="php">$a = ['a' => 'some value', 'b' => 'some value', 'c' => 'some value'];
$b = ['a' => 'another value', 'd' => 'another value', 'e' => 'another value', 'f' => 'another value'];
$c = ['b' => 'some more value', 'x' => 'some more value', 'y' => 'some more value', 'z' => 'some more value'];

$d = [$a, $b, $c];</code>

Copy after login

When you use var_export($d), you get the following output:

<code class="php">array (
  0 =>
  array (
    'a' => 'some value',
    'b' => 'some value',
    'c' => 'some value',
  ),
  1 =>
  array (
    'a' => 'another value',
    'd' => 'another value',
    'e' => 'another value',
    'f' => 'another value',
  ),
  2 =>
  array (
    'b' => 'some more value',
    'x' => 'some more value',
    'y' => 'some more value',
    'z' => 'some more value',
  ),
)</code>

Copy after login

Merge Array Keys with Default Values

To combine the array keys and fill in missing columns with a default value, you can use array_merge:

<code class="php">$keys = array();
foreach (new RecursiveIteratorIterator(new RecursiveArrayIterator($d)) as $key => $val) {
    $keys[$key] = '';
}

$data = array();
foreach ($d as $values) {
    $data[] = array_merge($keys, $values);
}

echo '<pre class="brush:php;toolbar:false">';
print_r($data);</code>

Copy after login

Result:

<code class="php">Array
(
    [0] => Array
        (
            [a] => some value
            [b] => some value
            [c] => some value
            [d] =>
            [e] =>
            [f] =>
            [x] =>
            [y] =>
            [z] =>
        )

    [1] => Array
        (
            [a] => another value
            [b] =>
            [c] =>
            [d] => another value
            [e] => another value
            [f] => another value
            [x] =>
            [y] =>
            [z] =>
        )

    [2] => Array
        (
            [a] =>
            [b] => some more value
            [c] =>
            [d] =>
            [e] =>
            [f] =>
            [x] => some more value
            [y] => some more value
            [z] => some more value
        )
)</code>

Copy after login

Another Approach

Alternatively, you can create key-pair values and then merge them:

<code class="php">$keys = array_keys(call_user_func_array('array_merge', $d));
$key_pair = array_combine($keys, array_fill(0, count($keys), null));
$values = array_map(function($e) use ($key_pair) {
    return array_merge($key_pair, $e);
}, $d);</code>

Copy after login

The above is the detailed content of How to Effectively Merge Associative Arrays and Handle Missing Columns in PHP?. For more information, please follow other related articles on the PHP Chinese website!