<?
include "connect.php";
//$page = 1;
$sql = "select stockerid from orders ";
$record_num = "select count(*) as record_number from orders";
//定义每页记录数
$pagesize = 3;
//连接数据库求出总页数
$result = mssql_query($sql);
$record_count_num = mssql_num_rows($result);
$page_count_num = ceil($record_count_num/$pagesize);
//控制接收页数值的正确性
if($page>$page_count_num)
{
$page = $page_count_num;
}elseif($page<1)
{
$page = 1;
}
//以下输出内容
print '<table width=90% border="0" cellspacing="0" cellpadding="4" align=center>';
$rowi = ($page-1)*$pagesize+1;
for($i=0;$i<$pagesize;$i++){
print '<tr>';
if($rowi<=$record_count_num){
mssql_data_seek($result,$page);
$destdata = mssql_fetch_array($result);
print "<td width=80%>  <img src=\"../../images/grlc/star.gif\" width=\"8\" height=\"8\"> <a href='lcbl_detail.php?id=$news_id' target=_blank><font color=#003399>" . $destdata[0] . "</a></td>";
$rowi = $rowi+1;
}
print '</tr>';
}
print '</table>';
if ($page_count_num>1)
{
print "<form method=post action=\"$PHP_SELF?page=$pages\">";
print "<table border=0 cellspacing=\"0\" cellpadding=\"0\"><tr bgcolor='#ffffff'>";
if($page>1)
{ //页码比0大，表示有数据
print "<td width=80><a href=\"$PHP_SELF?page=1\"><font color=#EA005E>首页</font></a></td>";
}
else{
print "<td width=80><font color=#EA005E>首页</font></td>";
}
if($page>1){
$pages = $page - 1;
print "<td width=80><a href=\"$PHP_SELF?page=$pages$sql_condition\"><font color=#EA005E>上页</font></a></td>";
}
else{
print "<td width=80><font color=#EA005E>上页</font></td>";
}
if($page<$page_count_num){
$pages = $page + 1;
print "<td width=80><a href=\"$PHP_SELF?page=$pages$sql_condition\"><font color=#EA005E>下页</font></a></td>";}
else{
print "<td width=80><font color=#EA005E>下页</font></td>";
}
if($page<$page_count_num){
print "<td width=80><a href=\"$PHP_SELF?page=$page_count_num\"><font color=#EA005E>尾页</font></a></td>";
}
else{
print "<td width=80><font color=#EA005E>尾页</font></a></td>";
}
print "<td width=80><font color=#EA005E>页码($page/$page_count_num)</font></td>";
print "<td width=80 align = center><input type=input size=3 name=page> <input type=submit value=go name=go></td>";
print "</tr>";
print "</table>";
print "</form>";
}
?>
|
|