How to take value of 2nd array of matching key of first array

Question

I have 2 arrays: Mapped Data:

Array
(
    [0] => Array
        (
            [id] => 
        )

    [1] => Array
        (
            [country_code] => 
        )

    [2] => Array
        (
            [user_id] => 
        )

    [3] => Array
        (
            [category_id] => 
        )

    [4] => Array
        (
            [post_type_id] => 
        )

    [5] => Array
        (
            [make] => make
        )

    [6] => Array
        (
            [description] => description
        )
}

Now I have another array which is my CSV Data:

Now I want to take CSV Arrays values if CSV arrays key is matching with Mapped Data Value.

I created logic and try array_key_exists but failed, I try this code of my logic but what it does it is inserting false entries into dbs

If matched I want an array final like

Array
( 
  [0]=> Array
     (
       [description] =>Storage,  suspension, Single axle, Steel rims, Wood floor, Roll up rear door rear door, Length: 28ft
       [make] => Strick
     )
  [1]=> Array
     (
       [description] =>Storage,  suspension, Tandem axle, Steel rims, Wood floor, Swing rear door, Width: 102in, Length: 48ft
       [make] => Roussy
     )
)

Here is my logic,

foreach ($json_decode as $key => $value) 
            {
                /*if(!empty($value))
                {
                    $jsonvalue = (array)$value;
                    foreach ($jsonvalue as $jkey=> $jvalue) 
                    {
                        foreach ($mapped_data as $mkey => $mvalue) 
                        {
                            $mvalue = (array)$mvalue;
                            foreach ($mvalue as $mappedkey=> $mappedvalue) 
                            {
                                if($jkey == $mappedvalue)
                                {
                                    if(!empty($jvalue))
                                    {
                                        // echo "Matched one====".'<br>';
                                        // print_r($jkey).'<br>';   
                                        // print_r($mappedvalue).'<br>';    
                                        // print_r($jvalue).'<br>';

                                        $post->$mappedvalue = $jvalue;
                                        $post->title = 'test';
                                        $post->category_id = '0';
                                        $post->city_id = '0';
                                        //$post->save();
                                    }   
                                }
                            }
                        }

                    }
                }

Where my $json_decode is my CSV Data array.

Can anyone help me out?

u_mulder · Accepted Answer · 2019-10-27 09:04:54Z

1

Full simplified script for your task:

// an example of mapped array
$mapped = [
    [
        'key1' => false,
    ],
    [
        'key2' => 'value',
    ],
];

// now you need to flat your array so as to use advantages of flat arrays
// `array_filter` will also remove keys with empty values.
$flatMapped = array_filter(array_merge(...$mapped));

// here you see that you have a flat array, and not array of arrays
print_r($flatMapped);

// sample csv data
$csvData = [
    [
        'key1' => 42,
        'key2' => 142,
        'key3' => 242,
    ],
    [
        'key1' => 342,
        'key2' => 442,
        'key3' => 542,
    ],
];

// here I modify $csvData array in place, but you 
// can create new array and put values there
foreach ($csvData as &$item) {
    // `array_intersect_key` returns keys with values from 
    // first array which also exist in second array
    $item = array_intersect_key($item, $flatMapped);
}
print_r($csvData);

Demo here.

answered Oct 27, 2019 at 9:04

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

1 Comment

Bits Please Over a year ago

Perfect! can you explain me a bit how this works?

Collectives™ on Stack Overflow

How to take value of 2nd array of matching key of first array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related