JSON data formation in PHP

Question

I want to chunk json by it's value using PHP. Here sample json is

{
"16506": "10",
"16507": "10",
"16508": "10",
"16509": "10",
"16510": "20",
"16511": "20",
"16512": "20",
"16513": "30"
}

my expectation is to format like

10=>[16506,16507,16508,16509]
20=>[16510,16511,16512]
30=>[16513]

Is there any built-in function is php or have to use loop ? here I used json_decode() and array_flip(). But array_flip makes it distinct. Thanks in advance

you're probably looking for that one-liner, someone could probably get creative with one, but yeah just simply loop it and push via key — Kevin
– Kevin, Commented Oct 20, 2020 at 6:21

Robin Gillitzer · Accepted Answer · 2020-10-20 06:26:31Z

1

There is a build-in function called array_walk. Here you can read about it.

$json = '{"16506": "10","16507": "10","16508": "10","16509": "10","16510": "20","16511": "20","16512": "20","16513": "30"}';

array_walk(json_decode($json), function($value, $key) use (&$result)  {
  $result[$value][] = $key;
});

print_r($result);

Result:

Array
(
    [10] => Array
        (
            [0] => 16506
            [1] => 16507
            [2] => 16508
            [3] => 16509
        )

    [20] => Array
        (
            [0] => 16510
            [1] => 16511
            [2] => 16512
        )

    [30] => Array
        (
            [0] => 16513
        )

)

edited Oct 20, 2020 at 6:26

answered Oct 20, 2020 at 6:21

Robin Gillitzer

1,6121 gold badge9 silver badges18 bronze badges

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

Comments

Devsi Odedra · Accepted Answer · 2020-10-20 06:29:48Z

You can do something below, just need to go through a loop

$json = '{
"16506": "10",
"16507": "10",
"16508": "10",
"16509": "10",
"16510": "20",
"16511": "20",
"16512": "20",
"16513": "30"
}';


$ar = json_decode($json);
$newAr = []; 
foreach($ar as $k => $v){
    $newAr[$v][] = $k;
}
print_r($newAr);

Output will be:

Array
(
    [10] => Array
        (
            [0] => 16506
            [1] => 16507
            [2] => 16508
            [3] => 16509
        )

    [20] => Array
        (
            [0] => 16510
            [1] => 16511
            [2] => 16512
        )

    [30] => Array
        (
            [0] => 16513
        )

)

if you want as string, then implode it

foreach($newAr as $k => $v){
    $newAr[$k] = implode(',',$v);
}

print_r($newAr);

Output will be

Array
(
    [10] => 16506,16507,16508,16509
    [20] => 16510,16511,16512
    [30] => 16513
)

Paras Sharma · Accepted Answer · 2020-10-20 09:25:13Z

1

Here is my code

<?php
  $json =json_decode('{
  "16506": "10",
  "16507": "10",
  "16508": "10",
  "16509": "10",
  "16510": "20",
  "16511": "20",
  "16512": "20",
  "16513": "30"
  }',true);
$arrys = [];  
  foreach ($json as $k => $sd){ 
        $arrys[$sd][] = $k;   
  }
 
echo "<pre>"; print_r($arrys); die; 
 ?>

edited Oct 20, 2020 at 9:25

answered Oct 20, 2020 at 6:35

Paras Sharma

996 bronze badges

1 Comment

Andreas Over a year ago

Why this? if(in_array($sd, $json)){? It will always be true since $sd comes from $json so naturally it has to be true. And your second foreach does nothing at all except moving the data from one array to the other. No difference what so ever. 3v4l.org/OoeYo

Collectives™ on Stack Overflow

JSON data formation in PHP

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related