php - Codeigniter 分页和搜索问题

Question

我试图在一份报告中使用 Code-igniter Framework 提供分页和搜索关键字的便利。

下面是用于该目的的 Controller 代码:

$queryString="?start_date=".$values['start_date']."&end_date=".$values['start_date']."&keyword=".$values['keyword']."";
    if($this->uri->segment(3)){
      $offset=$this->uri->segment(3);   
       $config['base_url'] = base_url()."reports/mysearch_search/".$offset.$queryString;                    
    }else{
       $config['base_url'] = base_url()."reports/mysearch_search/".$queryString;
    }
    $query = $this->db->query("SELECT * FROM (`dlrReport`) WHERE LEFT(`res_submit_date`,10) >= '".$values['start_date']."' AND LEFT(`res_submit_date`,10) <= '".$values['end_date']."' AND (number LIKE '%".$values['keyword']."%' OR source LIKE '%".$values['keyword']."%')");            
    $config['total_rows']=$query->num_rows();            
    $config['per_page'] = 2;    
    $this->pagination->initialize($config); 
    $where = array('LEFT(res_submit_date,10) >=' =>   $values['start_date'],'LEFT(res_submit_date,10) <=' =>$values['end_date']);
    $this->db->where($where);
    $this->db->where("(number LIKE '%".$values['keyword']."%' OR source LIKE '%".$values['keyword']."%')");
    $res = $this->db->get('dlrReport', $config['per_page'], $this->uri->segment(3));
    $dlr['details']= $res->result();    
    $dlr['start_date']=$values['start_date'];   
    $dlr['end_date']=$values['end_date'];   
    $dlr['keyword']=$values['keyword'];         
    $this->load->view('mysearch',$dlr);

在无效的分页链接中获取下方链接:

http://Host/project/reports/mysearch_search/?start_date=2014-01-23&end_date=2014-01-23&keyword=/2

我希望分页链接中的网址如下:

http://Host/project/reports/mysearch_search/2?start_date=2014-01-23&end_date=2014-01-23&keyword=

我怎样才能得到正确的 Url 用于搜索目的？

Answer 1

这是 codeignter 本身的一个很好的例子。 Codeigniter Pagination检查这个。

默认情况下，codeigniter 期待这样的分页 url。

http://localhost/project/reports/mysearch_search/2014-01-23/2014-01-23/2

$start_date =$this->uri->segment(5);  
$end_date = $this->uri->segment(6);  
$keyword = $this->uri->segment(7);  

如果您需要这种 url，则必须更改

http://example.com/index.php?c=test&m=page&per_page=20

然后你必须更改以在配置文件中设置它

$config['enable_query_strings'] 设置为 TRUE