本文實例講述了PHP封裝的MSSql操作類。分享給大家供大家參考，具體如下：
<?php/*MSSql的操作類*/class MSSql { var $link; var $querynum = 0; /*連接MSSql數據庫，參數：dbsn->數據庫服務器地址，dbun->登陸用戶名，dbpw->登陸密碼，dbname->數據庫名字*/ function Connect($dbsn, $dbun, $dbpw, $dbname) { if($this->link = @mssql_connect($dbsn, $dbun, $dbpw, true)) { $query = $this->Query('SET TEXTSIZE 2147483647'); if (@mssql_select_db($dbname, $this->link)) { } else { $this->halt('Can not Select DataBase'); } } else { $this->halt('Can not connect to MSSQL server'); } } /*執行sql語句，返回對應的結果標識*/ function Query($sql) { if($query = @mssql_query($sql, $this->link)) { $this->querynum++; return $query; } else { $this->querynum++; $this->halt('MSSQL Query Error', $sql); } } /*執行Insert Into語句，并返回最后的insert操作所產生的自動增長的id*/ function Insert($table, $iarr) { $value = $this->InsertSql($iarr); $query = $this->Query('INSERT INTO ' . $table . ' ' . $value . '; SELECT SCOPE_IDENTITY() AS [insertid];'); $record = $this->GetRow($query); $this->Clear($query); return $record['insertid']; } /*執行Update語句，并返回最后的update操作所影響的行數*/ function Update($table, $uarr, $condition = '') { $value = $this->UpdateSql($uarr); if ($condition) { $condition = ' WHERE ' . $condition; } $query = $this->Query('UPDATE ' . $table . ' SET ' . $value . $condition . '; SELECT @@ROWCOUNT AS [rowcount];'); $record = $this->GetRow($query); $this->Clear($query); return $record['rowcount']; } /*執行Delete語句，并返回最后的Delete操作所影響的行數*/ function Delete($table, $condition = '') { if ($condition) { $condition = ' WHERE ' . $condition; } $query = $this->Query('DELETE ' . $table . $condition . '; SELECT @@ROWCOUNT AS [rowcount];'); $record = $this->GetRow($query); $this->Clear($query); return $record['rowcount']; } /*將字符轉為可以安全保存的mssql值，比如a'a轉為a''a*/ function EnCode($str) { return str_replace(''', '''', str_replace('', '', $str)); } /*將可以安全保存的mssql值轉為正常的值，比如a''a轉為a'a*/ function DeCode($str) { return str_replace('''', ''', $str); } /*將對應的列和值生成對應的insert語句，如：array('id' => 1, 'name' => 'name')返回([id], [name]) VALUES (1, 'name')*/ function InsertSql($iarr) { if (is_array($iarr)) { $fstr = ''; $vstr = ''; foreach ($iarr as $key => $val) { $fstr .= '[' . $key . '], '; $vstr .= ''' . $val . '', '; } if ($fstr) { $fstr = '(' . substr($fstr, 0, -2) . ')'; $vstr = '(' . substr($vstr, 0, -2) . ')'; return $fstr . ' VALUES ' . $vstr; } else { return ''; } } else { return ''; } } /*將對應的列和值生成對應的insert語句，如：array('id' => 1, 'name' => 'name')返回[id] = 1, [name] = 'name'*/ function UpdateSql($uarr) { if (is_array($uarr)) { $ustr = ''; foreach ($uarr as $key => $val) { $ustr .= '[' . $key . '] = '' . $val . '', '; } if ($ustr) { return substr($ustr, 0, -2); } else { return ''; } } else { return ''; } } /*返回對應的查詢標識的結果的一行*/ function GetRow($query, $result_type = MSSQL_ASSOC) { return mssql_fetch_array($query, $result_type); } /*清空查詢結果所占用的內存資源*/ function Clear($query) { return mssql_free_result($query); } /*關閉數據庫*/ function Close() { return mssql_close($this->link); } function halt($message = '', $sql = '') { $message .= '<br />MSSql Error:' . mssql_get_last_message(); if ($sql) { $sql = '<br />sql:' . $sql; } exit("DataBase Error.<br />Message $message $sql"); }}?> 
