Extracting data from complicated associative array in php and put into new array

Question

I have an complicated array that looks like this:

$input=array(
    (int) 0 => array(
        'XXX' => array(
            'id' => '7',
            'p_id' => '1',
            'address' => '9463',
            'arrival_time' => '2014-05-01 03:30:00'
        ),
        'YYY' => array(
            'id' => '1',
            'iden' => '1111',
            'name' => 'Tom'
        )
    ),
    (int) 1 => array(
        'XXX' => array(
            'id' => '9',
            'p_id' => '2',
            'address' => '9469',
            'arrival_time' => '2014-05-27 16:43:58'
        ),
        'YYY' => array(
            'id' => '2',
            'iden' => '2222',
            'name' => 'Sam'
        )
    ),
    (int) 2 => array(
        'XXX' => array(
            'id' => '3',
            'p_id' => '3',
            'address' => '9462',
            'arrival_time' => '2014-04-21 14:05:00'
        ),
        'YYY' => array(
            'id' => '3',
            'iden' => '3333',
            'name' => 'James'
        )
    )
)

I would like to convert it such that it looks like this;

$output=array(
    (int) 0 => array(
        'name' => 'Tom',
        'iden' => '1111',
        'address' => '9463'
    ),
    (int) 1 => array(
        'name' => 'Sam',
        'iden' => '2222',
        'address' => '9469'
    ),
    (int) 2 => array(
        'name' => 'James',
        'iden' => '3333',
        'address' => '9462'
    )

I wrote some code to solve this problem:

foreach ( $input as $key => $value)
{
    $output['name']=$input[$key]['YYY']['name'];
    $output['iden']=$input[$key]['YYY']['iden'];
    $output['address']=$input[$key]['XXX']['address'];
}

Unfortunately, it retrieves only the last element of the input array.

Can someone more experienced help?

Thank you very much.

To define an array it is not necessary to use (int) 0 =>

Al.G.
– Al.G.

2014-05-27 10:10:03 +00:00
Commented May 27, 2014 at 10:10 — Al.G.
– Al.G., Commented May 27, 2014 at 10:10

kero · Accepted Answer · 2014-05-27 10:10:11Z

3

You are overwriting the values in each iteration, as you always write to $output['name'] etc.

foreach ( $input as $key => $value)
{
    $output[$key] = array(
        'name' => $value['YYY']['name'],
        'iden' => $value['YYY']['iden'],
        'address' => $value['XXX']['address']
    );
}

The key here is using $output[$key] instead of $output - this way you will add a new element in each iteration.

Also $input[$key] and $value are equivalent, so I used the shorter variant ;)

answered May 27, 2014 at 10:10

kero

10.7k5 gold badges44 silver badges52 bronze badges

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

Comments

Bharat Maheshwari · Accepted Answer · 2014-05-27 10:11:10Z

1

Try this in your foreach loop :-

foreach ( $input as $key=>$value)
{
    $output[$key]['name']=$value['YYY']['name'];
    $output[$key]['iden']=$value['YYY']['iden'];
    $output[$key]['address']=$value['XXX']['address'];
}

answered May 27, 2014 at 10:11

Bharat Maheshwari

4183 silver badges15 bronze badges

Comments

Dieter Pollier · Accepted Answer · 2014-05-27 10:11:05Z

0

You have to add an index to the array in the foreach: $output[$key]["name"] = ...;

answered May 27, 2014 at 10:11

Dieter Pollier

8391 gold badge6 silver badges11 bronze badges

Collectives™ on Stack Overflow

Extracting data from complicated associative array in php and put into new array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related