Change index of multidimensional array PHP

Question

I've tried some solutions from:

In PHP, how do you change the key of an array element?

php array from multidimensional array keys values

But its is not exacly what i need, i tried to mix some solutions but notting helped.

I have an array from my database:

Array ( 
    [0] => Array (
        [ID] => 1 
        [USER_ID] => 1
        [DATA] => UNIQUE 
        [VALUE] => buuu ) 
    [1] => Array (
        [ID] => 2 
        [USER_ID] => 1 
        [DATA] => NICKNAME 
        [VALUE] => NoAd ) )

And i want to transform that database to:

Array ( 
    [UNIQUE] => buuu
    [NICKNAME] => NoAd
    [any new [2]...[3]... from previous array

after that code:

foreach($playerdata as $segment){
                    foreach($segment as $key => $value ){
                    $newArray[$value] = $value;
                }
            }

my array looks like:

Array ( [UNIQUE] => UNIQUE 
        [buuu] => buuu 
        [NICKNAME] => NICKNAME 
        [NoAd] => NoAd )

i tried use 3x foreach but it ends in error all time i think i need to change some variables in my foreach but no idea how.

What? I can't see any logic here. Also you need to expand your example with more than "any new [2]...[3]... from previous array". And preferably a second item that needs to be merged so that we see a more complete picture — Andreas
– Andreas, Commented Sep 5, 2018 at 7:48
example 3: [3] => Array ( [ID] => any number [USER_ID] => any number [DATA] => anything [VALUE] => something ) ) — NoAd
– NoAd, Commented Sep 5, 2018 at 11:06

Andreas · Accepted Answer · 2018-09-05 09:01:41Z

1

Now that I see the other answers it seems it's array_column you are looking for.

It returns an array column and the third parameter is what the key name should be.

$player_data = array(array(
"ID" => 1,
"USER_ID" => 1,
"DATA" => "UNIQUE",
"VALUE" => "buuu"
),
array(
"ID" => 1,
"USER_ID" => 1,
"DATA" => "NICKNAME",
"VALUE" => "NoAd"
));
$new = array_column($player_data, "VALUE", "DATA");
var_dump($new);

Output:

array(2) {
  ["UNIQUE"]=>
  string(4) "buuu"
  ["NICKNAME"]=>
  string(4) "NoAd"
}

https://3v4l.org/ZAkgZ

There is no need for loops to solve this.

answered Sep 5, 2018 at 9:01

Andreas

24k7 gold badges34 silver badges75 bronze badges

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

1 Comment

NoAd Over a year ago

Thank You! that was exactly what I needed

Kanishka Panamaldeniya · Accepted Answer · 2018-09-05 07:54:07Z

0

lets assume $playerdata has the below values

Array ( 
    [0] => Array (
        [ID] => 1 
        [USER_ID] => 1
        [DATA] => UNIQUE 
        [VALUE] => buuu ) 
    [1] => Array (
        [ID] => 2 
        [USER_ID] => 1 
        [DATA] => NICKNAME 
        [VALUE] => NoAd ) ) 
    [2]----
    [3]----        

$newArray = [];
foreach($playerdata as $record) {
    $newArray[$record['DATA']] = $record['DATA'];
    $newArray[$record['VALUE']] = $record['VALUE'];
}

print_r($newArray);

answered Sep 5, 2018 at 7:54

Kanishka Panamaldeniya

17.6k31 gold badges128 silver badges195 bronze badges

Comments

Ruben Pauwels · Accepted Answer · 2018-09-05 08:00:37Z

0

You could try something like the following:

$newArray = array();    
foreach($playerdata as $segment){
    $newArray[$segment['DATA']] = $segment['VALUE'];
}

This code gets the DATA as key and VALUE as value from each part of the array and stores it in $newArray.

edited Sep 5, 2018 at 8:00

answered Sep 5, 2018 at 7:53

Ruben Pauwels

3803 silver badges14 bronze badges

Collectives™ on Stack Overflow

Change index of multidimensional array PHP

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related