PHP merge duplicate key in array

Question

i got response (json) from web service and converted / decoded it into php array.

converted array php:

$data = [
    [
        'id' => '01',
         'name' => 'ABC',
         'label' => 'color',
         'value' => '#000000'
    ],[ 
         'id' => '01',
         'name' => 'ABC',
         'label' => 'active',
         'value' => true
    ],[
         'id' => '02',
         'name' => 'DEF',
         'label' => 'color',
         'value' => '#ffffff'
    ],[
         'id' => '02',
         'name' => 'DEF',
         'label' => 'active',
         'value' => false
    ]
];

expected array output:

$data = [
    [
         'id' => '01',
         'name' => 'ABC',
         'color' => '#000000',
         'active' => true,
    ],[ 
         'id' => '02',
         'name' => 'DEF',
         'color' => '#ffffff',
         'value' => false
    ]
];

What php function is suitable for that case? thanks in advance

usually a foreach is involved, did you try it out?

Kevin
– Kevin

2019-09-04 02:40:28 +00:00
Commented Sep 4, 2019 at 2:40 — Kevin
– Kevin, Commented Sep 4, 2019 at 2:40
have you tried anything?

JON
– JON

2019-09-04 05:13:02 +00:00
Commented Sep 4, 2019 at 5:13 — JON
– JON, Commented Sep 4, 2019 at 5:13

Rakesh Jakhar · Accepted Answer · 2019-09-04 05:41:37Z

1

You can simple use foreach

$r = [];
foreach($data as $v){
  if(isset($r[$v['id']])){
    $r[$v['id']][$v['label']] = $v['value'];
  }else{
    $r[$v['id']] = [
        'id'        => $v['id'],
        'name'      => $v['name'],
        $v['label'] => $v['value']
    ];
  } 
}

Live example : https://3v4l.org/ilkGG

answered Sep 4, 2019 at 5:41

Rakesh Jakhar

6,4082 gold badges13 silver badges20 bronze badges

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

Comments

Clint · Accepted Answer · 2019-09-04 02:47:52Z

0

$data = json_decode($data); //decode the json into a php array

foreach ($data as $key=>$subArray){ //loop over the array

  //check and see if value is either true/false
  if (is_bool($subArray['value'])){ 
   $processedArray[] = $subArray; //build output
  }

}

print_r($processedArray); //output/dump array for debugging

answered Sep 4, 2019 at 2:47

Clint

1,0738 silver badges22 bronze badges

Comments

Kiran Maniya · Accepted Answer · 2019-09-04 03:47:54Z

0

In this case, you have to loop through the array and remove duplicates, Try the given way

$data = json_decode($data , true);
$filtered = array();
for($i = 0 ; $i < count($data) ; $i++){
    if(!array_key_exist($data[$i]['id'] , $filtered )){
        $filtered [$data[$i]['id']] = $data[$i];
        continue;
    }  
}

$filtered = array_values($filtered);

edited Sep 4, 2019 at 3:47

answered Sep 4, 2019 at 3:41

Kiran Maniya

9,08911 gold badges63 silver badges87 bronze badges

Collectives™ on Stack Overflow

PHP merge duplicate key in array

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related