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'];
 }
} 

• Russ J: echo $jsonInput->Body->stkCallback->MerchantRequestID
• SaidbakR: use var_dump($jsonInput) to know the path that leads to the required property

Answer 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.

Answer 2

Use below code for the loop

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

• Refayet Ullah: This works too. Thanks a lot for so quick response.