function view(){
 
	$this->load->library('pagination');
 
	$total_seg = $this->uri->total_segments();
	$offset = $this->uri->segment(3, '');
	$uri_seg = 3;
 
	if($total_seg > 3){
 
		$uri_str = substr($this->uri->uri_string(),1);
		$uri_arr = explode("/", $uri_str);
		$total_seg = count($uri_arr);
		$uri_seg = $total_seg+1;
 
		// $this->terms is defined as an empty array in the constructor
		$this->terms = $this->uri->uri_to_assoc();
 
		if(($total_seg % 2) > 0){
 
			$this->terms = array_slice($this->terms, 0 , (floor($total_seg/2)-1));
			$offset = $this->uri->segment($total_seg, '');
			$uri_seg = $total_seg;
		}
 
	}
 
	$total = $this->The_model->count_all($this->terms);
	$data['results'] = $this->The_model->get_results($this->terms, $this->results_per_page, $offset);
 
	$keys = $this->uri->assoc_to_uri($this->terms);
	$this->terms = array();
 
	$config['base_url'] = base_url() . 'controller/view/' . $keys;
	$config['total_rows'] = $total;
	$config['per_page'] = $this->results_per_page;
	$config['uri_segment'] = $uri_seg;
	$config['num_links'] = 3;
 
	$this->pagination->initialize($config);
 
	$data['page_links'] = $this->pagination->create_links();
 
	$this->load->view('the_view', $data);
 
}

function get_results($terms = array(), $limit, $offset){
 
	$this->db->select('table.*');
 
	if(count($terms) > 0){
 
		if(array_key_exists('what', $terms) && array_key_exists('where', $terms)){
 
			$ww = " table." . $terms['where'] . " LIKE('%" . $terms['what'] . "%') ";
			$this->db->where($ww, NULL, FALSE);
 
		}
 
		if(array_key_exists('from', $terms)){
 
			// the "from" field type is timestamp
			$from = " table.from >= " . strtotime($terms['from']) . " ";
			$this->db->where($from, NULL, FALSE);
 
		}
 
		if(array_key_exists('to', $terms)){
 
			// the "to" field type is timestamp
			$to = " table.to <= " . strtotime($terms['to']) . " ";
			$this->db->where($to, NULL, FALSE);
 
		}
 
	}
 
	$this->db->order_by('table.id', 'DESC'); 
	$this->db->limit($limit, $offset);
	$query = $this->db->get('table');
 
	if($query->num_rows() > 0){
 
		return $query->result();
 
	}
	return FALSE;
 
}

function count_all($terms = array()){
 
	$this->db->select('table.id');
 
	if(count($terms) > 0){
 
		if(array_key_exists('what', $terms) && array_key_exists('where', $terms)){
 
			$ww = " table." . $terms['where'] . " LIKE('%" . $terms['what'] . "%') ";
			$this->db->where($ww, NULL, FALSE);
 
		}
 
		if(array_key_exists('from', $terms)){
 
			$from = " table.from >= " . strtotime($terms['from']) . " ";
			$this->db->where($from, NULL, FALSE);
 
		}
 
		if(array_key_exists('to', $terms)){
 
			$to = " table.to <= " . strtotime($terms['to']) . " ";
			$this->db->where($to, NULL, FALSE);
 
		}
 
	}
 
	$query = $this->db->get('table');
 
	return $query->num_rows();
 
}