获取与给定输入匹配的名称

Question

am using code as below.according to the review name the details are getting. what i require is if i give a particular word that is for example "san" for searching the names matching to that has to be displayed.that is sangee, santhosh,..... for you to understand example is facebook in which if we go to search and add some name it will be showing the names matching to that in the similar way we require the output for our app. the input should be dynamic. thanks

$this->db->select('reviewee_name');
$this->db->from('reviews');
$this->db->where('reviewee_name', $input['reviewee_name']);
$query = $this->db->get();

Answer 1

Simply change

$this->db->where('reviewee_name', $input['reviewee_name']);

Into

$this->db->like('reviewee_name', $input['reviewee_name']);

Don't do this

$this->db->like('reviewee_name', '%'. $input['reviewee_name'] .'%');

It creates another % inside %, like this

WHERE reviewee_name LIKE '%%reviewee_name%%'

For more information visit http://ellislab.com/codeigniter/user-guide/database/active_record.html