CI(6) 分页

最新推荐文章于 2022-06-06 11:35:03 发布

代码修行者

最新推荐文章于 2022-06-06 11:35:03 发布

阅读量727

点赞数

分类专栏：框架之codeigniter 文章标签： php学习记录框架 CI codeigniter

本文链接：https://blog.csdn.net/xiaocabc/article/details/12911431

版权

框架之codeigniter 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

<?php
	class Pagetest extends CI_Controller
	{
		public function index($id=NULL)
		{
			$this->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();
		}