php联接mssql的一些方法总结

php连接mssql的一些方法总结

为了能让PHP连接MSSQL,系统需要安装MSSQL,PHP,且在PHP.ini中的配置中,将
?????? ;extension=php_mssql.dll前面的;去掉
?????? 1.连接MSSQL
?????? $conn=mssql_connect("实例名或者服务器IP","用户名","密码");
?????? //测试连接
?????? if($conn)
?????? {
?????? echo "连接成功";
?????? }
?????? 2.选择要连接的数据库
?????? mssql_select_db("dbname");
?????? 3.执行查询
?????? $rs = mssql_query("select top 1 id,username from tbname",$conn);
?????? 或者直接执行update,insert等语句,可以不用为返回结果赋值
?????? mssql_query("update tbname set username='niunv' where id=1");
?????? 4.获取记录集行数
?????? echo mssql_num_rows($rs);
?????? 5.获取记录集
?????? if($row=mssql_fetch_array($rs))
?????? {
?????? $id = $row[0];//获取ID字段值
?????? $username = $row[1];//获取username字段值
?????? }
?????? 6.获取新增记录的ID
?????? 将id字段设置为IDENTITY字段,执行insert语句以后,就会产生一个 @@IDENTITY 全局变量值,查询出来就是最后一条新增记录的ID了.
?????? mssql_query("insert into tbname(username) values ('nv')",$conn);
?????? $rs = mssql_query("select @@IDENTITY as id",$conn);
?????? if($row=mssql_fetch_array($rs))
?????? {
?????? echo $row[0];
?????? }
?????? 7.释放记录集
?????? mssql_free_result($rs);
?????? 8.关闭连接
?????? mssql_close($conn);
??????
?????? 注:用PHP操作MSSQL比在ASP连接MYSQL要简单,所以,当需要MSSQL与MYSQL并存时,用PHP连接MSSQL来操作MYSQL与MSSQL并存比较简单好用.如果是ASP连接MYSQL,需要安装一个MYSQL驱动,默认windows的ODBC没有安装,很遗憾...
?????
?????
?????
? 1.在web服务器上至少安装了mssql的客户端???
? 2.打开php.ini把;extension=php_mssql.dll?? 前面的分号去掉?
??????? 有必要话：需要制定extension_dir?
? 3.推荐使用?? php<=4.0.9???? <=5.0.3目前?? 我还没有连接成功过4.010和?? 5.0.3?
? 4.数据库的?? 连接分页可以?? 到???? phpe.net上获取到相应的class?
? 下面是我根据那里?? 修改的?? 一个class

<?php?? ??? ?
class???SQL{?? ?? ?
var???$server;?? ?var???$userName;?? ?
var???$passWord;?? ?var???$dataBase;?? ?
? ?var???$linkID???=???0;?? ?
var???$queryResult;?? ?var???$lastInsertID;?? ?
? ?var???$pageNum???=???0;//分页用---共有几条数据?? ?
var???$ER;?? ?? ?
?? ?function?????SQL($Server='',$UserName='',$PassWord='',$DataBase=''){?? ?
$this->server???=???$Server;?? ?$this->userName???=???$UserName;?? ?
$this->passWord???=???$PassWord;?? ?$this->dataBase???=???$DataBase;?? ?
}?? ??? ?
function???db_connect(){?? ?$this->linkID???=???mssql_pconnect($this->server,$this->userName,$this->passWord);?? ?
if(!$this->linkID){?? ?$this->ER???=???"db_connect($this->server,$this->userName,$this->passWord)???error";?? ?
return???0;?? ?}?? ?
if???(!mssql_select_db($this->dataBase,$this->linkID))???{?? ?$this->ER???=???"mssql_select_db($this->dataBase,$this->lastInsertID)???error";?? ?
return???0;?? ?}?? ?
return???$this->linkID;?? ?}?? ?
? ??? ?
function???selectDatabase(){?? ?if(mssql_select_db($this->dataBase))?? ?
return???1;?? ?else?? ?
return???0;?? ?}?? ?
? ??? ?
function?????query($Str){?? ?if???($this->linkID???==???0)???{?? ?
$this->ER???=???"数据库还没有连接！！";?? ?}?? ?
? ???????????????$this->queryResult???=???mssql_query($Str);?????? ?
//$this->queryResult???=???mssql_query($Str,$this->linkID);?? ?if???(!$this->queryResult)???{?? ?
????? ?? ?
$this->ER???=???"$Str.没有操作成功,query???error！！";?? ?return???0;/?? ?
function???fetch_array($result){?? ?if($result???!=???"")???$this->queryResult???=???$result;?? ?
$rec???=mssql_fetch_array($this->queryResult);?? ?? ?
if(is_array($rec)){?? ?return???$rec;?? ?
? ?}?? ?
? ?//$this->ER???=???"没有获取数据！";?? ?
return???0;?? ?}?? ?
? ??? ?
function???freeResult($result=""){?? ?if($result???!=???"")???$this->queryResult???=???$result;?? ?
return???mssql_free_result($this->queryResult);?? ?}?? ?
??????? ??? ?
function???num_rows($result=""){?? ?if???($result???!=???"")???{?? ?
$this->queryResult???=???$result;?? ?$row???=???mssql_num_rows($this->queryResult);?? ?
return???$row;?? ?}?? ?
}?? ?????????? ?
?? ?function???result_ar($str=''){?? ?
if???(emptyempty($str))???{?? ?return???0;?? ?
}?? ?$back???=???array();?? ?
$this->queryResult???=???$this->query($str);?? ?? ?
while???($row???=???$this->fetch_array($this->queryResult))???{?? ?$back[]???=???$row;?? ?
}?? ?return???$back;?? ?
}?? ?? ?
?? ?function???page($Str,$Page=0,$ShowNum=5){?? ?
$back???=???array();//返回数据?? ?$maxNum???=???0;?? ?
if???($Str???==???"")???{?? ?$this->ER???=???"没有数据";?? ?
return?????0;?? ?}?? ?
$this->queryResult???=???$this->query($Str);?? ?if($this->queryResult){?? ?
if($Page==""){?? ?$nopa=0;?? ?
}else{?? ?$nopa???=???($Page-1)*$ShowNum;?? ?
if???($nopa<0)???{?? ?$nopa???=???0;?? ?
}?? ?}?? ?
$maxNum=$this->num_rows($this->queryResult);?? ?$k=0;?? ?
$i=0;?? ?$dd=$this->fetch_array($this->queryResult);?? ?
? ?while($dd&&$nopa<=$maxNum&&$i<$ShowNum){?? ?
if($nopa???>=???$maxNum)?????$nopa???=???$maxNum;?? ?mssql_data_seek($this->queryResult,$nopa);?? ?
? ?$row=$this->fetch_array($this->queryResult);?? ?
? ?$nopa++;?? ?
$i++;?? ?$back[]???=???$row;?? ?
? ?if???($nopa???>=$maxNum)???{?? ?
break;?? ?}?? ?
}?? ?}?? ?
$this->pageNum???=???$maxNum;?? ?return???$back;?? ?
}?? ?? ?
?? ?function?????page_html($DataNum=0,$Page=1,$ShowNum=3,$web,$Post=''){?? ?
if???($DataNum???==???0)???{?? ?$back???=?????"没有要查询的数据";?? ?
}else???{?? ?if???($ShowNum<=0)???{?? ?
$ShowNum???=???3;?? ?}?? ?
if???($Page<=0)???{?? ?$Page???=???1;?? ?
}?? ?if???(emptyempty($web))???{?? ?
$web???=???"#";?? ?}?? ?
$pageNum???=???ceil($DataNum/$ShowNum);?? ?if???($Page???<=???1)???{?? ?
$top???=?????"首页<<";?? ?}else???{?? ?
$top???=???"<a???href='".$web."?page=0&".$Post."'???target='_self'>首页<<???</a>";?? ?}?? ?
if???($Page???!==1)???{?? ?$upPage???=?????"<a???href='".$web."?page=".($Page-1)."&".$Post."'???target='_self'>上一页</a>";?? ?
}else???{?? ?$upPage???=???"上一页";?? ?
}?? ?if???($Page???<???$pageNum)???{?? ?
$downPage???=???"<a???href='".$web."?page=".($Page+1)."&".$Post."'???target='_self'>下一页</a>";?? ?}else???{?? ?
$downPage???=???"下一页";?? ?}?? ?
if???($Page???==???$pageNum)???{?? ?$foot???=???">>尾页";?? ?
}else???{?? ?$foot???=???"<a???href='".$web."?page=".$pageNum."&".$Post."'???target='_self'>???>>尾页</a>";?? ?
}?? ?? ?
$back???=???<<<EOT?? ?? ?
共???$pageNum???页???&nbsp;&nbsp;?? ?第???$Page/$pageNum???页???$top???&nbsp;???$upPage???&nbsp;???$downPage?????&nbsp;???$foot?? ?
EOT;?? ?}?? ?
return???$back;?? ?}?? ?
}//end???class?? ??>?