<?php
header("Content-type: text/html; charset=gb2312");
$mypdo=new pdo("mysql:host=localhost;dbname=news;","root","");
$mypdo->query("set names gb2312");

if(!isset($_GET['pageno'])){
 $pageno=1;//当前页
}else{
 $pageno=$_GET['pageno'];
}

$pagesize=20;//单页容量
$stmt=$mypdo->query("selects id from news");
$rscount=$stmt->rowCount();//总记录数

$pages=ceil($rscount/$pagesize);//总页数

$spage=($pageno-1)*$pagesize;
$sql="selects * from news order by id asc limit $spage,$pagesize";
$stmt=$mypdo->query($sql);

$rows=$stmt->fetchAll(PDO::FETCH_ASSOC);
foreach($rows as $rs){
 echo "<br>".$rs['id']."&nbsp;&nbsp;".$rs['title'];
}

echo "<br><br><br><br>";

for($i=1;$i<=$pages;$i++){
   echo "<a href=index.php?pageno=$i>$i</a>&nbsp;";
}

?>