<?php
function fenye($total,$pagesize)
{
if($total % $pagesize == 0)
{
return $total/ $pagesize;
}else
{
if(($total / $pagesize)*$pagesize > $total )
{
return ceil($total/ $pagesize )+1;
}else
{
return ceil($total/ $pagesize);
}
}
}
echo"<center><table align=center border=1 bordercolor=red >";
$conn = @mssql_connect("localhost","sa","");
if(!$conn)
{
echo "数据库连接不成功";
exit;
}
mssql_select_db("pubs",$conn);
$query = "select * from authors";
$result = mssql_query($query);
$rows = @mssql_num_rows($result);
$pagesize = 3;
$pagecount = fenye($rows,$pagesize);
if(!isset($_REQUEST['page']))
{
$star = 0;
}elseif($_REQUEST['page']<=$pagecount)
{
$star = ($_REQUEST['page']-1)*$pagesize;
}elseif($_REQUEST['page']==1)
{
$star = 0;
}
for($i = $star; $i < (($star +$pagesize)>$rows?$rows:($star +$pagesize)); $i++)
{
@mssql_data_seek($result,$i);
$date=@mssql_fetch_array($result);
$id = $date['au_id'];
$name = $date['au_lname'];
$fname = $date['au_fname'];
echo"<tr><td>".$id."</td><td>".$name."</td><td>".$fname."</td></tr>";
}
echo("</table><br>");
for($i = 1; $i <= $pagecount;$i++)
{
echo"<a href=userinfo.php?page=".$i.">".$i."</a> ";
}
mssql_free_result($result);
mssql_close($conn);
echo"</center>";
?>
function fenye($total,$pagesize)
{
if($total % $pagesize == 0)
{
return $total/ $pagesize;
}else
{
if(($total / $pagesize)*$pagesize > $total )
{
return ceil($total/ $pagesize )+1;
}else
{
return ceil($total/ $pagesize);
}
}
}
echo"<center><table align=center border=1 bordercolor=red >";
$conn = @mssql_connect("localhost","sa","");
if(!$conn)
{
echo "数据库连接不成功";
exit;
}
mssql_select_db("pubs",$conn);
$query = "select * from authors";
$result = mssql_query($query);
$rows = @mssql_num_rows($result);
$pagesize = 3;
$pagecount = fenye($rows,$pagesize);
if(!isset($_REQUEST['page']))
{
$star = 0;
}elseif($_REQUEST['page']<=$pagecount)
{
$star = ($_REQUEST['page']-1)*$pagesize;
}elseif($_REQUEST['page']==1)
{
$star = 0;
}
for($i = $star; $i < (($star +$pagesize)>$rows?$rows:($star +$pagesize)); $i++)
{
@mssql_data_seek($result,$i);
$date=@mssql_fetch_array($result);
$id = $date['au_id'];
$name = $date['au_lname'];
$fname = $date['au_fname'];
echo"<tr><td>".$id."</td><td>".$name."</td><td>".$fname."</td></tr>";
}
echo("</table><br>");
for($i = 1; $i <= $pagecount;$i++)
{
echo"<a href=userinfo.php?page=".$i.">".$i."</a> ";
}
mssql_free_result($result);
mssql_close($conn);
echo"</center>";
?>