CODEWITHSUNDEEP
phpmysqlsqlcodeigniter
user3574766
user3574766

Reputation: 641

CodeIgniter 'where' not working

This is a search function I made, it gets the search term and displays fine. HM_Jobs has 3 options for JobStatus: Open, Accepted or Complete.

However the search is also pulling results from the Accepted and Complete rows when I run it, why isn't the WHERE statement stopping this from happening?

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(); 
}

Upvotes: 2

Views: 1353

Answers (2)

Bonik
Bonik

Reputation: 812

Try using the following query

function search_jobs($search)
{
    $query = $this->db->select('*')
                  ->from('HM_Jobs')
                  ->where('JobStatus','Open')
                  ->where("(`JobTitle` LIKE '%$search%' OR 
                            `JobDescription` LIKE '%$search%')",null,false)
                  ->get();
    return $query->result(); 
}

Upvotes: 1

Shijin TR
Shijin TR

Reputation: 7788

Try this 

 $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();

You can see your query executed by using echo $this->db->last_query()

Your query creates like

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

But the query you need require something like

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

Upvotes: 1

Related Questions