search

Home >Backend Development >PHP Tutorial > 求PHP+SQLServer的翻页效果,该怎么处理

求PHP+SQLServer的翻页效果,该怎么处理

WBOY
WBOYOriginal
2016-06-13 12:55:551316browse

求PHP+SQLServer的翻页效果

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><br />
<html xmlns="http://www.w3.org/1999/xhtml"><br />
<head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><br />
<title>分页实例</title><br />
<style><br />
.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 />
.page A.currentpage{ color:#FF0000; border: solid red 1px;}<br />
.page A:hover{ background-color:#CCCCCC;}<br />
</style><br />
</head><br />
<br />
<body><?php<br />
<br />
error_reporting(7);<br />
//初始化翻页链接参数<br />
$page=$_GET["page"]+0;  //思考这里是用强制转换为整数还是用什么方法呢<br />
$page= $page<=0 ? 1 : $page;  //避免$_GET["page"]为负数和0的情况<br />
<br />
//分页尺寸<br />
$page_size=10;<br />
<br />
$serverName = "(local)"; //数据库服务器地址 <br />
$uid = "sa"; //数据库用户名 <br />
$pwd = "ulptfstx"; //数据库密码 <br />
$connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"MSD"); <br />
$conn = sqlsrv_connect( $serverName, $connectionInfo); <br />
  if( $conn == false) {<br />
	  echo "连接失败！";<br />
	  die( print_r( sqlsrv_errors(), true));<br />
  }<br />
<br />
//计算总行数<br />
$total_records=sqlsrv_num_rows(sqlsrv_query("SELECT MB001 from INVMB"));<br />
<br />
//总页数<br />
$total_page=ceil($total_records/$page_size);  //进一法取整，避免最后一页不满$page_size,   <br />
<br />
$page=$page>$total_page?$total_page:$page;  //避免$_GET["page"]大于总页数<br />
<br />
//翻页链接开始<br />
$page_link="";<br />
if ($total_page>1)<br />
{<br />
	$page_link="<a>一共{$total_page}页</a>";<br />
	$page_link.="<a>当前第{$page}页</a>";<br />
	$page_link.="<a href=?page=1>首页</a>";<br />
	<br />
	if ($page>1){<br />
		//页码大于1的时候，显示上一页翻页链接<br />
		$pre_page=$page-1;<br />
		$page_link.="<a  href='?page=$pre_page'><<</a>";<br />
		}<br />
		//翻页列表<br />
		for ($i=1;$i<=$total_page;$i++)<br />
		{<br />
			if ($i==$page)<br />
			{<br />
				//高亮当前页页码<br />
				$page_link.="<a href='?page=$i' class='currentpage'>$i</a>";<br />
			}<br />
			else<br />
			{<br />
				$page_link.="<a href='?page=$i'>$i</a>";<br />
			}<br />
			}<br />
			//页码小于总页数的时候显示下一页翻页链接<br />
			$next_page=$page+1;<br />
			if($next_page<$total_page)<br />
			{<br />
				$page_link.="<a  href='?page={$next_page}'>>></a>";<br />
			}<br />
			$page_link.="<a  href='?page=$total_page'>最后一页</a>";<br />
		}   <br />
		//输出记录 <br />
<br />
		$offset=($page-1)*$page_size;<br />
		$query=sqlsrv_query("select * from INVMB limit $offset,$page_size")  or die(sqlsrv_error());<br />
		echo "<ul>";<br />
		while ($rs=sqlsrv_fetch_array($query))<br />
		{<br />
			echo "<li>{$rs["0"]}-{$rs["1"]}</li>";<br />
		}<br />
		echo "<ul>";<br />
		echo  "<div class='page'>$page_link</div>";<br />
		<br />
		?><br />
</body><br />
</html>

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

Warning: sqlsrv_query() expects at least 2 parameters, 1 given in D:\Apache server\Apache\htdocs\bbs\demo.php on line 33 <div class="clear">
                 
              
              
        
            </div>
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article： PHP开源社区cms化，可以一键安装，更完善了~欢迎使用~解决思路 Next article： 重开一帖，PHP开源社区【完整版】倾情奉献~经过测试~短时间内不会更新了~该如何解决

Related articles

See more