How to combine arrays from an array returned by MySQL?

Question

I have an array like this, returned by MySQL:

array(0 => array('123', 'data'), 1 => array('124', 'data2'));

Now I want to transform it into this without doing any loops through an array:

array('123' => 'data', '124' => 'data2');

Any particular reason why no loops? Is this homework? or do you just want to make things harder? — Mark Baker
– Mark Baker, Commented Mar 13, 2012 at 22:05
Just for fun. It is easy to use a foreach loop for this, but it is actually boring. — user1267570
– user1267570, Commented Mar 13, 2012 at 22:08

Mark Baker · Accepted Answer · 2012-03-13 22:12:48Z

1

$data = array(0 => array('123', 'data'), 1 => array('124', 'data2'));

$newdata = array_combine( array_map( function( $item ) {
                                         return $item[0];
                                     },
                                     $data
                                   ),
                          array_map( function( $item ) {
                                         return $item[1];
                                     },
                                     $data
                                   )
                        );

var_dump($newdata);

answered Mar 13, 2012 at 22:12

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

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

1 Comment

pät Over a year ago

Making trivial tasks look like l33t ;)

Collectives™ on Stack Overflow

How to combine arrays from an array returned by MySQL?

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