CI(6) 分頁(yè)
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ù)庫(kù)有稍微不同的語(yǔ)法)
$query?=?$this->db->get('test');
return?$query->result();
}




