PHP: how to make a nested array into one dimensional array?

Question

This is a nested array I got from my db,

Array
(
    [0] => Array
        (
            [Field] => blc_id
            [Type] => int(10) unsigned
            [Null] => NO
            [Key] => PRI
            [Default] => 
            [Extra] => auto_increment
        )

    [1] => Array
        (
            [Field] => blc_email
            [Type] => varchar(255)
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [2] => Array
        (
            [Field] => cat_id
            [Type] => varchar(255)
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [3] => Array
        (
            [Field] => blc_created
            [Type] => timestamp
            [Null] => NO
            [Key] => 
            [Default] => 0000-00-00 00:00:00
            [Extra] => 
        )

    [4] => Array
        (
            [Field] => blc_updated
            [Type] => timestamp
            [Null] => NO
            [Key] => 
            [Default] => CURRENT_TIMESTAMP
            [Extra] => on update CURRENT_TIMESTAMP
        )

)

How can I use foreach loop to get the result below,

Array
(
    [0] => blc_id
    [1] => blc_email
    [2] => cat_id
    [3] => blc_created
    [4] => blc_updated
)

Here is my code so far but of course it doesnt return the result correctly,

foreach($items as $outer_key => $array)
{ 
    foreach($array as $inner_key => $value)
    { 
        $field_name[] = $value; 
    } 
}

Thanks.

Why don't you alter your query rather than processing the result with PHP? — Elwhis
– Elwhis, Commented Mar 25, 2011 at 15:03
I don't know how to alter my query... here it is - SHOW COLUMNS FROM root_blocks. thanks. — Run
– Run, Commented Mar 25, 2011 at 15:16

Nanne · Accepted Answer · 2011-03-25 15:02:22Z

5

I guess you could use

foreach($items as $outer_key => $array)
{ 
    $field_name[] = $array['Field']; 

}

answered Mar 25, 2011 at 15:02

Nanne

64.4k16 gold badges122 silver badges166 bronze badges

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

Comments

mario · Accepted Answer · 2011-03-25 15:04:29Z

2

When you only need the first entry from each subarray:

$field_names = array_map("current", $outer_key);

answered Mar 25, 2011 at 15:04

mario

146k20 gold badges243 silver badges293 bronze badges

Comments

cantlin · Accepted Answer · 2011-03-25 15:06:16Z

1

$fields = array();

foreach($input_array as $value)
  $fields[] = $value['Field'];

print_r($fields);

answered Mar 25, 2011 at 15:06

cantlin

3,2263 gold badges23 silver badges22 bronze badges

Comments

Peter Lindqvist · Accepted Answer · 2011-03-25 15:23:12Z

0

array_map(create_function('$a','return $a["Field"];'),$a)

answered Mar 25, 2011 at 15:23

Peter Lindqvist

10.2k3 gold badges44 silver badges60 bronze badges

Collectives™ on Stack Overflow

PHP: how to make a nested array into one dimensional array?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related