php - CodeIgniter 'where' 不工作

Question

这是我制作的搜索功能，它获取搜索词并显示正常。 HM_Jobs JobStatus 有 3 个选项: Open , Accepted或 Complete .

然而，搜索也从 Accepted 中提取结果和 Complete当我运行它时，为什么 WHERE 语句不能阻止这种情况发生？

function search_jobs($search) //This function checks a search term against the job title and description.
{
    $this->db->select('*');
    $this->db->from('HM_Jobs');
    $this->db->like('JobTitle',$search);
    $this->db->or_like('JobDescription',$search);
    $this->db->where('JobStatus','Open');  

    $query = $this->db->get();
    return $query->result(); 
}

Answer 1

试试这个

 $this->db->select('*');
 $this->db->from('HM_Jobs');
 $this->db->where("(JobTitle LIKE '$search' OR JobDescription LIKE '$search')"  );
 $this->db->where('JobStatus','Open'); 
 $query = $this->db->get();

您可以看到使用 echo $this->db->last_query() 执行的查询

您的查询创建类似

where JobTitle like 'search' or JobDescription  like 'search' and JobStatus='Open'

但是你需要的查询需要类似的东西

  where (JobTitle like 'search' or JobDescription  like 'search') and JobStatus='Open'