php - or_where 在 codeigniter 模型中不起作用

Question

我有一个查询模型。但是第二个 or_where 不工作

模型

    $this->db->select('st_student.st_id');
    $this->db->from('st_student'); 
    $this->db->where('st_status',1);
    $this->db->or_where('st_status',2);  
    if(($from!='') && ($to!='')){  
        $this->db->where("ab_date BETWEEN '$from' AND '$to'");
        $this->db->or_where("as_date BETWEEN '$from' AND '$to'");
    } 
    $this->db->group_by('st_student.st_id');    
    $result=$this->db->get();

sql查询

SELECT `st_student`.`st_id`
FROM (`st_student`)
WHERE `st_status` =  1
OR `st_status` =  2
AND `ab_date` BETWEEN '01/15/2016' AND '01/26/2016'
AND `as_date` BETWEEN '01/15/2016' AND '01/26/2016'
GROUP BY `st_student`.`st_id`

这有什么不对

Answer 1

您没有得到预期的结果，因为查询没有条件括号。

尝试如下:

$status_condition = 'st_status = 1 or st_status = 2';
$this->db->select('st_student.st_id');
$this->db->from('st_student');
$this->db->where($status_condition);
if(($from!='') && ($to!=''))
{
    $date_condition = "((ab_date BETWEEN '".$from."' AND '".$to."') or (as_date BETWEEN '".$from."' AND '".$to."'))";
    $this->db->where($date_condition);
}
$this->db->group_by('st_student.st_id');
$result=$this->db->get();