now_bill_page.inc.php

来自「程序脚本为PHP+MYSQL」· PHP 代码 · 共 47 行

<?php
function  num_page()
{
global $conn;
$pagesize=1;
$sqlcpage=mysql_query("select count(*) from results",$conn);
$myrow=mysql_fetch_array($sqlcpage);
$numrows=$myrow[0];
$pages=intval($numrows/$pagesize);
if ($numrows%$pagesize) $pages++;
if (isset($_GET['page'])) 
{ 
$page=intval($_GET['page']);
}
else
{
$page=1;
}
$offset=$pagesize*($page - 1); 
$sqlpage=mysql_query("select * from results order by ID desc limit $offset,$pagesize",$conn); 
$fp="";					
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$pages;
while($rowpage=mysql_fetch_array($sqlpage))
 {
  $pg="&nbsp;<b>".$rowpage["dates"]."&nbsp;期&nbsp;".substr($rowpage["open_date"],5)."</b>";
  $page_date=$rowpage["dates"];
 }
if ($page>1)
{
 echo "<a href='".$fp."?page=".$prev."&dates=".$page_date."' class='awnoline'><strong><<</strong></a>";
}else
{
 echo "<strong><<</strong>";
}
 echo $pg;
if ($page<$pages)
{
  echo "<a href='".$fp."?page=".$next."&dates=".$page_date."' class='awnoline'><strong>>></strong></a>";
 } else
 {
  echo "<strong>>></strong>";
 }
}
?>