converting a multidimensional array to a single dimension array php

Question

After going through similar questions i couldn't find matching my scenario. I have $artists_temp array like

Array
(
    [0] => Array
        (
            [ID] => 109
            [post_title] => Junoon
        )

    [1] => Array
        (
            [ID] => 135
            [post_title] => Linkin Park
        )

)

I have done with code to make the array like

Array
(
    [109] => Junoon
    [Junoon] => 
    [135] => Linkin Park
    [Linkin Park] => 
)

Whats required is like

Array
(
    [109] => Junoon
    [135] => Linkin Park
)

Here is the code

$artists_temp = $wpdb->get_results($query, ARRAY_A);
$artists = array();
foreach ($artists_temp as $key => $value) {
    foreach ($value as $k => $v) {
        $artists[$v] = next($value);
        //unset(next($value)) This doesn't work.
    }
}
print_r($artists);

You could add break; on the line after $artists[$v] = .

cpilko
– cpilko

2015-03-04 21:19:26 +00:00
Commented Mar 4, 2015 at 21:19 — cpilko
– cpilko, Commented Mar 4, 2015 at 21:19
@cpilko Thanks man that did the work !

Raheel
– Raheel

2015-03-04 21:29:57 +00:00
Commented Mar 4, 2015 at 21:29 — Raheel
– Raheel, Commented Mar 4, 2015 at 21:29

AbraCadaver · Accepted Answer · 2015-03-04 21:27:37Z

2

PHP >= 5.5.0 needed for array_column() or use the PHP Implementation of array_column():

$artists = array_column($artists_temp, 'post_title', 'ID');

Since you are using WordPress check out: wp_list_pluck():

$artists = wp_list_pluck($artists_temp, 'post_title', 'ID');

edited Mar 4, 2015 at 21:27

answered Mar 4, 2015 at 21:15

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

5 Comments

Raheel Over a year ago

this is informative really. But as i am creating a wordpress plugin not all users have 5.5

AbraCadaver Over a year ago

I hate WordPress, but a quick search turned-up codex.wordpress.org/Function_Reference/wp_list_pluck

Raheel Over a year ago

accepted the below answer but thanks for sharing the nice function array_column is so cool !

AbraCadaver Over a year ago

So you didn't like the WP function that does exactly what you want?

Raheel Over a year ago

I was more concerned about the solution in terms of programming.

kidA · Accepted Answer · 2015-03-04 21:19:57Z

1

You can also do

$artists = array();

foreach ($artists_temp as $array) {
    $artists[$array['ID']] = $array['post_title'];
}

answered Mar 4, 2015 at 21:19

kidA

1,3871 gold badge9 silver badges20 bronze badges

2 Comments

Raheel Over a year ago

cant wait 1 minute to accept this :) Works like a charm

kidA Over a year ago

Glad I could be of service! :)

Collectives™ on Stack Overflow

converting a multidimensional array to a single dimension array php

2 Answers 2

5 Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Related