PHP convert JSON array to nested

Question

I'm trying to get JSON by name and save it as a variable with everything related to that nest, what would the best way to accomplish this? (in my scenario the names are unique)

[{
    "name": "Joe",
    "age": "30",
    "gender": "male"
},
{ 
    "name": "Logan", 
    "age": "27",
    "gender": "male"
}]

to something like this

{
"Joe": [{
    "name": "Joe",
    "age": "30",
    "gender": "male"
}],
"Logan": [{
    "name": "Logan",
    "age": "27",
    "gender": "male"
}]
}

i need to be able to search on the name to get the correct one, the API switches order so can't get it from just id

Hmm, step back a bit and think to yourself is this the correct way to do this? In your wanted output you are now duplicating a field when there's no need to do so. Whos to say that those names will always be unique? — IsThisJavascript
– IsThisJavascript, Commented Jan 5, 2018 at 14:51
Are you sure you want the result to be an object containing single-element arrays? — iainn
– iainn, Commented Jan 5, 2018 at 15:05
why do you need/want this, exactly? You already have the name information within the JSON, this just duplicates it. And an array-per-name which, if your names are unique, will only ever have one element in it seems a bit pointless. — ADyson
– ADyson, Commented Jan 5, 2018 at 15:24

jvk · Accepted Answer · 2018-01-05 16:37:31Z

1

Hi This might helps you

$list = '[ 
   { 
      "name":"Joe",
      "age":"30",
      "gender":"male"
   },
   {  
      "name":"Logan",
      "age":"27",
      "gender":"male"
   }]';


$newjson = json_decode($list, true);
$final = [];

foreach ($newjson as $key => $value) {
  $final[$value['name']][]=$value;
}
$finaloutput = json_encode($final, true);
echo "<pre>";
print_r($finaloutput);
echo "</pre>";
exit;

The output is

{"Joe":
[{"name":"Joe","age":"30","gender":"male"}],

"Logan":
[{"name":"Logan","age":"27","gender":"male"}]}

edited Jan 5, 2018 at 16:37

answered Jan 5, 2018 at 16:22

jvk

2,1893 gold badges22 silver badges28 bronze badges

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

2 Comments

JAAulde Over a year ago

This output does not quite match what the OP asked for. It appears that the new object with named properties should have "collections" (arrays) as those named properties.

jvk Over a year ago

@JAAulde Hi Now the output as expected

Nielsen Martins Gonçalves · Accepted Answer · 2018-01-05 17:22:35Z

1

The Laravel Collections Library is a very useful lib to use cases like yours.

For this problem you could use the keyBy method!

$json = '[ 
   { 
      "name":"Joe",
      "age":"30",
      "gender":"male"
   },
   {  
      "name":"Logan",
      "age":"27",
      "gender":"male"
   }
]';

$array = collect(json_decode($json, true))->keyBy('name')->all();

print_r($array); // will be the array with the keys defined by the name!

See https://laravel.com/docs/5.5/collections#method-keyby

edited Jan 5, 2018 at 17:22

answered Jan 5, 2018 at 16:58

Nielsen Martins Gonçalves

3726 silver badges12 bronze badges

3 Comments

Tony Chiboucas Over a year ago

Your answer may be correct, but it should include a code-sample that operates on the OP's example data.

Nielsen Martins Gonçalves Over a year ago

@TonyChiboucas Okay, i've provided a sample code segment.

Tony Chiboucas Over a year ago

Now it makes a strong case for how Laravel Collections can simplify these problems!

Collectives™ on Stack Overflow

PHP convert JSON array to nested

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related