一个PHP+MSSQL分页的例子
2024-05-04 22:15:30
供稿：网友
<?
require "config.php";
dl("extensions/php_mssql70.dll");
if (!isset($page)) { $page=1; }
if ($page<=0) { $page=1; }
$db=mssql_connect($local,$user,$pass);
mssql_select_db($name,$db);
$query=mssql_query("select count(*) as date from news",$db);
$query=mssql_fetch_array($query);
$pages=ceil($query[0]/$userperpage);
if ($page>$pages) { $page=$pages;}
if ($query[0]<$userperpage) { $userperpage=$query[0]; }
$dangqian=($page-1)*$userperpage;
echo "<title>News</title>";
echo "<style type=text/css>/n";
echo "<!--/n";
echo "A{text-decoration:none}/n";
echo "A:hover {color:blue;; text-decoration: underline}/n";
echo "td { font-size: 9pt}/n";
echo "--></style>/n";
echo "<div align=center><center>/n";
echo "<table border=0 width=100% cellspacing=0 cellpadding=0 height=19/n";
echo "<tr>";
echo " <td width=52% colspan=5><img src=xw.gif width=100%></td></tr>/n";
echo "<tr>";
echo " <td width=52% height=19 valign=bottom bgcolor=#B5C6B0><p align=center><font/n";
echo " color=#408080>新闻标题</font></td>/n";
echo " <td width=14% height=19 valign=bottom align=center bgcolor=#B5C6B0><font/n";
echo " color=#408080>发表日期</font></td>/n";
echo " <td width=19% height=19 valign=bottom align=center bgcolor=#B5C6B0><font/n";
echo " color=#408080>发表部门</font></td>/n";
echo " <td width=7% height=19 valign=bottom align=center bgcolor=#B5C6B0><font/n";
echo " color=#408080>阅读</font></td>/n";
echo " <td width=8% height=19 valign=bottom align=center bgcolor=#B5C6B0><font/n";
echo " color=#408080>图像</font></td>/n";
echo " </tr>/n";
echo "</table>/n";
echo "</center></div>/n";
echo "<div align=center><center>/n";
echo "<table border=0 width=100% cellspacing=0 cellpadding=0 height=19>/n";
$db=mssql_connect($local,$user,$pass);
mssql_select_db($name,$db);
