dongqing314511 2018-02-26 18:22
浏览 85
已采纳

插入JSON列postgres [重复]

This question already has an answer here:

I have a JSON entry like this, which I need to enter into a column (called values)

["Price Descending","Price Ascending","Name Ascending","Date Descending"]

How can I enter this into a json column , what I am trying is this

 $this->db->query("
       INSERT INTO tag_sets (type, value) VALUES
            ('sorting_options', " 
            'Price Descending', 'Price Ascending', 'Name Ascending', 
            'Date Descending'";
      ");

This gives me an error, what is the correct way to insert into a json column?

</div>
  • 写回答

2条回答 默认 最新

  • dougaopu7938 2018-02-26 22:40
    关注

    Try this

    $json = addslashes('"sorting_options",  "Price Descending", "Price Ascending", "Name Ascending", "Date Descending"');
    
    $this->db->query("INSERT INTO tag_sets (type, value) VALUES ('sorting_options', '{$json}')");
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 Coze智能助手搭建过程中的问题请教
  • ¥15 12864只亮屏 不显示汉字
  • ¥20 三极管1000倍放大电路
  • ¥15 vscode报错如何解决
  • ¥15 前端vue CryptoJS Aes CBC加密后端java解密
  • ¥15 python随机森林对两个excel表格读取,shap报错
  • ¥15 基于STM32心率血氧监测(OLED显示)相关代码运行成功后烧录成功OLED显示屏不显示的原因是什么
  • ¥100 X轴为分离变量(因子变量),如何控制X轴每个分类变量的长度。
  • ¥30 求给定范围的全体素数p的(p-2)/p的连乘积值
  • ¥15 VFP如何使用阿里TTS实现文字转语音?