CodeIgniter 搜索分页有点问题,帮忙看下
我的查询条件比较多,所以可能稍微显得长了点,分页是可以用,但是点击下一页,跳转到第二页的时候,下面的当前页并不是第二页!请指教。
主要问题就是,点击下一页的时候,已经跳转到下一页,但是当前页显示不正确!控制器
- PHP code
function people_daozhen($askdate,$askdate2,$name,$age,$age2,$phone,$sex,$zxjb,$comefrom,$area){ if(!empty($_POST['askdate'])){ $data ['askdate']=$_POST['askdate']; } if(!empty($_POST['askdate2'])){ $data ['askdate2']=$_POST['askdate2']; } if(!empty($_POST['name'])){ $data ['name']=$_POST['name']; } if(!empty($_POST['age'])){ $data ['age']=$_POST['age']; } if(!empty($_POST['age2'])){ $data ['age2']=$_POST['age2']; } if(!empty($_POST['phone'])){ $data ['phone']=$_POST['phone']; } if(!empty($_POST['sex'])){ $data ['sex']=$_POST['sex']; } if(!empty($_POST['zxjb'])){ $data ['zxjb']=$_POST['zxjb']; } if(!empty($_POST['comefrom'])){ $data ['comefrom']=$_POST['comefrom']; } if(!empty($_POST['area'])){ $data ['area']=$_POST['area']; } $this->load->helper ( 'url' ); $this->load->database(); $this->load->library ( 'pagination' ); $config ['per_page'] = '10'; $config ['base_url'] = base_url(). 'index.php/people/people_daozhen/'.$askdate.'/'.$askdate2.'/'.$name.'/'.$age.'/'.$age2.'/'.$phone.'/'.$sex.'/'.$zxjb.'/'.$comefrom.'/'.$area; $this->load->model ( 'people_mdl','',TRUE ); $data ['datalist'] = $this->people_mdl->people_list2 ( $config ['per_page'], $this->uri->segment ( 13 ) ,$askdate,$askdate2,$name,$age,$age2,$phone,$sex,$zxjb,$comefrom,$area); $config ['total_rows'] =$this->people_mdl->people_sum2($askdate,$askdate2,$name,$age,$age2,$phone,$sex,$zxjb,$comefrom,$area); $config['uri_segment'] = 3; $config ['full_tag_open'] = ''; $config ['full_tag_close'] = '
'; $config ['first_link'] = '首页'; $config ['first_tag_open'] = '
模型
- PHP code
function people_list2($per_nums, $start_position,$askdate,$askdate2,$name,$age,$age2,$phone,$sex,$zxjb,$comefrom,$area){ if($askdate!=0){ $this->db->where('askdate >=',$askdate); } if($askdate2!=0){ $this->db->where('askdate db->like('username',$name); } if($age!=0){ $this->db->where('age >=',$age); } if($age2!=0){ $this->db->where('age db->like('phone',$phone); } if($sex!=0){ $this->db->where('sex',$sex); } if($zxjb!=0){ $this->db->where('zxjb',$zxjb); } if($comefrom!=0){ $this->db->where('comefrom',$comefrom); } if($area!=0){ $this->db->where('area',$area); } if($askdate!=0){ $this->db->where('askdate >=',$askdate); } $this->db->order_by("pid", "desc"); $query = $this->db->get ($_SESSION['user']->table, $per_nums, $start_position ); $datas['array']=$query->result_array(); $datas['rows']=$query->num_rows(); return $query->result_array(); } function people_sum2($askdate,$askdate2,$name,$age,$age2,$phone,$sex,$zxjb,$comefrom,$area){ if($askdate!=0){ $this->db->where('askdate >=',$askdate); } if($askdate2!=0){ $this->db->where('askdate db->like('username',$name); } if($age!=0){ $this->db->where('age >=',$age); } if($age2!=0){ $this->db->where('age db->like('phone',$phone); } if($sex!=0){ $this->db->where('sex',$sex); } if($zxjb!=0){ $this->db->where('zxjb',$zxjb); } if($comefrom!=0){ $this->db->where('comefrom',$comefrom); } if($area!=0){ $this->db->where('area',$area); } $query = $this->db->get ($_SESSION['user']->table); return $query->num_rows(); }