I am just trying to do the basic search in the codeigniter.
controller
$brand = $this->uri->segment(2);
$brand = utf8_decode(urldecode($brand));
$search['type'] = 5;
$search['title'] = $brand;
$this->data['deal_brand'] = $this->manage_m->search($search);
print_r($this->data['deal_brand']);
Model
function search($search)
{
$query = $this->db->get_where('manage', $search);
return $query->first_row();
}
the search works for the following
www.mydomain.com/deal/audi
and not works for
www.mydomain.com/deal/citroën
When i get the last query it prints
SELECT * FROM (`manage`) WHERE `type` = 5 AND `title` = 'citroën'
query seems correct but not working. But it works when i copy this and run in the mysql server or like static query like below
$query = $this->db->query("SELECT * FROM (`manage`) WHERE `type` = 5 AND `title` = 'citroën'");
print_r($query->result());
Thanks to all