cara membuat pencarian dengan database yang sudah ada

 class Artikel_model extends Model{
   var $_table = 'artikel';
 
   //search di judul, isi, dan ringkasan
   function _search_query($keyword){
      $tokens   = explode(' ', trim($keyword));
 
      foreach($tokens as $token){
         $token = trim($token);
         if(! $token)
            continue;
         $this->db->or_like('judul', $token)
               ->or_like('isi', $token)
               ->or_like('ringkasan', $token);
      }
 
      $this->db->from($this->_table);
      return $this->db;
   }
 
   function search($keyword, $offset, $limit){
      $db   = $this->_search_query($keyword);
      return $db->limit($limit)
            ->offset($offset)
            ->get()->result();
   }
 
   function count_search($keyword){
      $db   = $this->_search_query($keyword);
      return $db->count_all_results();
   }
}
 
class Artikel extends Controller{
   function search(){
      // . . . . . . . . . . . . . . . . . . . .
      //preproses, bla bla bla bla
      // . . . . . . . . . . . . . . . . . . . .
      $results   = $this->artikel_model->search($keyword, $offset, $limit);
      $total      = $this->artikel_model->count_search($keyword);
      // . . . . . . . . 
      $this->load->helper('url');
      $baseurl   = site_url('artikel/search') . '/' ;
 
      $cfg   = array(
         'base_url' => $base_url,
         'per_page' => $limit,
         'total_rows'] => $total
      );
      $this->load->library('pagination', $cfg);
      $pagination = $this->pagination->create_links();
      // . . . . . . . . . . . . . . . . . . . .
      // . . . . . . . . . . . . . . . . . . . .
 
      $data['result']   = $results;
      $data['pagination'] = $pagination;
      $this->load->view('search_result', $data);
   }
}