Group an array with dynamic key values?

Question

I have JSON array values as given below,

{
  "test_details": [
    {
      "test_id": "001",
      "test_name": "Blood Test",
      "group_name": "Group 1",
      "package_details": [
        {
          "package_name": "master health checkup",
          "package_id": "1"
        },
        {
          "package_name": "special camp package",
          "package_id": "2"
        }
      ]
    },
    {
      "test_id": "002",
      "test_name": "haemoglobin",
      "group_name": "Group 2",
      "package_details": [
        {
          "package_name": "master health checkup",
          "package_id": "1"
        }
      ]
    },
    {
      "test_id": "003",
      "test_name": "creatine test",
      "group_name": "Group 2",
      "package_name": null
    }
  ]
}

In the above JSON, I want to group the values by the key package_name, which means I want to order the test list against the package name.

I have tried several array group by functions but for a dynamic key package_name, it is not working.

My final output JSON would be:

{
  "test_details": {
    "master health checkup": [
      {
        "test_id": "001",
        "test_name": "Blood Test",
        "group_name": "Group 1",
        "package_details": [
          {
            "package_name": "master health checkup",
            "package_id": "1"
          },
          {
            "package_name": "special camp package",
            "package_id": "2"
          }
        ]
      },
      {
        "test_id": "002",
        "test_name": "haemoglobin",
        "group_name": "Group 2",
        "package_details": [
          {
            "package_name": "master health checkup",
            "package_id": "1"
          }
        ]
      }
    ],
    "special camp package": [
      {
        "test_id": "001",
        "test_name": "Blood Test",
        "group_name": "Group 1",
        "package_details": [
          {
            "package_name": "master health checkup",
            "package_id": "1"
          },
          {
            "package_name": "special camp package",
            "package_id": "2"
          }
        ]
      }
    ]
  }
}

here you can see the master health checkup have 2 tests and under and same as special camp package have 1 test. how to achieve this? how to apply array group by when the array key is dynamic?

@EmilioGort it was already there, but another editor deleted it for some reason. I put it back. — Don't Panic
– Don't Panic, Commented Oct 25, 2017 at 15:41

Don't Panic · Accepted Answer · 2017-10-25 15:50:52Z

0

After decoding the JSON, iterate the test_details. If a test has a package_details property, then iterate that and assign the test to your result array using each package name as the key.

$data = json_decode($json);

foreach ($data->test_details as $test) {
    if (isset($test->package_details)) {
        foreach ($test->package_details as $package) {
            $result['test_details'][$package->package_name][] = $test;
        }
    }
}

echo json_encode($result);

answered Oct 25, 2017 at 15:50

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

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

Collectives™ on Stack Overflow

Group an array with dynamic key values?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related