Codeigniter searches data

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

Published by baliwebmaker

Bali Web Designer and Web Developer - PHP, MYSQL { Joomla Framework }