Controller:
function __construct() { parent::__construct(); $this->load->library('page_smart'); $this->load->model('Admin/user_index_data'); $this->load->helper('url'); } //用户列表 function user_list() { $data['user_list']=$this->user_index_data->select_user(); $this->load->view('AdminLogin/user_index/user_list',$data); } //角色列表 function role_list($page) { $config['page']=$page; $config['rows']=1; $config['pagenav']=null; $config['page_size']=$this->user_index_data->select_role_sum(); $page_rst=$this->page_smart->page_do($config); $data['role_list']=$this->user_index_data->select_role($page_rst['select_from'],$page_rst['select_limit']); $data['page_list']=$page_rst['pagenav']; $this->load->view('AdminLogin/user_index/role_list',$data); }
Model:
function __construct() { //装载日期辅助函数 $this->load->helper('date'); //装载数据库函数 $this->load->database(); } /********************* 查询数据部分 **********************/ //查询所有用户数据 function select_user(){ $query=$this->db->query("select id,useranme,password,name,email,mobile_phone,(select role_name from w3a_role where role_id=purview) purview from w3a_user"); return $query->result_array(); } //查询所有的角色数据 function select_role($total,$offset){ $sql="select * from w3a_role limit $total,$offset"; $query=$this->db->query($sql); return $query->result_array(); } function select_role_sum(){ $query=$this->db->get('w3a_role'); return $query->num_rows(); }
分页类:
<?php if (!defined('BASEPATH')) exit('No direct script access allowed'); class Page_smart{ public function Page_do($config = array()) { if (count($config) > 0) { foreach ($config as $key => $val) { if (isset($this->$key)) { $this->$key = $val; } } } $page=$config['page']; $page_size=$config['page_size']; $pagenav=$config['pagenav']; $rows=$config['rows']; $page_count = ceil($rows/$page_size); if($page <= 1 || $page == '') $page = 1; if($page >= $page_count) $page = $page_count; $select_limit = $page_size; $select_from = ($page - 1) * $page_size; $pre_page = ($page == 1)? 1 : $page - 1; $next_page= ($page == $page_count)? $page_count : $page + 1 ; $pagenav .="<div class='pagination pagination-right'>"; $pagenav .="<ul><li><a href='1'>«</a></li>"; for($i=1;$i<=$page_count;$i++){ if($i==$page) { $pagenav.="<li><a href='$i'>$i</a></li>"; } else { $pagenav.="<li><a href='$i'>$i</a></li>"; } } $pagenav .= "<li><a href='$i'>»</a></li><ul></div>"; $page_result['pagenav']=$pagenav; $page_result['select_limit']=$select_limit; $page_result['select_from']=$select_from; return $page_result; } } /* End of file Someclass.php */ ~
求解释。。。