PHP連接MSSQL方法匯總

2020-03-22 18:20:29

字體：大中小

供稿：網(wǎng)友

為了能讓PHP連接MSSQL,系統(tǒng)需要安裝MSSQL,PHP,且在PHP.ini中的配置中,將;extension=php_mssql.dll前面的;去掉1.連接MSSQL
$conn=mssql_connect("實(shí)例名或者服務(wù)器IP","用戶(hù)名","密碼"); //測(cè)試連接 if($conn) echo "連接成功";2.選擇要連接的數(shù)據(jù)庫(kù) mssql_select_db("dbname");3.執(zhí)行查詢(xún)
$rs = mssql_query("select top 1 id,username from tbname",$conn);// 或者直接執(zhí)行update,insert等語(yǔ)句,可以不用為返回結(jié)果賦值mssql_query("update tbname set username='niunv' where id=1");4.獲取記錄集行數(shù) echo mssql_num_rows($rs);5.獲取記錄集 if($row=mssql_fetch_array($rs)) $id = $row[0];//獲取ID字段值 $username = $row[1];//獲取username字段值6.獲取新增記錄的ID
將id字段設(shè)置為IDENTITY字段,執(zhí)行insert語(yǔ)句以后,就會(huì)產(chǎn)生一個(gè) @@IDENTITY html' target='_blank'>全局變量值,查詢(xún)出來(lái)就是最后一條新增記錄的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.關(guān)閉連接 mssql_close($conn); 注:用PHP操作MSSQL比在ASP連接MYSQL要簡(jiǎn)單,所以,當(dāng)需要MSSQL與MYSQL并存時(shí),用PHP連接MSSQL來(lái)操作MYSQL與MSSQL并存比較簡(jiǎn)單好用.如果是ASP連接MYSQL,需要安裝一個(gè)MYSQL驅(qū)動(dòng),默認(rèn)windows的ODBC沒(méi)有安裝,很遺憾... 在web服務(wù)器上至少安裝了mssql的客戶(hù)端打開(kāi)php.ini把;extension=php_mssql.dll 前面的分號(hào)去掉有必要話(huà)：需要制定extension_dir 推薦使用 php =4.0.9 =5.0.3目前我還沒(méi)有連接成功過(guò)4.010和 5.0.3 數(shù)據(jù)庫(kù)的連接分頁(yè)可以到phpe.net上獲取到相應(yīng)的class

function SQL($Server='',$UserName='',$PassWord='',$DataBase=''){ $this- server = $Server; $this- userName = $UserName; $this- passWord = $PassWord; $this- dataBase = $DataBase; /** *數(shù)據(jù)庫(kù)連接 **/ 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; /**public * function: Check the database, if exist then select * exist: return 1 * not exist: return 0 function selectDatabase(){ if(mssql_select_db($this- dataBase)) return 1; else return 0; /** *數(shù)據(jù)操作 **/ function query($Str){ if ($this- linkID == 0) { $this- ER = "數(shù)據(jù)庫(kù)還沒(méi)有連接！！"; $this- queryResult = mssql_query($Str); //$this- queryResult = mssql_query($Str,$this- linkID); if (!$this- queryResult) {
$this- ER = "$Str.沒(méi)有操作成功,query error！！"; return 0;//****************對(duì)于php 4.3.9以上版本的錯(cuò)誤用1 return $this- queryResult; /** *數(shù)據(jù)獲取 **/ function fetch_array($result){ if($result != "") $this- queryResult = $result; $rec =mssql_fetch_array($this- queryResult); if(is_array($rec)){ return $rec; //$this- ER = "沒(méi)有獲取數(shù)據(jù)！"; return 0; /**public * function: Free the Query Result * success return 1 * failed: return 0 function freeResult($result=""){ if($result != "") $this- queryResult = $result; return mssql_free_result($this- queryResult); /** *獲取影響的的行數(shù) *獲取操作過(guò)的行數(shù) **/ function num_rows($result=""){ if ($result != "") { $this- queryResult = $result; $row = mssql_num_rows($this- queryResult); return $row; /** *獲取查詢(xún)結(jié)果---多個(gè) **/ function result_ar($str=''){ if (empty($str)) { return 0; $back = array(); $this- queryResult = $this- query($str); while ($row = $this- fetch_array($this- queryResult)) { $back[] = $row; return $back; /** *數(shù)據(jù)庫(kù)信息分頁(yè) *$Result 數(shù)據(jù)庫(kù)操作 *str ==sql語(yǔ)句 *page ==第幾頁(yè) *showNum ==顯示幾頁(yè) function page($Str,$Page=0,$ShowNum=5){ $back = array();//返回?cái)?shù)據(jù) $maxNum = 0; if ($Str == "") { $this- ER = "沒(méi)有數(shù)據(jù)"; 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 $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; /** *分頁(yè)的html頁(yè)碼 function page_html($DataNum=0,$Page=1,$ShowNum=3,$web,$Post=''){ if ($DataNum == 0) { $back = "沒(méi)有要查詢(xún)的數(shù)據(jù)"; }else { if ($ShowNum =0) { $ShowNum = 3; if ($Page =0) { $Page = 1; if (empty($web)) { $web = "#"; $pageNum = ceil($DataNum/$ShowNum); if ($Page = 1) { $top = "首頁(yè) "; }else { $top = " a href='".$web." page=0&".$Post."' target='_self' 首頁(yè) /a if ($Page !==1) { $upPage = " a href='".$web." page=".($Page-1)."&".$Post."' target='_self' 上一頁(yè) /a }else { $upPage = "上一頁(yè)"; if ($Page $pageNum) { $downPage = " a href='".$web." page=".($Page+1)."&".$Post."' target='_self' 下一頁(yè) /a }else { $downPage = "下一頁(yè)"; if ($Page == $pageNum) { $foot = " 尾頁(yè)"; }else { $foot = " a href='".$web." page=".$pageNum."&".$Post."' target='_self' 尾頁(yè) /a $back = EOT 共 $pageNum 頁(yè) 第 $Page/$pageNum 頁(yè) $top $upPage $downPage $foot EOT; return $back; }//end class 以上就是PHP連接MSSQL方法的總結(jié)，希望對(duì)大家的學(xué)習(xí)有所幫助。PHP教程

鄭重聲明：本文版權(quán)歸原作者所有，轉(zhuǎn)載文章僅為傳播更多信息之目的，如作者信息標(biāo)記有誤，請(qǐng)第一時(shí)間聯(lián)系我們修改或刪除，多謝。

上一篇：關(guān)于Laravel框架數(shù)據(jù)庫(kù)CURD操作和連貫操作的解析

下一篇：ThinkPHP3.1新特性之多層MVC的支持