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条)

报告相同问题?