sqlsrv函数有关问题
- WBOY原创
- 2016-06-13 11:26:33834浏览
sqlsrv函数问题
环境:Apache 2.2.22、PHP 5.3.5、数据库MSSQL2008
mssql这是PHP5.3以前版本的，怎么将以下代码改成PHP5.3之后版本的，即sqlsrv函数，自己曾试着改过一部分，但老是报错，所有只能在此求助各位了！！
<?<br /> session_start();<br />//连接数据库服务器<br /> $Link=mssql_connect(".","sa","");<br />//选择数据库<br /> mssql_select_db("frienddb");<br />//定义SQL语句<br /> <br /> $name=$_REQUEST["txtName"]; <br /> $address=$_REQUEST["txtAddress"];<br /> $group=$_REQUEST["txtGroup"];<br /> <br /> $sqlstr="";<br /> if($name!="")<br /> {<br /> $sqlstr="mName='".$name."'";<br /> }<br /> <br /> if($sqlstr!="")<br /> {<br /> if($address!="")<br /> {<br /> $sqlstr=$sqlstr." and mAddress='".$address."'";<br /> }<br /> }<br /> else<br /> {<br /> if($address!="")<br /> {<br /> $sqlstr="mAddress='".$address."'";<br /> }<br /> }<br /> <br /> if($sqlstr!="")<br /> {<br /> if($group!="")<br /> {<br /> $sqlstr=$sqlstr." and tname='".$group."'";<br /> }<br /> }<br /> else<br /> {<br /> if($group!="")<br /> {<br /> $sqlstr="tname='".$group."'";<br /> }<br /> }<br /> <br /> <br /> if($_REQUEST["Submit"]!="")<br /> {<br /> $_SESSION["sqltxt"]=$sqlstr;<br /> }<br /> else<br /> {<br /> $sqlstr=$_SESSION["sqltxt"];<br /> }<br /> echo $_SESSION["sqltxt"];<br /> <br /> if($sqlstr!="")<br /> {<br /> $Query="select count(*) from myfriends,team where myfriends.tid=team.tid and ".$sqlstr;<br /> }<br /> else<br /> {<br /> $Query="select count(*) from myfriends,team where myfriends.tid=team.tid ";<br /> }<br /> <br /> $rs=mssql_query($Query);//查询记录总数<br /> $cntrow=mssql_fetch_row($rs);<br /> $cnt=$cntrow[0];//记录总数<br /> $PageSize=10;//每页显示10条数据<br /> //计算总页数<br /> if($cnt%$PageSize==0)<br /> {<br /> $PageCnt=$cnt/$PageSize;<br /> }<br /> else<br /> {<br /> $PageCnt=floor($cnt/$PageSize) 1;//总页数<br /> }<br /> $CurrentPage=floor($_REQUEST["pid"]);//当前页,如果为小数则当前页取值为小于此小数的整数<br /> //当前页小于1<br /> if($CurrentPage<1)<br /> {<br /> $CurrentPage=1;<br /> }<br /> //当前页大于总页数<br /> if($CurrentPage>$PageCnt)<br> {<br> $CurrentPage=$PageCnt;<br> }<br> <br> //设置起始页码<br> $Start=$CurrentPage-3;<br> //设置终止页码 <br> $End=$CurrentPage 3; <br> <br> //上一页<br> $PrvPage=$CurrentPage-1;<br> //下一页<br> $NextPage=$CurrentPage 1; <br> if($Start<1)<br /> {<br /> $Start=1;<br /> $End=$Start 6;<br /> }<br /> <br /> if($End>$PageCnt)<br> {<br> $Start=$PageCnt-6;<br> $End=$PageCnt;<br> }<br> <br> if($sqlstr!="")<br> {<br> $sqlstr="select top ".$PageSize." mName,mSex,mBirthday,mTel,mAddress,tname from myfriends,team where myfriends.tid=team.tid and mid not in (select top ".($CurrentPage-1)*$PageSize." mid from myfriends) and ".$sqlstr;<br> <br> }<br> else<br> {<br> $sqlstr="select top ".$PageSize." mName,mSex,mBirthday,mTel,mAddress,tname from myfriends,team where myfriends.tid=team.tid and mid not in (select top ".($CurrentPage-1)*$PageSize." mid from myfriends) ";<br><br> }<br> //echo $sqlstr;<br> <br> $result=mssql_query($sqlstr);//返回结果集<br> /*<br> mssql_fetch_row//取行数据<br> mssql_fetch_field//取列数据<br> */ <br> <br>?><br><html><br><title></title><br><head></head><br><link href="css/demo.css" type="text/css" rel="stylesheet" rev="stylesheet"/><br><body><br><form><br><div id="outDiv"><br> <table border="1" id="maintable" style="width:60%"><br> <tr><br> <?<br /> for($j=0;$j<6;$j )<br /> {<br /> $field=mssql_fetch_field($result);<br /> echo "<td>".$field->name."</td>";<div class="clear"></div>声明：
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
上一篇：php生手！为什么浏览器不显示php代码下一篇：请问用名称调用函数和传参