CI pagination, POST problem
Posted
by Gwood
on Stack Overflow
See other posts from Stack Overflow
or by Gwood
Published on 2010-04-10T16:40:43Z
Indexed on
2010/04/10
16:43 UTC
Read the original article
Hit count: 303
Okay, I am pretty new in CI and I am stuck on pagination. I am performing this pagination on a record set that is result of a query. Now everything seems to be working fine. But there’s some problem probably with the link. I am displaying 10 results per page. Now if the results are less than 10 then it’s fine. Or If I pull up the entire records in the table it works fine. But in case the result is more than 10 rows, then the first 10 is perfectly displayed, and when I click on the pagination link to get to the next page the next page displays the rest of the results from the query as well as, other records in the table. ??? I am confused.. Any help??
Here’s the model code I am using ....
function getTeesLike($field,$param) { $this->db->like($field,$param); $this->db->limit(10, $this->uri->segment(3)); $query=$this->db->get(‘shirt’); if($query->num_rows()>0){ return $query->result_array(); } }
function getNumTeesfromQ($field,$param) { $this->db->like($field,$param); $query=$this->db->get(‘shirt’); return $query->num_rows(); }
And here’s the controller code ....
$KW=$this->input->post(‘searchstr’); $this->load->library(‘pagination’); $config[‘base_url’]=‘http://localhost/cit/index.php/tees/show/’; $config[‘total_rows’]=$this->T->getNumTeesfromQ(‘Title’,$KW); $config[‘per_page’]=‘10’; $this->pagination->initialize($config); $data[‘tees’]=$this->T->getTeesLike(‘Title’,$KW); $data[‘title’]=‘Displaying Tees data’; $data[‘header’]=‘Tees List’; $data[‘links’]=$this->pagination->create_links(); $this->load->view(‘tee_res’, $data);
//What am I doing wrong here ???? Pls help ...
I guess the problem is with the $KW=$this->input->post(‘searchstr’); .. Because if I hard code a value for $KW it works fine. May be I should use POST differently ..but how do I pass the value from the form without POSTING it , its CI so not GET ... ??????
© Stack Overflow or respective owner