Welcome Guest, Not a member yet? Register   Sign In
Pagination problem when search in other of pagination link ?
#1

[eluser]ilove-ci[/eluser]
Hi, I have some code

///controller
function index()
{


$this->load->library('pagination');
$this->load->model('member_model','member');

if ($this->uri->segment(3) !== FALSE)
{
$offset = $this->uri->segment(3);
}
else
{
$offset='0';
}

if($this->input->post('searchterm'))

{
$session_data = array('search_query'=>$this->input->post('searchterm'));
$this->session->set_userdata($session_data);
}


$config['base_url'] = base_url().'index.php/find/index/';
$config['per_page'] = '10';
$config['total_rows'] = $this->member->count_rows_by_keyword($this->session->userdata('search_query'));
$config['first_link'] = 'first';
$config['last_link'] = 'last';
$config['full_tag_open'] = '<p>';
$config['full_tag_close'] = '</p>';
$config['uri_segment'] = '2';
$this->pagination->initialize($config);

$data['page_links'] = $this->pagination->create_links();

$data['members'] = $this->member->search($this->session->userdata('search_query'),$offset,$config['per_page'] );


$data['search_query'] = $this->session->userdata('search_query');
$data['rows'] = $config['total_rows'];


$this->load->view('find/index',$data);


}

//Model

function search($term,$offset,$num)
{
//$term = $this->db->escape($term);

$data = array();


if($term!='')
{
$this->db->select('*');
$this->db->like('name',$term);
$this->db->orlike('lastname',$term);
$this->db->orlike('address',$term);
$this->db->orlike('province',$term);
$this->db->orlike('part_of_thailand',$term);
$this->db->orlike('business_name',$term);
$this->db->orlike('old_academy',$term);

}

//$this->db->orderby('name','asc');

$this->db->limit($num,$offset);

$query = $this->db->get('members');

return $query;

}


/////////////////////////////////////
when I go to page 2 or 3 then search again, the record found but uri not correct ( I think it should redirect to segment 0)

What should I do????


Messages In This Thread
Pagination problem when search in other of pagination link ? - by El Forum - 01-18-2009, 10:34 AM



Theme © iAndrew 2016 - Forum software by © MyBB