赫渤连历史文集:请看我写的为什么不能分页

来源:百度文库 编辑:杭州交通信息网 时间:2024/05/11 18:05:07
<?php
include_once('inc/conn.php');
$pagesize=10;//定义显示页数
$typeid=$_GET['typeid'];
$keywords=$_GET['keywords'];
$page=$_GET['page'];//获取PAGE的值
opendb();
$numrow=mysql_fetch_array(mysql_query("select count(ConsumerID) from consumer where $typeid like '%$keywords%'"));//得到总记录数
$numrows=$numrow[0];
closedb();
$pages=ceil($numrows/$pagesize);//得到总页数
if(!isset($page)){$page=1;}//如果PAGE为空则等于1
if($pages==0){$pages=0;}
if($page<=0) { $page=1; }
if ($page>$pages) { $page=$pages;}
if ($numrows<$pagesize) { $pagesize=$numrows; }
$offset=($page-1) * pagesize;
opendb();
$sql="select * from consumer where $typeid like '%$keywords%' limit $offset,$pagesize";
$query=mysql_query($sql);
while ($myrow=mysql_fetch_array($query)) { $i=0;
echo "<tr bgcolor=#F2F2F2>";
echo "<td height=20 align=center bgcolor=#F2F2F2><a href='showconsumerinfo.php?id=".$myrow[ConsumerID]."'>$myrow[ConsumerID]</a></td>";
echo "<td height=25 bgcolor=#F2F2F2 align=center title=$myrow[ConsumerName]>".substr($myrow[ConsumerName],0,16)."</td>";
echo "<td height=20 bgcolor=#F2F2F2 align=center>$myrow[Province]</td>";
echo "<td height=20 bgcolor=#F2F2F2 align=center>".$myrow[City]."</td>";
echo "<td align=center>$myrow[Post]</td>";
echo "<td align=center title=$myrow[Address]>".substr($myrow[Address],0,18)."</td>";
echo "<td align=center>$myrow[Phone]</td>";
echo "<td align=center><a href='editconsumerinfo.php?id=".$myrow[ConsumerID]."&action=saleser'>修改</a> </td>";
echo "</tr>";
$i++;
}
?>
<form method="get">
<tr align="center" bgcolor="#e1e1e1">
<td height="20" colspan="8" align="right"> 共有 <font color="red">
<?=$numrows?>
</font> 条记录 共<font color="red">
<?=$pages?>
</font> 页
<?
if ($page<>1) {
echo "<a href=$PHP_SELF?page=1&typeid=$typeid&keywords=$keywords>首页</a> "; }
if ($page>1) {
$upage=$page-1;
echo "<a href=$PHP_SELF?page=$upage&typeid=$typeid&keywords=$keywords>上一页</a> "; }
if ($page<$pages) { $npage=$page+1;
echo "<a href=$PHP_SELF?page=$npage&typeid=$typeid&keywords=$keywords>下一页</a> "; }
if ($page<>$pages) {
echo "<a href=$PHP_SELF?page=$pages&typeid=$typeid&keywords=$keywords>尾页</a> "; }
?>
当前<font color="red">
<?
echo "".$page."</font>/".$pages."" ;
closedb();
?>
</font> 页
  </td>
</tr></form>