Been playing for awhile with codeigniter, i decided to convert some of my project website which was built on joomla to codeigniter, while it is challenging i found some difficulties in porting the site. One of the problem is when is use active record function like(), it seem this function is only working if you query a word only.
For example if you search “bali” on sentence “bali update” it will return true but when i search “bali update” it return false.
The work around is to use php function rawurldecode
$search = rawurldecode( $this->input->post('search') ); $this->db->like('search', $search); $rows = $this->db->get('category')->result_array();