drpogkqqi536984960 2014-12-19 15:53
浏览 237
已采纳

从json格式中提取特定数据

I have the following json format data :

{"query":{
  "count":5,"created":"2014-12-19T15:42:41Z","lang":"en-US","results":{
    "channel":[{
      "item":{
        "forecast":{"date":"19 Dec 2014","high":"61","low":"47"}
       }},{
      "item":{
        "forecast":{"date":"20 Dec 2014","high":"60","low":"48"}
       }},{
      "item":{
        "forecast":{"date":"21 Dec 2014","high":"61","low":"44"}
       }},{
      "item":{
        "forecast":{"date":"22 Dec 2014","high":"58","low":"46"}
       }},{
      "item":{
        "forecast":{"date":"23 Dec 2014","high":"58","low":"45"}
       }}]
     }
   }
}

How can I access specific data from this format (for example only high and low), in order to insert these data in a mySQL database for instance?

  • 写回答

3条回答 默认 最新

  • dskvfdxgdo2422392 2014-12-19 16:17
    关注

    Put your json in a variable $str for example, than you can access the items :

    $json = json_decode($str);
    $res = $json->{'query'}->{'results'}->{'channel'};
    foreach($res as $ch) {
        echo "High:" . $ch->{'item'}->{'forecast'}->{'high'} . "<br>";
        echo "Low:" . $ch->{'item'}->{'forecast'}->{'low'} . "<br>";
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥20 树莓派5做人脸情感识别与反馈系统
  • ¥15 selenium 控制 chrome-for-testing 在 Linux 环境下报错 SessionNotCreatedException
  • ¥15 使用pyodbc操作SQL数据库
  • ¥15 MATLAB实现下列
  • ¥30 mininet可视化打不开.mn文件
  • ¥50 C# 全屏打开Edge浏览器
  • ¥80 WEBPACK性能优化
  • ¥30 python拟合回归分析
  • ¥500 metaswitch 6010
  • ¥15 关于#分类#的问题:不用人工智能的算法