当前位置:Gxlcms > PHP教程 > 求PHP+SQLServer的翻页成效

求PHP+SQLServer的翻页成效

时间:2021-07-01 10:21:17 帮助过:18人阅读

求PHP+SQLServer的翻页效果
  1. <br>
  2. <br>
  3. <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><br>
  4. <title>分页实例</title><br>
  5. <style><br />
  6. .page A{ padding:3px 5px; float:left; border:solid #CCCCCC 1px; text-decoration:none; font-size:10px; margin-left:1px; font-family:Verdana;color:#000000;}<br />
  7. .page A.currentpage{ color:#FF0000; border: solid red 1px;}<br />
  8. .page A:hover{ background-color:#CCCCCC;}<br />
  9. </style><br>
  10. <br>
  11. <br>
  12. <!--?php<br /-->
  13. <br>
  14. error_reporting(7);<br>
  15. //初始化翻页链接参数<br>
  16. $page=$_GET["page"]+0; //思考这里是用强制转换为整数还是用什么方法呢<br>
  17. $page= $page<=0 ? 1 : $page; //避免$_GET["page"]为负数和0的情况<br>
  18. <br>
  19. //分页尺寸<br>
  20. $page_size=10;<br>
  21. <br>
  22. $serverName = "(local)"; //数据库服务器地址 <br>
  23. $uid = "sa"; //数据库用户名 <br>
  24. $pwd = "ulptfstx"; //数据库密码 <br>
  25. $connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"MSD"); <br>
  26. $conn = sqlsrv_connect( $serverName, $connectionInfo); <br>
  27. if( $conn == false) {<br>
  28. echo "连接失败!";<br>
  29. die( print_r( sqlsrv_errors(), true));<br>
  30. }<br>
  31. <br>
  32. //计算总行数<br>
  33. $total_records=sqlsrv_num_rows(sqlsrv_query("SELECT MB001 from INVMB"));<br>
  34. <br>
  35. //总页数<br>
  36. $total_page=ceil($total_records/$page_size); //进一法取整,避免最后一页不满$page_size, <br>
  37. <br>
  38. $page=$page>$total_page?$total_page:$page; //避免$_GET["page"]大于总页数<br>
  39. <br>
  40. //翻页链接开始<br>
  41. $page_link="";<br>
  42. if ($total_page>1)<br>
  43. {<br>
  44. $page_link="一共{$total_page}页";<br>
  45. $page_link.="当前第{$page}页";<br>
  46. $page_link.="首页";<br>
  47. <br>
  48. if ($page>1){<br>
  49. //页码大于1的时候,显示上一页翻页链接<br>
  50. $pre_page=$page-1;<br>
  51. $page_link.="<<";<br>
  52. }<br>
  53. //翻页列表<br>
  54. for ($i=1;$i<=$total_page;$i++)<br>
  55. {<br>
  56. if ($i==$page)<br>
  57. {<br>
  58. //高亮当前页页码<br>
  59. $page_link.="$i";<br>
  60. }<br>
  61. else<br>
  62. {<br>
  63. $page_link.="$i";<br>
  64. }<br>
  65. }<br>
  66. //页码小于总页数的时候显示下一页翻页链接<br>
  67. $next_page=$page+1;<br>
  68. if($next_page<$total_page)<br>
  69. {<br>
  70. $page_link.=">>";<br>
  71. }<br>
  72. $page_link.="最后一页";<br>
  73. } <br>
  74. //
输出记录

$offset=($page-1)*$page_size;
$query=sqlsrv_query("select * from INVMB limit $offset,$page_size") or die(sqlsrv_error());
echo "
    ";
    while ($rs=sqlsrv_fetch_array($query))
    {
    echo "
  • {$rs["0"]}-{$rs["1"]}
  • ";
    }
    echo "
      ";
      echo "$page_link";

      ?>


      这段代码来自 http://topic.csdn.net/u/20120117/11/c2618d08-b88c-4586-8b00-f1938f5c7792.html
      怎么把它改成连接SQLServer的,现在运行提示以下错误:

      1. Warning: sqlsrv_query() expects at least 2 parameters, 1 given in D:\Apache server\Apache\htdocs\bbs\demo.php on line 33<br>

人气教程排行