Accessing specific JSON Object Value using PHP

Question

I am trying to access specific value from a JSON string. Perhaps its due to my lack of understanding of JSON structure and how to access. Please help. I am trying to access value of "MerchantRequestID" and "PhoneNumber"

I have tried following to get MerchantRequestID and getting error. Also, without a loop, can we directly access value of particular element if structure is known?

$JSON_String = '{"Body":{"stkCallback":{"MerchantRequestID":"23226-16663390-1","CheckoutRequestID":"28062020192185","ResultCode":0,"ResultDesc":"It worked.","CallbackMetadata":{"Item":[{"Name":"Amount","Value":5.00},{"Name":"ReceiptNumber","Value":"XX223344"},{"Name":"Balance"},{"Name":"TransactionDate","Value":20200628142747},{"Name":"PhoneNumber","Value":12345678}]}}}}';

echo $JSON_String;
$jsonInput = json_decode($JSON_String, true);

foreach($jsonInput['Body'] as $body){
  foreach($body['stkCallback'] as $callBack){
   echo $callBack['MerchantRequestID'];
  }
}

use var_dump($jsonInput) to know the path that leads to the required property — SaidbakR
– SaidbakR, Commented Jun 28, 2020 at 15:46

Hoppo · Accepted Answer · 2020-06-28 15:38:44Z

1

You can use below code to get key data directly without loop.

$jsonInput = json_decode($JSON_String, true);

    $MerchantRequestID = $jsonInput['Body']['stkCallback']['MerchantRequestID'];
    $phoneNumber = $jsonInput['Body']['stkCallback']['CallbackMetadata']['Item'][4]['Value'];

Thank You.

edited Jun 28, 2020 at 15:38

Hoppo

1,1701 gold badge14 silver badges34 bronze badges

answered Jun 28, 2020 at 15:03

Tejas Soni

113 bronze badges

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

Comments

Eugene · Accepted Answer · 2020-06-28 17:07:47Z

1

Use below code for the loop

foreach ($jsonInput as $key => $value){
   echo $value['stkCallback']['MerchantRequestID'];
   echo "<br>";
   echo $value['stkCallback']['CallbackMetadata']['Item'][4]['Value'];
}

edited Jun 28, 2020 at 17:07

answered Jun 28, 2020 at 15:47

Eugene

113 bronze badges

1 Comment

Refayet Ullah Over a year ago

This works too. Thanks a lot for so quick response.

Collectives™ on Stack Overflow

Accessing specific JSON Object Value using PHP

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related