PHP Arrays - change key name with value

Question

I have a array pulled from MySQL with the form below:

Array (
    [0] => Array (
        [id] => 0
        [settings_name] => auto_email
        [value] => 1
        [date_added] => 0
        [date_created] => 0
    )
    [1] => Array (
        [id] => 0
        [settings_name] => email_hour
        [value] => 17
        [date_added] => 0 [date_created] => 0
    )
)

What I am trying to do is to change the array to this form:

Array (
    [0] => Array (
        [id] => 0
        [auto_email] => 1
        [date_added] => 0
        [date_created] => 0
    )
    [1] => Array (
        [id] => 0
        [email_hour] => 17
        [date_added] => 0
        [date_created] => 0 )
    )

I am trying to acces the 'auto_email' setting directly not by settings_name. Could someone help me out?

rjdown · Accepted Answer · 2014-10-26 13:41:57Z

1

Two ways, depending on if you want to create a new array, or just alter the existing one:

Create new:

$newArray = array();
foreach ($array as $value) {
    $newArray[] = array(
        'id' => $value['id'],
        $value['settings_name'] => $value['value'],
        'date_added' => $value['date_added'],
        'date_created' => $value['date_created']
    );
}

Alter existing:

foreach ($array as $key => $value) {
    $array[$key][$value['settings_name']] = $value['value'];
    unset($array[$key]['settings_name']);
    unset($array[$key]['value']);
}

answered Oct 26, 2014 at 13:41

rjdown

9,2073 gold badges35 silver badges48 bronze badges

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

Comments

gmponos · Accepted Answer · 2014-10-26 13:26:37Z

0

Try the command array_flip. From what you say i think you must save the id first to another array

see the manual: http://php.net/manual/en/function.array-flip.php

answered Oct 26, 2014 at 13:26

gmponos

2,2874 gold badges26 silver badges34 bronze badges

Comments

bansi · Accepted Answer · 2014-10-26 14:00:57Z

You should loop through the items in the array and create a new array the way you want.

$output = array();
foreach ($your_input_array as $v){
    $output[]=array(
                    'id' => $v['id'],
                    $v['settings_name']=>$v['value'], //use the setting name as key here
                    'date_added' => $v['date_added'],
                    'date_created' => $v['date_created']
                    );
}
print_r($output);

If you want to just alter the existing array you can use array_walk

array_walk($your_input_array, function (&$v){
    $v=array(
            'id' => $v['id'],
            $v['settings_name']=>$v['value'], //use the setting name as key here
            'date_added' => $v['date_added'],
            'date_created' => $v['date_created']
            );
});
print_r($your_input_array);

The above works only with PHP 5.3+ as anonymous functions are introduced in PHP 5.3. If you are stuck with version less than PHP 5.3 you can do it without anonymous function.

array_walk($your_input_array,'fixarray');
function fixarray(&$v){
    $v=array(
        'id' => $v['id'],
        $v['settings_name']=>$v['value'], //use the setting name as key here
        'date_added' => $v['date_added'],
        'date_created' => $v['date_created']
        );
}
print_r($your_input_array);

Collectives™ on Stack Overflow

PHP Arrays - change key name with value

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