当前位置:数据库 > SQLServer >>

一个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 "<div 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></div> ";
echo "<div 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>";
补充:Web开发 , php ,
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,