<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>php+mysql,分页</title>
</head>
<body>
<?
//链接数据库
$conn= mysql_connect("localhost:3336", "root", "myoa888") or die("Could not connect: " . mysql_error());
//解决乱码问题:
@mysql_query("SET character_set_connection=gb2312, character_set_results=gb2312, character_set_client=binary",$conn);
//2.mysql_select_db()...选择数据表
mysql_select_db('TD_OA',$conn);
mysql_query( "set names 'gb2312'");
?>
<?
//计算总页数
$pagesize=4; //设置每一页显示的记录数
$rs=mysql_query("select count(*) from flow_run_attach",$conn); //取得记录总数$rs
$myrow = mysql_fetch_array($rs);
$numrows=$myrow[0];
//计算总页数
$pages=intval($numrows/$pagesize);
if ($numrows%$pagesize)//如果不能整除,页数加1
$pages++;
$pages;
//判断页数设置
if(isset($_GET["page"])){
$page=intval($_GET["page"]);
}
else{
$page=1;
}
//计算记录偏移量
$offset=$pagesize*($page-1);
$sql="select * from flow_run_attach order by SEQ_ID asc limit $offset,$pagesize";
//echo $sql."<br>";
$cursor=mysql_query($sql,$conn);
$i=0;
?>
<table border="1" bordercolor="#0033FF" align="center" width="80%">
<tr>
<td>序号</td>
<td>SEQ_ID</td>
<td>RUN_ID</td>
<td>ATTACHEMENT_ID</td>
<td>ATTACHEMENT_NAME</td>
</tr>
<?
while($myrow1 = mysql_fetch_array($cursor)){
$SEQ_ID=$myrow1["SEQ_ID"];
$RUN_ID=$myrow1["RUN_ID"];
$ATTACHEMENT_ID=$myrow1["ATTACHMENT_ID"];
$ATTACHEMENT_NAME=$myrow1["ATTACHMENT_NAME"];
?>
<tr>
<td><?=++$i?></td>
<td><?=$SEQ_ID?></td>
<td><?=$RUN_ID?></td>
<td><?=$ATTACHEMENT_ID?></td>
<td><?=$ATTACHEMENT_NAME?></td>
</tr>
<?
}
?>
</table>
<div align="center">共有<?=$pages?>页 <?=$page?>/<?=$pages?>
<?
for($i=1;$i<$page;$i++){//
echo "<a href='index.php?page=".$i."'>[".$i ."]</a> ";
}
echo "[".$page."]";
for ($i=$page+1;$i<=$pages;$i++){echo "<a href='index.php?page=".$i."'>[".$i ."]</a>";}
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$pages;
if ($page>1)
{echo "<a href='index.php?page=".$first."'>首页</a> ";
echo "<a href='index.php?page=".$prev."'>上一页</a> ";}
if ($page < $pages)
{echo "<a href='index.php?page=".$next."'>下一页</a> ";
echo "<a href='index.php?page=".$last."'>尾页</a> ";
}
?>
</div>
</body>
</html>