combining single and multidimensional array in php

Question

single dimensional array

$arr1 = array(3) {
  ["Gold"]=> "170"
  ["Diamond"]=> "301"
  ["Platinum"]=>  "302"
}

multidimensional array

$arr2 = array(3) {

  [0]=>
  array(2) {
    ["ID"]=> "p103"
    ["PID"]=> "301"
  }

  [1]=>
  array(2) {
    ["ID"]=> "p104"
    ["PID"]=> "302"
  }

  [2]=>
  array(2) {
    ["ID"]=> "p105"
    ["PID"]=> "300"
  } 
}

And the intersecting can be,

array(2) {

  [0]=>
  array(2) {
    ["ID"]=> "301"
    ["PID"]=> "Diamond"
  }

  [1]=>
  array(2) {
    ["ID"]=> "302"
    ["PID"]=> "Platinum"
  }
}

I had tried using php array_intersect(), $Data = array_intersect_assoc($arr1,$arr2); but something was missing. Any suggestions and help can be appreciated. Thanks

May we see your attempt with `array_intersect()`? – halfer Sep 18 '16 at 15:22 — halfer, Sep 18 '16 at 15:22
@halfer pls see the edited question. – Boopathi D Sep 18 '16 at 15:26 — Boopathi D, Sep 18 '16 at 15:26

score 1 · Accepted Answer · edited Sep 19 '16 at 13:53

1

You could simply loop through and assign appropriate value to the PID field.

$array1 = array(
   "Gold" => "170",
   "Diamond" => "301",
   "Platinum" => "302"
 );

 $array2 = array(
   array(
    "ID" => "p103",
    "PID" => "301"
   ),
   array(
    "ID" => "p104",
    "PID" => "302"
  ),
  array(
    "ID" => "p105",
    "PID" => "300"
  )
);

$array1 = array_flip($array1);  // Flipping first array so that we can directly use the values Gold, Diamond corresponding to 301, 301 ...

foreach ($array2 as $k => &$arr) {
   /* 
    * If value exists in array 1 then assign it to PID 
    * Otherwise, unset this array key
    */
   if (isset($array1[$arr['PID']])) {
       $arr['PID'] = $array1[$arr['PID']];  
   } else {
       unset($array2[$k]);
   }
}

edited Sep 19 '16 at 13:53

halfer

19,824
17
99
186

answered Sep 18 '16 at 15:27

Indrasis Datta

8,692
2
14
32

Works perfectly, Thanks and how to master in arrays? – Boopathi D Sep 18 '16 at 15:55
You just need to stick to the basics like loops and build your concept. And also familiarize yourself with basic array functions. – Indrasis Datta Sep 18 '16 at 16:09
why & in `&$arr`?. pls explain – Boopathi D Sep 18 '16 at 16:10
Since we are overwriting `$arr['PID']` we need to use this `&` i.e the reference. Had we not used `&`, the values wouldn't have been overwritten. – Indrasis Datta Sep 18 '16 at 16:19
why the function `array_intersect_assoc` or `array_intersect` doesnt works for this question? – Boopathi D Sep 18 '16 at 17:13

combining single and multidimensional array in php

1 Answers1