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中。其它數(shù)據(jù)庫有稍微不同的語法) $query?=?$this->db->get('test'); return?$query->result(); }