PHP简单的分页显示

控制器方法

public function pages(){
		$size = 8; //每页条数
		$p = isset($_GET['p'])?$_GET['p']:1; //初始页数
		$login = new Loginmodel();
		$count = $login->count('infos');  //总条数
		$page = ceil($count/$size);   //总页数
		//如果超过最小和最大页数,则重新赋值
		if($p>$page){
			$p=$page;
		}elseif($p==0){
			$p=1;
		}
		$data = $login->page('infos',$size,$p);  //
		include 'View/index/html/share.html';
	}

model方法

#分页
	public function page($table,$size,$p){
		return $this->query_page($table,$size,$p);
	}
#总条数
	public function count($table){
		return $this->query_count($table);
	}

封装的数据库方法

#分页
    public function query_page($table,$size,$p){
        $pagesize = ($p-1)*$size;
        $sql = "select * from $table order by id limit $pagesize,$size";
        $data = mysqli_query($this->link,$sql);
        $info = mysqli_fetch_all($data,MYSQLI_ASSOC);
        return $info;
    }
#总条数
    public function query_count($table){
        $sql = "select count(*) as count from $table";
        $data = mysqli_query($this->link,$sql);
        $info = mysqli_fetch_assoc($data);
        return $info['count'];
    }