CODEWITHSUNDEEP
phparrayskey
khtims75
khtims75

Reputation: 81

PHP How to replace one associative array keys with another array values

I have two arrays and I need the value from the first one to become the key for each row of an associative array. I think I stated that correctly. I have two arrays:

Array
(
    [field_name0] => first_name
    [field_name1] => mobile
    [field_name2] => email
    [field_name3] => last_name
)

and

Array
(
[1] => Array
    (
        [First Name] => Peter
        [mobile] => 1234567890
        [email] => [email protected]
        [Last Name] => Griffin
    )

[2] => Array
    (
        [First Name] => Al
        [mobile] => 9874561230
        [email] => [email protected]
        [Last Name] => Bundy
    )

)

I need the values from the first array to replace the values in each of the second arrays to look like this:

Array
(
[1] => Array
    (
        [first_name] => Peter
        [mobile] => 1234567890
        [email] => [email protected]
        [last_name] => Griffin
    )

[2] => Array
    (
        [first_name] => Al
        [mobile] => 9874561230
        [email] => [email protected]
        [last_name] => Bundy
    )

)

I have tried some bad attempts at some foreach loops to accomplish this but it's getting a bit tricky for me. Please help. I am hoping I just overlooked a simple way to do this.

What I tried:-

foreach( $field_map as $origKey => $value ){ 
      foreach($csvdata as $csvrow){ 
           foreach($csvrow as $cKey => $cValue){ 
                  $newKey = $value; 
                  $newArray[$newKey] = $cValue; 
           } 
       } 
}

Upvotes: 1

Views: 1005

Answers (2)

barat
barat

Reputation: 1058

Here - without foreach :)

$result = array_map(
    function($person) use ($keys) { 
        return array_combine($keys, $person);
    },
    $source);

http://sandbox.onlinephpfunctions.com/code/68fe2c199ac47349d5391b6b87bef7779cd945ad

Upvotes: 0

Konstantin Mirin
Konstantin Mirin

Reputation: 21

This script:

    $users = [
    [
        'First Name' => 'Peter',
        'mobile' => 1234567890,
        'email' => '[email protected]',
        'Last Name' => 'Griffin',
    ],
    [
        'First Name' => 'Al',
        'mobile' => 9874561230,
        'email' => '[email protected]',
        'Last Name' => 'Bundy',
    ],
];

$fields = [
    'field_name0' => 'first_name',
    'field_name1' => 'mobile',
    'field_name2' => 'email',
    'field_name3' => 'last_name',
];

$fieldNames = array_values($fields);
foreach ($users as &$user) {
    $user = array_combine($fields, array_values($user));
}
print_r($users);

Gives you what you wanted.

Effectively we just discarding keys and relying on the sequence of those items.

Upvotes: 2

Related Questions