CodeIgniter Active Record 'like' ignoring 'where'

Question

riting a very simple search using like and have an option to omit options, however I find the like statement is making query ignore the where statement

$this->db->like('LOWER(location) OR LOWER(name)', strtolower($term));
$this->db->where('stage', 1);
$this->db->order_by("name", "asc"); 
$query = $this->db->get($this->user_table);
return $query->result();

Example of what the above produces with $term = "dublin";

SELECT * FROM (`users`) WHERE `stage` = 1 AND LOWER(location) OR LOWER(name) LIKE '%dublin%' ORDER BY `name` asc"

It still returns rows where 'stage' is not equal to 1.

Any ideas? Thank you!

look at this answer an alternative http://stackoverflow.com/questions/11023318/using-mysql-where-in-clause-in-codeigniter/11031431#11031431 — Muhammad Raheel, Jun 25 '12 at 10:50

score 7 · Accepted Answer · answered Jun 25 '12 at 10:58

7

$term = strtolower($term);
$this->db->where("(LOWER(location) LIKE '%{$term}%' OR LOWER(name) LIKE '%{$term}%')");

answered Jun 25 '12 at 10:58

P M

1,955
12
18

score 0 · Answer 2 · answered Dec 11 '14 at 16:09

0

$query = $this->db->query("SELECT id_alimento, nombre, unidad, energia_kcal FROM catalogo_alimentos WHERE LOWER(nombre) LIKE '%".$this->db->escape_like_str($search)."%'");
if($query != false){
  if ($query->num_rows() > 0) {
    return $query->result();
  }
}

answered Dec 11 '14 at 16:09

Rosel

1
1

Please provide some information here about why this is an answer. – Spencer Wieczorek Dec 11 '14 at 16:58

score -1 · Answer 3 · edited Mar 30 '14 at 06:39

-1

Substitute this for the query

$term = strtolower($term);
$this->db->where("stage= 1 AND (LOWER(location) LIKE '%{$term}%' OR LOWER(name) LIKE '%{$term}%')");

edited Mar 30 '14 at 06:39

mjhm

15,731
9
40
55

answered Mar 30 '14 at 05:46

user3460632

199
3

Please don't give code-only answers. Explain what your code does, and how does it fulfill OPs requirements. – Gaurang Tandon Mar 30 '14 at 06:23

CodeIgniter Active Record 'like' ignoring 'where'

3 Answers3

Linked