php CI架構學習筆記-分頁實現程式

舉個按關鍵詞搜尋結果分頁的例子，
1.視圖HTML

代碼如下	複製代碼
<div id="body"> <form action="/index.php/search/index/" method="get"> <p>請輸入書名、作者、出版社中的一個或多個來查詢。</p> <p><input type="text" name="s" value="" size="64" /> <input type="submit" value="搜尋" /></p> </form> </div>

即表單提交到名叫search的controller和名叫index的方法， 其中包含了一些動態參數，不是純列表，故相對比較複雜，後面會提到。

代碼如下

複製代碼

public function index() { $keyword = $this->input->get ( 's' ); $offset = $this->input->get ( 'offset' ); if (empty ( $offset )) { $offset = 0; } if (! empty ( $keyword )) { $this->load->model ( 'book_model' ); $this->load->library ( 'pagination' ); $per_page = 10; $config ['num_links'] = 5; $config ['base_url'] = '/index.php/' . $this->router->class . '/' . $this->router->method . '/?s=' . $keyword; $config ['per_page'] = $per_page; $config ['total_rows'] = $this->Book_Model->find_by_name ( $keyword, NULL, NULL, true ); $config ['page_query_string'] = false; $config ['query_string_segment'] = 'offset'; //重新定義記錄起始位置的參數名，預設為per_page $this->pagination->initialize ( $config ); $data ['books'] = $this->Book_Model->find_by_name ( $keyword, $per_page, $offset ); $this->load->view ( 'search', $data ); } else { $this->load->view ( 'search' ); } }

因為config.php中預設的enable_query_strings是false, 起始位置始終在最後，這樣出來的結果類似/index.php/search/index/?s=中國/10,頁碼取不到，需要將此配置改為false;

3.模型

 

代碼如下

複製代碼

public function find_by_name($name, $per_page=0, $offset = 0, $is_total = false) { if ($is_total) {//總數 $query = $this->db->query ( "select count(id) as cnt from {$this->_book} where book_name like '%{$name}%'" ); if ($query->num_rows () > 0) { $row = $query->row (); $ret = $row->cnt; } }else{//列表 $query = $this->db->query ("select * from {$this->_book} where book_name like '%{$name}%' limit {$offset}, {$per_page}"); $ret = $query->result (); } return $ret; }