CI(6) 分页
扫描二维码
随时随地手机看文章
load->model('test_model'); $count = $this->test_model->count(); $config['total_rows'] = $count; $config['per_page'] = 5; $config['num_links'] = 3; $config['base_url'] ='/ci/index.php/pagetest/index'; $this->load->library('pagination'); $this->pagination->initialize($config); echo $this->pagination->create_links(); var_dump($this->test_model->selectLimit($id,$config['per_page'])); } } ?>
model:
public function selectLimit($start,$end) { $this->db->select('*'); $this->db->order_by('id'); $this->db->limit($end,$start); //注意哦 // 生成: LIMIT $start, $end (仅限MySQL中。其它数据库有稍微不同的语法) $query = $this->db->get('test'); return $query->result(); }