How to connect php to sql server

Description:
1: PHP5.2.x itself has an extension of php_mssql.dll to connect to Sql server, but this dll is only used to connect to lower versions of Sql server (versions below 2000). In Sql server Versions 2005 and above cannot use mssql_connect to connect to the database.
2: php5.3.x no longer supports the php_mssql.dll extension library, and it cannot be used even if you use php_mssql.dll in php5.2.x. Microsoft has specially developed a SQL Server extension (Windows version) for PHP. For developing SQL Server applications using PHP under Windows, this extension is conducive to using SQL Server to develop the PHP platform to connect to the SQL Server database management system.
1. Versions below php5.3 connect to sql server
The extension of versions below 5.3 comes with a php_mssql.dll; to connect to the database extension, you can use this extension to link to the database (limited to linking to lower version databases) .
The specific steps are as follows:
1: First install sql server, which is super difficult to install. The one I installed before was the 2008 version. It can no longer be used after Windows expires. Then I reinstalled it and it still failed to install. Finally, I reinstalled it. Install the system before installing
2: Make sure that the mixed authentication mode or SQL verification mode is used when installing SQL, then open the php configuration file (php.ini) and enable the mssql extension (in front of extension=php_pdo_mssql.dll Remove the semicolon) and need to set mssql.secure_connection = On to take effect after restarting.
If it goes smoothly, you can already connect to the database. If you can't connect, you need to continue low-level configuration:
3: Check the version of ntwdblib file (php/below and Apache/below) and download the correct version of ntwdblib. dll (2000.80.194.0) overwrites the existing DLL file (you can also copy ntwdblib.dll and php_mssql.dll to the system32 directory) ntwdblib.dll is the driver file used for PHP to connect to MSSQL2005 or 2008.
4: Test connection: mssql_connect('localhost,1433', 'username', 'password');
2. php5.3+ connect to sql server
In fact, there are very few php versions below 5.3 It is used, and the security and compatibility are not good, so higher versions of PHP are still relatively common. Practice has proved that the success rate of connecting to the database with lower versions of PHP is relatively low (versions above 2005 can hardly be used). It is recommended to use PHP5.3+ PHP and use Microsoft's special extension SQLSRV to connect to the SQLServer database.
The steps are as follows:
1: First go to the Microsoft website to download the SQL Server Driver for PHP. It is a self-extracting EXE file. After decompression, you will get the following files:

, where 52 and 53 represent It is the 5.2.x and 5.3.x versions of php. Choose the one that matches your php version; the choice of vc6 or vc9 depends on what web server software you are using. If you are using IIS, choose vc9. Apache chooses vc6. The choice of ts and nts depends on whether the PHP version you installed is thread-safe or non-thread-safe. ts is thread-safe and nts is non-thread-safe.
If you don’t know, you can see the Zend Extension Build attribute in phpinfo as shown below:

2: Copy the extension to the php/ext directory , in the php.ini file, add the following code:
extension=pdo extension under ext (for pdo)
extension=extension under ext
3: Restart the server and open phpinfo(); Seeing the following status proves that the extension was added successfully,

4: Connection test:

<?php
  $serverName = "(local)";
  $connectionInfo = array("UID"=>"sa","PWD"=>"admin","Database"=>"db_online");
  $conn = sqlsrv_connect( $serverName, $connectionInfo);
  if( $conn ){
     echo "Connection established.\n";
  }else{
     echo "Connection could not be established.\n";
     die( var_dump(sqlsrv_errors()));
  }
  sqlsrv_close( $conn);
?>

Note that the connection here is not mssql_connect but sqlsrv_connect. In this version, there are several functions:
This extension adds a series of functions starting with sqlsrv_ to PHP. The commonly used functions are as follows:

sqlsrv_connect
sqlsrv_close
sqlsrv_commit
SQLSRV_ERRORS
SQLSRV_FETCH
SQLSRV_FETCH_ARAY ## SQLSRV_FETCH_METADADADADAD K
SQLSRV_ROWS_Affect
...
Another note is that if this extension is used to connect SQL Server For sql server 2005 and above (such as sql server 2008), you also need to install SQL Server Native Client on the machine
Otherwise, the following error will occur:

array
0 =>array
0 =>string'IMSSP'(length=5)
'SQLSTATE' =>string'IMSSP'(length=5)
1 =>int-49
'code' =>int-49
2 =>string'This extension requires the Microsoft SQL Server 2012 Native Client. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712'(length=216)
'message' =>string'This extension requires the Microsoft SQL Server 2008 Native Client. Access the following URL to download the Microsoft SQL Server 2008 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712'(length=216)
1 =>array
0 =>string'IM002'(length=5)
'SQLSTATE' =>string'IM002'(length=5)
1 =>int0
'code' =>int0
2 =>string'[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'(length=71)
'message' =>string'[Microsoft] [ODBC Driver Manager] Data source name not found and default driver '(length=71)
. . . .

Solution: SQL Server 2008 Native Client ODBC Driver needs to be installed, Download the installation file sqlncli.msi and install it.

The above is how to connect php to sql server. I hope it will help everyone solve similar problems.

For more articles related to how to connect php to sql server, please pay attention to the PHP Chinese website!