一個PHP+MSSQL分頁的例子

<?
require “config.php(做為現在的主流開發語言)“;
dl(“extensions/php(做為現在的主流開發語言)_mssql(WINDOWS平臺上強大的數據庫平臺)70.dll”);
if (!isset($page)) { $page=1; }
if ($page<=0) { $page=1; }
     $db=mssql(WINDOWS平臺上強大的數據庫平臺)_connect($local,$user,$pass);
     mssql(WINDOWS平臺上強大的數據庫平臺)_select_db($name,$db);
     $query=mssql(WINDOWS平臺上強大的數據庫平臺)_query(“select count(*) as date from news”,$db);
     $query=mssql(WINDOWS平臺上強大的數據庫平臺)_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>
“;
echo “<!–
“;
echo “A{text-decoration:none}
“;
echo “A:hover         {color:blue;; text-decoration: underline}
“;
echo “td {  font-size: 9pt}
“;
echo “–></style>
“;
echo “<p align=center><center>
“;
echo “<table border=0 width=100% cellspacing=0 cellpadding=0 height=19
“;
echo “<tr>”;
echo ” <td width=52% colspan=5><img src=”/edu/UploadPic/2008-2/2008215181316912.gif” width=100%></td></tr>
“;
echo “<tr>”;
echo ”    <td width=52% height=19 valign=bottom bgcolor=#B5C6B0><p align=center><font
“;
echo ”    color=#408080>新聞標題</font></td>
“;
echo ”    <td width=14% height=19 valign=bottom align=center bgcolor=#B5C6B0><font
“;
echo ”    color=#408080>發表日期</font></td>
“;
echo ”    <td width=19% height=19 valign=bottom align=center bgcolor=#B5C6B0><font
“;
echo ”    color=#408080>發表部門</font></td>
“;
echo ”    <td width=7% height=19 valign=bottom align=center bgcolor=#B5C6B0><font
“;
echo ”    color=#408080>閱讀</font></td>
“;
echo ”    <td width=8% height=19 valign=bottom align=center bgcolor=#B5C6B0><font
“;
echo ”    color=#408080>圖像</font></td>
“;
echo ”  </tr>
“;
echo “</table>
“;
echo “</center></p>
“;
echo “<p align=center><center>
“;
echo “<table border=0 width=100% cellspacing=0 cellpadding=0 height=19>
“;
     $db=mssql(WINDOWS平臺上強大的數據庫平臺)_connect($local,$user,$pass);
     mssql(WINDOWS平臺上強大的數據庫平臺)_select_db($name,$db);
     $query=mssql(WINDOWS平臺上強大的數據庫平臺)_query(“select * from news order by date desc”,$db);
     $roro=mssql(WINDOWS平臺上強大的數據庫平臺)_num_rows($query);
      if ($roro==0) {
echo “<br><br><p align=”center”><font color=”#FF0000″ size=”2″><marquee behavior=”alternate” border=”0″ width=”300″ height=”16″ scrolldelay=”70″>目前數據庫中無任何記錄!</marquee></font></p>”;

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。