In order to enable PHP connection MSSQL, the system needs to install mssql,php, and in the configuration of php.ini, Extension=php_mssql.dll Front; remove 1. Connect MSSQL $conn =mssql_connect (" Instance name or server IP "," User name "," password "); Test connection if ($conn) {echo "Connection succeeded";} 2. Select the database mssql_select_db ("dbname") to connect to; 3. Execute Query $rs = Mssql_query ("Select top 1 id,username from Tbname", $conn); Or directly execute the Update,insert statement, you can not assign a value to the return result Mssql_query ("Update tbname set username= ' NIUNV ' where id=1"); 4. Get the number of record set rows echo mssql_num_rows ($RS); 5. Get the recordset if ($row =mssql_fetch_array ($rs)) {$id = $row [0];//Gets the id field value $username = $row [1];//Gets the username field value} 6. Gets the ID of the newly added record ID field Set to the IDENTITY field, after the INSERT statement is executed, an @ @IDENTITY global variable value is generated, and the query is the ID of the last new record. 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. Release Recordset//More http://www.52mvc.com Mssql_free_result ($RS); 8. Close the connection mssql_close ($conn); Note: Using PHP to operate MSSQL than in the ASP connection MySQL to be simple, so, when the need for MSSQL and MySQL coexistence, using PHP to connect with MSSQL to operate MySQL and MSSQL is relatively simple and easy to use. If the ASP is connected to MySQL, Need to install a MySQL driver, default Windows ODBC is not installed, unfortunately ... 1. In WA client with at least MSSQL installed on the EB server 2. Open php.ini; Extension=php_mssql.dll the semicolon in front of the necessary words: need to develop EXTENSION_DIR 3. Recommended Use php<=4.0.9 <= 5.0.3 currently I have not connected successfully over 4.010 and 5.0.3 4. The connection page of the database can be obtained to the corresponding class on the phpe.net below is a class that I modified based there Server = $Server; $this->username = $UserName; $this->password = $PassWord; $this->database = $DataBase; }/** * Database connection **/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 Selec Tdatabase () {if (mssql_select_db ($this->database)) return 1; else return 0;}/** * Data operation **/function query ($STR) {if ($t His->linkid = = 0) {$this->er = "Database is not connected!! "; } $this->queryresult = Mssql_query ($STR); $this->queryresult = Mssql_query ($Str, $this->linkid); if (! $this->queryresult) {$this->er ="$Str. No operation succeeded, query error!! "; return 0;//**************** for PHP 4.3.9 or later error with 1} return $this->queryresult; }/** * Data gets **/function Fetch_array ($result) {if ($result! = "") $this->queryresult = $result; $rec =mssql_fetch_array ($this->queryresult); if (Is_array ($rec)) {return $rec;}//$this->er = "No data obtained!" "; 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); }/** * Gets the number of rows affected * Gets the number of rows that have been manipulated **/function num_rows ($result = "") {if ($result! = "") {$this->queryresult = $result; $row = Mssql_num_rows ($this->queryresult); return $row; }}/** * Get query Results---multiple **/function result_ar ($str = ') {if (empty ($STR)) {return 0;} $back = Array (); $this->queryresul t = $this->query ($STR); while ($row = $this->fetch_array ($this->queryresult)) {$back [] = $row;} return $back; }/** * Database information Paging * $Result database operations *str==sql statement *page = = Page *shownum = = Displays several pages */function page ($Str, $Page =0, $ShowNum =5) {$back = array ();//return data $maxNum = 0; if ($St r = = "") {$this->er = "no data"; 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; }/** * Page HTML page */function page_html ($DataNum =0, $Page =1, $ShowNum =3, $web, $Post = ") {if ($DataNum = = 0) {$back =" no number to query According to "; }else {if ($ShowNum <=0) {$ShowNum = 3;} if ($Page <=0) {$Page = 1;} if (Empty ($web)) {$web = "#";} $pAgenum = Ceil ($DataNum/$ShowNum); if ($Page <= 1) {$top = "home <<";} else {$top = "home <<";} if ($Page!==1) {$upPage = "prev";} else {$upPage = "previous";} if ($Page < $pageNum) {$downPage = "next page";} else {$downPage = "next page";} if ($Page = = $pageNum) {$foot = ">> Last";} else {$foot = ">> Last";} $back = <<
< span id= "url" itemprop= "url" >http://www.bkjia.com/phpjc/477777.html www.bkjia.com true http://www.bkjia.com/phpjc/477777.html techarticle to enable PHP to connect MSSQL, the system needs to install MSSQL, PHP, in the configuration of PHP.ini, Extension=php_mssql.dll the front; 1. Connect MSSQL $conn =mssql_connect (instance name or service ...
