Home >Backend Development >PHP Tutorial > sqlsrv函数有关问题

sqlsrv函数有关问题

WBOY
WBOYOriginal
2016-06-13 12:46:13911browse

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
	{<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
	{<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>
<br>
<title></title><br>
<br>
<link><br>
<br>





for($j=0;$j {
$field=mssql_fetch_field($result);
echo "";
".$field->name."
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