<?php
extract($_REQUEST);
$n=0;
$query=mysql_query("select count(*) as sm from jiaoshi");
mysql_query("set names 'GB2312'");
$row=mysql_fetch_array($query);
$count=$row['sm'];
if(empty($offset))
{$offset=0;}
/*echo $offset;*/
$where = (! isset($surplus)) ? '' : " where surplus='$surplus'";
$query=mysql_query("select * from jiaoshi $where order by id asc limit $offset,$list_num") or die ("fail");
mysql_query("set names 'GB2312'");
while($row=mysql_fetch_array($query)){
if(($n%2)!='0'){
echo "<tr bgcolor=#CDE6C7>";}
else{
echo "<tr bgcolor=#FFFFFF>";
}
if($row['surplus']==0)
$ss="不可选";
else $ss="可选";
echo"
<td height='22' class='STYLE1'> <div align='center'> ".$row['id']." </div></td>
<td height='22' class='STYLE1'> <div align='center'> ".$row['subject']." </div></td>
<td height='22' class='STYLE1'> <div align='center'> ".$row['teacher']." </div></td>
<td height='22' class='STYLE1'> <div align='center'> ".$row['zhicheng']." </div></td>
<td height='22' class='STYLE1'> <div align='center'> ".$row['number']." </div></td>
<td height='22' class='STYLE1'> <div align='center'> ".$row['xuehao']." </div></td>
<td height='22' class='STYLE1'> <div align='center'>".$ss."</div></td>
<td height='22' class='STYLE1'> <div align='center'> <a href=xiangxiziliao.php?id=".$row['id'].">查看</a></div></td>
</tr> ";
$n++;
}
?>
extract($_REQUEST);
$n=0;
$query=mysql_query("select count(*) as sm from jiaoshi");
mysql_query("set names 'GB2312'");
$row=mysql_fetch_array($query);
$count=$row['sm'];
if(empty($offset))
{$offset=0;}
/*echo $offset;*/
$where = (! isset($surplus)) ? '' : " where surplus='$surplus'";
$query=mysql_query("select * from jiaoshi $where order by id asc limit $offset,$list_num") or die ("fail");
mysql_query("set names 'GB2312'");
while($row=mysql_fetch_array($query)){
if(($n%2)!='0'){
echo "<tr bgcolor=#CDE6C7>";}
else{
echo "<tr bgcolor=#FFFFFF>";
}
if($row['surplus']==0)
$ss="不可选";
else $ss="可选";
echo"
<td height='22' class='STYLE1'> <div align='center'> ".$row['id']." </div></td>
<td height='22' class='STYLE1'> <div align='center'> ".$row['subject']." </div></td>
<td height='22' class='STYLE1'> <div align='center'> ".$row['teacher']." </div></td>
<td height='22' class='STYLE1'> <div align='center'> ".$row['zhicheng']." </div></td>
<td height='22' class='STYLE1'> <div align='center'> ".$row['number']." </div></td>
<td height='22' class='STYLE1'> <div align='center'> ".$row['xuehao']." </div></td>
<td height='22' class='STYLE1'> <div align='center'>".$ss."</div></td>
<td height='22' class='STYLE1'> <div align='center'> <a href=xiangxiziliao.php?id=".$row['id'].">查看</a></div></td>
</tr> ";
$n++;
}
?>
$pages=ceil($count/$list_num);
echo "<table width=740 border=0 cellspacing=0 cellpadding=0 align=center class='text'>
<tbody>
<tr>
<td width='190'><font color='#ff0000'>目前共有".$count."条记录</font> </td>
<td width='205'>共".$pages."页</td>";
if($offset){
$preoffset=$offset-$list_num;
print "<td width='170'><a href=\"?offset=$preoffset\">上一页</a></td>";}
else {
echo "<td width='170'>上一页</td>";
}
$newoffset=$offset+$list_num;
if(($pages!=0)&&(($newoffset/$list_num)!=$pages))
{
print("<td width='170'><a href=\"?offset=$newoffset\">下一页</a></td>");
}
else{ echo "<td width='170'>下一页</td>";}
$pageno=($offset/$list_num)+1;
echo "<td width='112' class=text>第<input class=text type='text' size='4'value=".$pageno." readonly>页</td>
<td width='4'> </td></tr>
</table>";
?>
你这里的总页数是$pages,那么尾页数也是$pages
你这个应该要计算要清楚,如果有小数点的要+1的
$pages=ceil($count/$list_num); 这里这个总页数是正确的,不过要判断一下$list_num不能为0哦
有定义了就好,只是你怎么会计算出小数了呢?ceil这个可是取整数的啊
你这个干吗还要算一次呢?
你那个文本框里默认的不应该是当前页么?就算不是当前页,这里不应该重新算吧?就算要重新算,你也要取整数啊
注释的内容,如下:
<http://www.phpobject.net/> * @copyright :Copyright 2006 feifengxlq * @license:version 2.0 * @create:2006-5-31 * @modify:2006-6-1 * @modify:feifengxlq 2006-11-4 * description:超强分页类,四种分页模式,默认采用类似baidu,google的分页风格。 * 2.0增加功能:支持自定义风格,自定义样式,同时支持PHP4和。