dpw70180 2014-02-12 18:42
浏览 279
已采纳

将json插入Postgres中表的字段数组中

PHP returns me the json:

{          
      "date"    : "2014-02-06",
      "typeDate": "local",
      "events"  : [
                    "To get know how Sherlock survived",
                    "Find who killed the President Kennedy",
                    "Cook met"
                  ]
       }

I need to insert this object into table's field which has the array of such objects:

{
     "dates": [   
     {          
      "date"    : "2014-02-06",
      "typeDate": "local",
      "events"  : [
                "Kill John Connor",
                "Kill T-1000",
                "Listen Moon sonata"
              ]
     },
     {        
      "date"    : "2014-02-07",
      "typeDate": "local",
      "events"  : [
                "Fix Enstain's theory",
                "Take pizza"
              ]
       }
   ]
}

How to do this correct ? Trying to use the example

INSERT INTO aa VALUES (1, 'my_json_record');

I'm getting the error about structure of json.

  • 写回答

1条回答 默认 最新

  • dooso0594 2014-02-12 21:07
    关注

    hbasically you soould serialize the JSON object before inserting into the database.

     $my_json_var = json_decode($my_json_record)
    

    This methond takes a JSON encoded string and converts it into a PHP variable. see http://us2.php.net/json_decode

    Then build your query...

     $sql = "INSERT INTO aa (field1, field2) VALUES (1, '$my_json_var')";
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 关于#matlab#的问题:需要 MATLAB 运行程序,对比四个多址通信方式(TDMA,FDMA,CDMA,OFDMA)的抗噪声性能
  • ¥15 有没有复现过PFENet的,如何解决?
  • ¥15 FDMA,OFDMA,TDMA 和 CDMA 系统容量对比仿真
  • ¥15 图神经网络的入侵检测
  • ¥15 工业数据采集技术+存储架构推荐
  • ¥15 GPT-SOVITS如何训练少数民族语言支持合成语音
  • ¥20 树莓派4b使用Camera Module 3时出现the system should be configured for the legacy camera stack问题
  • ¥200 GitHub开源程序配置在VScode调试
  • ¥15 爬虫保存的scv文件0kb
  • ¥20 如何实现基于强化学习的带电作业机械臂的运动规划与控制