Replace row data of a 2d array if a row with the same identifying column value is found in another 2d array

Question

I have two arrays

$array_1 = array(
    array('name' => 'Jon', 'user' => 'Apple'),
    array('name' => 'Dave', 'user' => 'Windows')     
);
          
$array_2 = array(
    array('name' => 'Jon', 'user' => ''), 
    array('name' => 'Jonson', 'user' => ''), 
    array('name' => 'Dave', 'user' => '')
);

I need to get this:

$array_result = array(
    array('name' => 'Jon', 'user' => 'Apple'), 
    array('name' => 'Jonson', 'user' => ''), 
    array('name' => 'Dave', 'user' => 'Windows')
);

I have tried array_merge() and have tried to filter arrays array_filter() but can't find solution.

Andreas · Accepted Answer · 2019-04-13 20:27:25Z

2

You can make your arrays associative with array_columns third argument then use array_replace_recursive to get the change you want.
The optionally use array_values to get an indexed array again.

$array_1 = array_column($array_1, Null, "name");
$array_2 = array_column($array_2, Null, "name");


$result = array_values(array_replace_recursive($array_2, $array_1));

var_dump($result);

Output:

array(3) {
  [0]=>
  array(2) {
    ["name"]=>
    string(3) "Jon"
    ["user"]=>
    string(5) "Apple"
  }
  [1]=>
  array(2) {
    ["name"]=>
    string(6) "Jonson"
    ["user"]=>
    string(0) ""
  }
  [2]=>
  array(2) {
    ["name"]=>
    string(4) "Dave"
    ["user"]=>
    string(7) "Windows"
  }
}

https://3v4l.org/EcgFh

answered Apr 13, 2019 at 20:27

Andreas

24k7 gold badges34 silver badges75 bronze badges

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

Comments

mickmackusa · Accepted Answer · 2024-10-17 08:59:06Z

0

Most simply, create an associative lookup array for fast referencing later. Then iterate the second array and conditionally overwrite rows if they are found in the lookup. Demo

$replacement = array_column($array_1, null, 'name');
var_export(
    array_map(
        fn($row) => $replacement[$row['name']] ?? $row,
        $array_2
    )
);

Output:

array (
  0 => 
  array (
    'name' => 'Jon',
    'user' => 'Apple',
  ),
  1 => 
  array (
    'name' => 'Jonson',
    'user' => '',
  ),
  2 => 
  array (
    'name' => 'Dave',
    'user' => 'Windows',
  ),
)

answered Oct 17, 2024 at 8:59

mickmackusa♦

49.3k13 gold badges98 silver badges165 bronze badges

Collectives™ on Stack Overflow

Replace row data of a 2d array if a row with the same identifying column value is found in another 2d array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related