php insert values from one array into another

Question

I got 2 following arrays:

array(3) {
[0]=>
array(2) {
["id"]=> 5
["moreinfo"]=> 'moreinfo'
}
[1]=>
array(2) {
["id"]=>10,
["moreinfo"]=> 'moreinfo'

}
[2]=>
array(2) {
["id"]=>15
["moreinfo"]=> 'moreinfo'
} ... and so forth

and the second one:

array(3) {
[5] => "Mike"
[10]=> "Bob"
[15]=> "Alice" //here keys are user ids from the first array

I need to merge them in order to add the field name to the first array in order to get the following:

array(3) {
[0]=>
array(3) {
["id"]=> 5,
["name"]=> Mike,
["moreinfo"]=> 'moreinfo'
}
[1]=>
array(3) {
["id"]=>10,
["name"]=> Bob,
["moreinfo"]=> 'moreinfo'

}
[2]=>
array(3) {
["id"]=>15,
["name"]=> Alice,
["moreinfo"]=> 'moreinfo'
}

I tried to use array_merge but it did not produce the desired result. Also I used foreach but it also inserted only 1 name at the end of the array. Any ideas how to fix that? Thank you.

UPD My foreach try:

foreach($arr1 as $k => $v) {
            $arr1['name'] = $arr2[$v['id']];
        }

Show us what you tried with foreach and we can take it from there. — M. Eriksson
– M. Eriksson, Commented Oct 3, 2016 at 13:22

Indrasis Datta · Accepted Answer · 2016-10-03 13:30:01Z

1

Assuming two arrays are $array1 and $array2 respectively, you need to add a new key value pair for 'name' in $array1 along with pre-existing records.

foreach ($array1 as &$arr) {
   /* $arr['id'] stores 5, 10, 15... So, that implies $array2[5] i.e Mike, $array2[10] i.e Bob and so on. */
   $arr['name'] = $array2[$arr['id']]; 
}

edited Oct 3, 2016 at 13:30

answered Oct 3, 2016 at 13:24

Indrasis Datta

8,6182 gold badges18 silver badges32 bronze badges

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

1 Comment

Masha Over a year ago

It updates only one item from the array. Also I tried with & but it did not help

Alok Patel · Accepted Answer · 2016-10-03 13:27:30Z

0

It's very easy, go through each element of the first array and look for the name in second array by ID from first array.

So your code might look something like this,

foreach ($array as $key=>$element) {
   $element['name'] = $array2[$element['id']];
   $array[$key]=$element; //It's necessary to update the element.
}

In above case $array is a first array, and $array2 is the second array having names by id key.

answered Oct 3, 2016 at 13:27

Alok Patel

8,0726 gold badges35 silver badges48 bronze badges

2 Comments

Masha Over a year ago

This worked, but are there any ideas how to insert a 'name' key between 'id' and 'moreinfo' keys? Thank you

Alok Patel Over a year ago

Order doesn't matter in case of the associative array. Don't worry about that so.

Dmitriy Antonenko · Accepted Answer · 2016-10-03 13:26:41Z

0

foreach ($array1 as $key=>$arr) {
    $array1[$key]['name'] = $array2[$arr['id']];
}

answered Oct 3, 2016 at 13:26

Dmitriy Antonenko

2011 silver badge8 bronze badges

Comments

miglio · Accepted Answer · 2016-10-03 14:05:53Z

0

maybe this help you:

$arr1 = array(
  array("id"=>5,"moreinfo"=>"moreinfo"),
  array("id"=>10,"moreinfo"=>"moreinfo"),
  array("id"=>15,"moreinfo"=>"moreinfo")
);
$arr2 = array(5=>"mike",10=>"Bob",15=>"Alice");
//
$result = array_map(function($elm)use($arr2){
    $elm['name'] = $arr2[$elm["id"]];
    return array("id"=>$elm["id"],"name"=>$elm["name"],"moreinfo"=>$elm["moreinfo"]);
},$arr1);

var_dump($result);

result:

array (size=3)
  0 => 
    array (size=3)
      'id' => int 5
      'name' => string 'mike' (length=4)
      'moreinfo' => string 'moreinfo' (length=8)
  1 => 
    array (size=3)
      'id' => int 10
      'name' => string 'Bob' (length=3)
      'moreinfo' => string 'moreinfo' (length=8)
  2 => 
    array (size=3)
      'id' => int 15
      'name' => string 'Alice' (length=5)
      'moreinfo' => string 'moreinfo' (length=8)

answered Oct 3, 2016 at 14:05

miglio

2,05811 silver badges24 bronze badges

1 Comment

Masha Over a year ago

Thank you for showing the variant how to save an order

Collectives™ on Stack Overflow

php insert values from one array into another

4 Answers 4

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related