query "select for update" in codeigniter
You could try to use query builder to prevent SQL error:
$query = $this->db->select() ->from('table') ->where('id >', 1) ->limit(1) ->get_compiled_select();$data = $this->db->query("{$query} FOR UPDATE")->row_array();$this->db->where('id', $condi)->update('table', ['aa'=>'ok']);
Because the Codeigniter 3 builder doesn't support FOR UPDATE
, so I just use compiler to rebuild query.
Codeigniter get_compiled_select()