CODEWITHSUNDEEP
phparrays
Mubarak
Mubarak

Reputation: 183

filter array after merging keys of one array

I am trying to create filtered array 3 using array 1 and array 2.

ARRAY 1

Array ( 
          [title] => value 
          [title2] => value2 
          [title3] => value3
      )

ARRAY 2

Array ( 
          [0] => Array ( [id] => 20 [title2] => value2 [otherColumn1] => otherValue1)
          [1] => Array ( [id] => 21 [title4] => value4 [otherColumn3] => otherValue3)
      )

Desired Result after applying the intersection method:

ARRAY 3

Array ( [title2] => value2 )

So far I am unable to achieve the result because array 1 and 2 have non-matching structures. I have tried different techniques but I am unable compare them due to structure differences.

   if (!empty($data1['array2'][0])) {

                foreach ($data1['array2'] as $key) {

//                    $filtered= array_intersect($array1,$key);
                    //  print_r($key);
                }
                // $filtered= array_intersect($array1,$data1['array2']);// if i use $data1['array2'][0] it filters fine but just one row

                //    print_r($filtered);
            }

Any help would be much appreciated. Thank you.

Upvotes: 1

Views: 116

Answers (2)

rushi
rushi

Reputation: 34

you can remove structural difference in the following way

$arr1 = array (
        0 => array('title' => 'value', 'title2' => 'value2', 'title3' => 'value3'));
$arr2 = array (
        0 => array ( 'id' => '20', 'title2' => 'value2', 'otherColumn1' => 'otherValue1'),
        1 => array ( 'id' => '21', 'title4' => 'value4', 'otherColumn3' => 'otherValue3'));

Upvotes: -1

Expedito
Expedito

Reputation: 7795

Given the arrays:

$arr = array('title' => 'value', 'title2' => 'value2', 'title3' => 'value3');
$arr2 = array (
        0 => array ( 'id' => '20', 'title2' => 'value2', 'otherColumn1' => 'otherValue1'),
        1 => array ( 'id' => '21', 'title4' => 'value4', 'otherColumn3' => 'otherValue3'));

You can get your filtered array with this:

$merged = call_user_func_array('array_merge', $arr2);
$filtered = array_intersect($arr, $merged);

If you want to intersect just according to the keys you can use this instead:

$filtered = array_intersect_key($arr, $merged);

Upvotes: 3

Related Questions