Online PHP editor | output for UuDQM

<?php $resp = '{ "IsSuccess": true, "ResponseCode": 5000, "ResponseMessage": "OK", "Data": { "result": { "RATE_TO_ALL": [ { "FROM_CURR_NAME": "CHF", "TO_CURR_NAME": "TRY", "TREND_RATE": "0", "SELL_RATE": "45.51", "BUY_RATE": "26.24", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "GBP", "TO_CURR_NAME": "TRY", "TREND_RATE": "0", "SELL_RATE": "50.71", "BUY_RATE": "29.24", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "CAD", "TO_CURR_NAME": "CHF", "TREND_RATE": "0", "SELL_RATE": "0.69", "BUY_RATE": "0.66", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "AUD", "TO_CURR_NAME": "TRY", "TREND_RATE": "0", "SELL_RATE": "26.63", "BUY_RATE": "15.35", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "AUD", "TO_CURR_NAME": "GBP", "TREND_RATE": "0", "SELL_RATE": "0.54", "BUY_RATE": "0.51", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "AUD", "TO_CURR_NAME": "CHF", "TREND_RATE": "0", "SELL_RATE": "0.60", "BUY_RATE": "0.57", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "AUD", "TO_CURR_NAME": "CAD", "TREND_RATE": "0", "SELL_RATE": "0.88", "BUY_RATE": "0.85", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "CAD", "TO_CURR_NAME": "TRY", "TREND_RATE": "0", "SELL_RATE": "30.88", "BUY_RATE": "17.80", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "CAD", "TO_CURR_NAME": "GBP", "TREND_RATE": "0", "SELL_RATE": "0.62", "BUY_RATE": "0.60", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "CHF", "TO_CURR_NAME": "GBP", "TREND_RATE": "0", "SELL_RATE": "0.92", "BUY_RATE": "0.88", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "USD", "TO_CURR_NAME": "GBP", "TREND_RATE": "0", "SELL_RATE": "0.83", "BUY_RATE": "0.80", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "USD", "TO_CURR_NAME": "TRY", "TREND_RATE": "0", "SELL_RATE": "33.89", "BUY_RATE": "22.92", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "CHF", "TO_CURR_NAME": "ALL", "TREND_RATE": "0", "SELL_RATE": "110.85", "BUY_RATE": "107.10", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "CAD", "TO_CURR_NAME": "ALL", "TREND_RATE": "0", "SELL_RATE": "72.90", "BUY_RATE": "70.40", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "AUD", "TO_CURR_NAME": "EUR", "TREND_RATE": "0", "SELL_RATE": "0.62", "BUY_RATE": "0.60", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "AUD", "TO_CURR_NAME": "ALL", "TREND_RATE": "0", "SELL_RATE": "64.75", "BUY_RATE": "62.55", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "CHF", "TO_CURR_NAME": "EUR", "TREND_RATE": "0", "SELL_RATE": "1.05", "BUY_RATE": "1.02", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "EUR", "TO_CURR_NAME": "ALL", "TREND_RATE": "0", "SELL_RATE": "105.35", "BUY_RATE": "104.75", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "EUR", "TO_CURR_NAME": "GBP", "TREND_RATE": "0", "SELL_RATE": "0.89", "BUY_RATE": "0.85", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "EUR", "TO_CURR_NAME": "TRY", "TREND_RATE": "0", "SELL_RATE": "35.94", "BUY_RATE": "24.90", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "GBP", "TO_CURR_NAME": "ALL", "TREND_RATE": "0", "SELL_RATE": "123.00", "BUY_RATE": "117.35", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "TRY", "TO_CURR_NAME": "ALL", "TREND_RATE": "0", "SELL_RATE": "3.81", "BUY_RATE": "3.10", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "USD", "TO_CURR_NAME": "ALL", "TREND_RATE": "0", "SELL_RATE": "99.10", "BUY_RATE": "97.15", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "USD", "TO_CURR_NAME": "AUD", "TREND_RATE": "0", "SELL_RATE": "1.57", "BUY_RATE": "1.52", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "USD", "TO_CURR_NAME": "CAD", "TREND_RATE": "0", "SELL_RATE": "1.39", "BUY_RATE": "1.35", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "USD", "TO_CURR_NAME": "CHF", "TREND_RATE": "0", "SELL_RATE": "0.92", "BUY_RATE": "0.89", "PERCENTAGE_RATE": "0.00" }, { "FROM_CURR_NAME": "USD", "TO_CURR_NAME": "EUR", "TREND_RATE": "0", "SELL_RATE": "0.95", "BUY_RATE": "0.91", "PERCENTAGE_RATE": "0.00" } ], "LASTUPDATED": "04-11-2023 14:30:03" } } }'; $data = json_decode($resp, true); $rates = array_reduce($data['Data']['result']['RATE_TO_ALL'], function ($acc, $item) { $acc[$item['FROM_CURR_NAME']][$item['TO_CURR_NAME']] = array( 'SELL_RATE' => $item['SELL_RATE'], 'BUY_RATE' => $item['BUY_RATE'] ); return $acc; }, array()); $required_rates = [ ['FROM_CURR_NAME' => 'EUR', 'TO_CURR_NAME' => 'GBP'], ['FROM_CURR_NAME' => 'EUR', 'TO_CURR_NAME' => 'TRY'], ['FROM_CURR_NAME' => 'USD', 'TO_CURR_NAME' => 'GBP'] ]; $results = []; $id = 1; foreach ($required_rates as ['FROM_CURR_NAME' => $from, 'TO_CURR_NAME' => $to]) { $buy = $rates[$from][$to]['BUY_RATE']; $sell = $rates[$from][$to]['SELL_RATE']; $results[] = array("id" => $id++, "currency" => $from, "buy" => $buy, "sell" => $sell); } $json_data = json_encode(array('Exchange Rates' => $results)); echo json_encode(array('Exchange Rates' => $results), JSON_PRETTY_PRINT);