teacher——PDO分页

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 16-3-1
 * Time: 上午9:15
 */




header("content-type:text/html;charset=utf-8");


$page=$_GET['page'];


$url='mysql:host=localhost;dbname=ph28';
$user='root';
$pass='';
try{
    $dbh  = new  PDO ( $url ,  $user ,  $pass );
    $dbh->exec("set names 'utf8'");


    //获取总的记录数量
    $query=$dbh->query(" select count(*) as num from t_user ");
    $data=$query->fetch();
    $count=$data[0];
    //计算最大页码
    $maxpage=ceil($count/5);


    //判断获取的当前页面是否符合要求
    if($maxpage==0) return null;
    elseif($page<0) $page=1;
    elseif($page>$maxpage) $page=$maxpage;


    $query=$dbh->prepare("select u_name, u_sex from t_user limit ".(($page-1)*5).", 5");
    $query->execute();


    $data=$query->fetchAll();
    for($i=0; $i<count($data); $i++){
        echo $data[$i][0].",,".$data[$i][1];
        echo "<br><br>";
    }
    echo "总共有记录". $count."条 当前第" .$page ."页 总计". $maxpage ."页";
    if($page==1){
        echo " <a>首页</a> <a>上一页</a> ";
    }else{
        echo " <a href='pdopage.php?page=1'>首页</a> <a href='pdopage.php?page=".($page-1)."'>上一页</a> ";
    }
    if($page==$maxpage){
        echo " <a>下一页</a> <a>末页</a> ";
    }else{
        echo "<a href='pdopage.php?page=".($page+1)."'>下一页</a>  <a href='pdopage.php?page=$maxpage'>末页</a> ";
    }
}catch (PDOException $pe){
//    echo $pe->getMessage();
    echo '连接数据库失败，请检查...<br>';
}