在Get_Where查询中匹配JSON字段（代码点火器）

Question

I am doing a result_array() in my get_where query but the column in 'added_by' is json format to {'id': '(the id)'}

How Can I do a get_where query to match the current users id.

Heres what I have so far.

$this->db
     ->order_by('till', 'desc')
     ->get_where('coupon', 
          [
               'added_by' => json_encode(array('id'=> $this->session->user_id)), 
               'status' => 'ok'
          ]
     )
     ->result_array()

Answer 1

json_encode will return {"id": $id}. If you are OK with {"id": "$id"}, then you just need to force coerce to string:

json_encode(array('id'=> $this->session->user_id . ''))

If you need {'id': '$id'}, you will need to do a string replace manually.

str_replace( '"', '\'', json_encode(array('id'=> $this->session->user_id . ''))