解析 JSON 并删除 PHP 中的项目


Parse JSON & remove items in PHP

所以,我有一些JSON数据看起来像这样:

  {  
   "Table1":[  
      {  
         "CURRENCY_FLAG":"EUR",
         "TRADE_DATE":"2015-10-15",
         "DELIVERY_DATE":"2015-10-15",
         "DELIVERY_HOUR":"7",
         "DELIVERY_INTERVAL":"1",
         "RUN_TYPE":"EA",
         "SMP":"35.370",
         "LAMBDA":"35.370",
         "SYSTEM_LOAD":"3164.611",
         "CMS_TIME_STAMP":"2015-10-14T10:03:09+01:00"
      },
      {  
         "CURRENCY_FLAG":"GBP",
         "TRADE_DATE":"2015-10-15",
         "DELIVERY_DATE":"2015-10-15",
         "DELIVERY_HOUR":"7",
         "DELIVERY_INTERVAL":"1",
         "RUN_TYPE":"EA",
         "SMP":"26.460",
         "LAMBDA":"26.460",
         "SYSTEM_LOAD":"3164.611",
         "CMS_TIME_STAMP":"2015-10-14T10:03:09+01:00"
      }... etc

我在PHP上非常基础,但是已经使用CURL获取了这些数据,现在我想遍历这些数据并删除每个具有"CURRENCY_FLAG""GBP"值的节点,并只挂在那些带有"EUR"符号的节点上。

谁能指出我用 PHP 解析它的正确方向?

谢谢!

使用 json_decode() 解码 json 字符串后,只需尝试这样做

//decode json string
$result = json_decode($curl_result, true);
 $final_result = [];
 foreach($result['Table1'] as $key => $value){
    if($value['CURRENCY_FLAG'] != 'GBP'){  //exclude currency flag with GBP
      $final_result[] = $value;
    }
 }
print '<pre>';
print_r($final_result);
print '</pre>';