Loop PHP array based in first array

Question

I just found out how to loop an array based on another array, but my problem is that if the second array is just 1 object than it works fine but I want to make it work with two objects.

Here is an example how it do works,

$shorten = array(
  0 => 'ECAR',
  1 => 'CCAR',
  2 => 'ICAR',
  3 => 'SCAR',
  4 => 'FCAR',
  5 => 'PCAR',
);

$data = array(
  'Hertz' => array(
        'ECAR' => '49.21',
        'CCAR' => '71.04',
        'ICAR' => '89.58',
        'SCAR' => '100.00',
    )
  ),
  'Avis' => array(
        'ECAR' => '412.00',
        'CCAR' => '347.00',
        'ICAR' => '285.00',
        'SCAR' => '224.00',
        'FCAR' => '165.00',
        'PCAR' => '100.00',
    )
  ),
);

// default array as the base
$shorten = array_combine($shorten, array_fill(0, count($shorten), 'n/a'));

foreach($data as &$array) {
    // merge to get set members
    $array = array_merge($shorten, $array);
}
unset($array);

print_r($data);

But I want to make it work with this one,

$shorten = array(
  0 => 'ECAR',
  1 => 'CCAR',
  2 => 'ICAR',
  3 => 'SCAR',
  4 => 'FCAR',
  5 => 'PCAR',
);

$data = array(
  'Hertz' => array(
    'NYCT01' => array(
        'ECAR' => '49.21',
        'CCAR' => '71.04',
        'ICAR' => '89.58',
        'SCAR' => '100.00',
    )
  ),
  'Avis' => array(
    'NYCT01' => array(
        'ECAR' => '412.00',
        'CCAR' => '347.00',
        'ICAR' => '285.00',
        'SCAR' => '224.00',
        'FCAR' => '165.00',
        'PCAR' => '100.00',
    )
  ),
);

// default array as the base
$shorten = array_combine($shorten, array_fill(0, count($shorten), 'n/a'));

foreach($data as $firstArray) {
    foreach($firstArray as &$array){
        // merge to get set members
        $array = array_merge($shorten, $array);
    }
}
unset($array);

print_r($data);

And this is what I want it to be,

Array
(
    [Hertz] => Array
        (
            [ECAR] => 49.21
            [CCAR] => 71.04
            [ICAR] => 89.58
            [SCAR] => 100.00
            [FCAR] => n/a
            [PCAR] => n/a
        )

    [Avis] => Array
        (
            [ECAR] => 412.00
            [CCAR] => 347.00
            [ICAR] => 285.00
            [SCAR] => 224.00
            [FCAR] => 165.00
            [PCAR] => 100.00
        )

)

$data[1][0][0] = 412.00; this is how your would access array in array in array etc. if thats what you meant, is it? I do not really understand your question. — Cninroh
– Cninroh, Commented Jun 13, 2012 at 14:01

Marcus Recck · Accepted Answer · 2012-06-13 14:19:53Z

1

foreach($data AS $company => $nyc){
    $inner = $nyc['NYCT01'];
    foreach($shorten AS $car){
        if(array_key_exists($car, $inner)){
            $output[$company][$car] = $inner[$car];
        }else {
            $output[$company][$car] = "n/a";
        }
    }
}

Just loop through the data and check if the key of any of the cars exists inside the NYCT01 array, if it does set the value, else, "n/a".

My output:

Array
(
    [Hertz] => Array
        (
            [ECAR] => 49.21
            [CCAR] => 71.04
            [ICAR] => 89.58
            [SCAR] => 100.00
            [FCAR] => n/a
            [PCAR] => n/a
        )

    [Avis] => Array
        (
            [ECAR] => 412.00
            [CCAR] => 347.00
            [ICAR] => 285.00
            [SCAR] => 224.00
            [FCAR] => 165.00
            [PCAR] => 100.00
        )

)

answered Jun 13, 2012 at 14:19

Marcus Recck

5,0432 gold badges19 silver badges27 bronze badges

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

5 Comments

thegrede Over a year ago

This is a good idea, but my problem is that the $inner is different in my array, I mean it might be for example NYCT02 or NYCC01 etc.

Marcus Recck Over a year ago

Then alternatively you could loop through $nyc

thegrede Over a year ago

Yes you're right, I'm trying to do that, I'm struggling a little here, hope to figure it out.

thegrede Over a year ago

Thank you Marcus I got it work, please see the answer I entered,

Marcus Recck Over a year ago

No problem! Mark the question as answered then.

thegrede · Accepted Answer · 2012-06-13 15:12:46Z

0

Ok, got it work this is the real code I figured,

foreach($data as $company => $nyc){
    foreach($nyc as $inner => $s){
        foreach($shorten as $car){
            if(array_key_exists($car, $nyc[$inner])){
                $output[$company][$car] = $nyc[$inner][$car];
            }else {
                $output[$company][$car] = "n/a";
            }
        }
    }
}

Thanks so much for your help Marcus,

Good luck.

answered Jun 13, 2012 at 15:12

thegrede

4942 gold badges6 silver badges18 bronze badges

Collectives™ on Stack Overflow

Loop PHP array based in first array

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related