dtmm0148603 2011-10-06 05:55
浏览 48
已采纳

解析此JSON文件结构

i have a file with inside data formatted in json format:

{
   "data": 

     {

   "users": [


    {

        "ragione_sociale": "",
        "nome": "Annamaria Zaccariello",
        "indirizzo": "",
        "cap": "",
        "citta": "",
        "provincia": "",
        "telefono1": "",
        "telefono2": "",
        "fax": "",
        "cellulare": "",
        "codice_fiscale": "",
        "newsletter": "1",
        "sesso": "",
        "username": "annamaria.zaccariello@libero.it",
        "scadenza_tessera": "09/08/2012",
        "tipo_tessera": "Red Carpet",
        "stato_tessera": "0",
        "user_id": "1",
        "punti": "0"
    },
    {

        "ragione_sociale": "",
        "nome": "Debora Chessa",
        "indirizzo": "",
        "cap": "",
        "citta": "",
        "provincia": "ge",
        "telefono1": "",
        "telefono2": "",
        "fax": "",
        "cellulare": "3494339496",
        "codice_fiscale": "",
        "newsletter": "1",
        "sesso": "F",
        "username": "debora_c85@hotmail.it",
        "scadenza_tessera": "05/10/2012",
        "tipo_tessera": "Membership",
        "stato_tessera": "0",
        "user_id": "968",
        "punti": "0"
    } 
    ]
     }

}

I need to parse all users one by one and extracting for each one some information "nome", "username", "scadenza_tessera", "tipo_tessera", "stato_tessera", "punti", "provincia", "cellulare"

Anyone can paste PHP code to do this operation ?

Thanks

  • 写回答

1条回答 默认 最新

  • dongshuzhuo5659 2011-10-06 06:25
    关注

    If you save your json stuff in $myjson you will be able to do something like this:

    $myjson = <<< EOT
    {
       "data": 
    
         {
    
       "users": [
    
    
        {
    
            "ragione_sociale": "",
            "nome": "Annamaria Zaccariello",
            "indirizzo": "",
            "cap": "",
            "citta": "",
            "provincia": "",
            "telefono1": "",
            "telefono2": "",
            "fax": "",
            "cellulare": "",
            "codice_fiscale": "",
            "newsletter": "1",
            "sesso": "",
            "username": "annamaria.zaccariello@libero.it",
            "scadenza_tessera": "09/08/2012",
            "tipo_tessera": "Red Carpet",
            "stato_tessera": "0",
            "user_id": "1",
            "punti": "0"
        },
        {
    
            "ragione_sociale": "",
            "nome": "Debora Chessa",
            "indirizzo": "",
            "cap": "",
            "citta": "",
            "provincia": "ge",
            "telefono1": "",
            "telefono2": "",
            "fax": "",
            "cellulare": "3494339496",
            "codice_fiscale": "",
            "newsletter": "1",
            "sesso": "F",
            "username": "debora_c85@hotmail.it",
            "scadenza_tessera": "05/10/2012",
            "tipo_tessera": "Membership",
            "stato_tessera": "0",
            "user_id": "968",
            "punti": "0"
        } 
        ]
         }
    
    }
    EOT;
    
    $obj=json_decode($myjson);
    foreach($obj->data->users as $user){
            echo $user->username;
    }
    

    However if you insert invalid JSON $obj will be null. This is not covered by the snippet.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 宇视监控服务器无法登录
  • ¥15 PADS Logic 原理图
  • ¥15 PADS Logic 图标
  • ¥15 电脑和power bi环境都是英文如何将日期层次结构转换成英文
  • ¥20 气象站点数据求取中~
  • ¥15 如何获取APP内弹出的网址链接
  • ¥15 wifi 图标不见了 不知道怎么办 上不了网 变成小地球了
  • ¥50 STM32单片机传感器读取错误
  • ¥50 power BI 从Mysql服务器导入数据,但连接进去后显示表无数据
  • ¥15 (关键词-阻抗匹配,HFSS,RFID标签天线)