<?php
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>';
}
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>';
}