Home>Article>Backend Development> How to connect php to MSSQL

How to connect php to MSSQL

怪我咯
怪我咯 Original
2017-07-12 15:54:56 7082browse

ms SQL refers to Microsoft's SQLServer database server. It is a database platform that provides a complete solution for the database from server to terminal. The database server part is a database management system for establishment, use and maintenance. database. SQL Server was not a product developed by Microsoft itself at the beginning, but was produced in cooperation with Sybase in order to compete with IBM. Its earliest developer was Sybase, and Microsoft also cooperated with Sybase in the development of SQL Server 4.2 version. , Microsoft also ported SQL Server 4.2 to Windows NT (version 3.1 at the time). After terminating the partnership with Sybase, it independently developed SQL Server version 6.0. All subsequent SQL Servers were developed by Microsoft itself.

This article mainly summarizes the implementation methods of PHP connection to MSSQL in detail to help you better realize the connection between PHP and MSSQL. Interested friends can refer to it

To allow PHP to connect to MSSQL, the system needs toinstallMSSQL and PHP, and in the configuration in PHP.ini, remove the ; in front of ;extension=php_mssql.dll

1 .Connect to MSSQL

$conn=mssql_connect("实例名或者服务器IP","用户名","密码"); //测试连接 if($conn) { echo "连接成功"; }

2.Select the database to connect

mssql_select_db("dbname");

3.Executequery

$rs = mssql_query("select top 1 id,username from tbname",$conn); // 或者直接执行update,insert等语句,可以不用为返回结果赋值 mssql_query("update tbname set username='niunv' where id=1");

4. Get the number of rows in the record set

echo mssql_num_rows($rs);

5. Get the record set

if($row=mssql_fetch_array($rs)) { $id = $row[0];//获取ID字段值 $username = $row[1];//获取username字段值 }

6. Get ID
of the new record Set the id field to the IDENTITY field. After executing the insert statement, an @@IDENTITY globalvariablevalue will be generated. The query result is the last newly added record. 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. Release the record set

mssql_free_result($rs);

8. Close the connection

mssql_close($conn);

Note: Use PHP to operate MSSQL is simpler than connecting to MYSQL in ASP. Therefore, when MSSQL and MYSQL need to coexist, it is easier and easier to use PHP to connect to MSSQL to operate MYSQL and MSSQL. If ASP connects to MYSQL, you need to install a MYSQL driver. The default is ODBC for Windows. Not installed, sorry...

  • At least the mssql client is installed on the web server

  • Open php.ini and remove the semicolon in front of;extension=php_mssql.dll

  • If necessary: extension_dir needs to be developed

  • ## Recommended to use php<=4.0.9 <=5.0.3Currently I don’t have it yet The connection is successful through 4.010 and 5.0.3

  • The connection pagination of the database can be obtained from phpe.net to obtain the corresponding class

The following is a class I modified

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; } /**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; } /** *数据操作 **/ 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;//****************对于php 4.3.9以上版本的错误用1 } return $this->queryResult; } /** *数据获取 **/ 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; } /**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); } /** *获取影响的的行数 *获取操作过的行数 **/ function num_rows($result=""){ if ($result != "") { $this->queryResult = $result; $row = mssql_num_rows($this->queryResult); return $row; } } /** *获取查询结果---多个 **/ 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; } /** *数据库信息分页 *$Result 数据库操作 *str ==sql语句 *page ==第几页 *showNum ==显示几页 */ 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; } /** *分页的html页码 */ 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 (empty($web)) { $web = "#"; } $pageNum = ceil($DataNum/$ShowNum); if ($Page <= 1) { $top = "首页<<"; }else { $top = "首页<< "; } if ($Page !==1) { $upPage = "上一页"; }else { $upPage = "上一页"; } if ($Page < $pageNum) { $downPage = "下一页"; }else { $downPage = "下一页"; } if ($Page == $pageNum) { $foot = ">>尾页"; }else { $foot = " >>尾页"; } $back = <<

The above is the detailed content of How to connect php to MSSQL. For more information, please follow other related articles on the PHP Chinese website!

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