Codeigniter mysql查询AND_OR

Question

Just trying to write custom string for $this->db->where(); function but I get syntax errors. Could you have a look on the code below to find the mistake

$where = "'phone' => $this->input->post('phone') AND '2g' = $data['2g'] OR '3g' = $data['3g'] OR '4g' = $data['4g']";

Answer 1

You're mixing two types of parameters for the $this->db->where() function.

From the docs http://ellislab.com/codeigniter/user-guide/database/active_record.html

You either supply an associative array (like 'phone' => $this->input->post('phone')) or you suppliy a custom string $where = "name='Joe' AND status='boss' OR status='active'";

You can't mix the two