Configure PHP Access Sqlsever in Wamp server

Configure PHP Access Sqlsever in Wamp server

Most of the online introduction is right, the key points did not write, worried about the death of a person ah

1, Windows Server 2008 or R2 version, if it is 64-bit system also want to Ann Wamp server 32 bit, otherwise the driver is not good use ah, blood lesson AH

2. In the example below, php5.4 should be changed to Php_sqlsrv_54_ts.dll

3, php5.5 official No, there is a third party, website: http://www.hmelihkara.com/files/php_sqlsrv_55.rar

4, thinkphp to Sqlsever support Not very good, anyway feel pit more

The following article source URL: http://www.uncletoo.com/html/base/824.html

Install the Microsoft SQL Server driver in Wamp

Most PHP developers are very familiar with MySQL database , but for SQL Server, we find that even the official website of Google and Php.net have little knowledge about PHP and SQL Server. This article describes how to install the Microsoft Sqlserv driver on 32-bit WAMP and PHP5.3.

1. Open http://www.microsoft.com/en-us/download/details.aspx?id=20098 link to download Microsoft SQL Server PHP driver;

2. Download SQLSRV30.EXE (for Windows Vista,server 2008, and Windows 7 or above) or SQLSRV20.EXE (for Server 2003/windows XP or below).

3, run SQLSRV30.EXE, then enter your PHP Bin folder path, install the driver DLL file, such as:

4. Open the php.ini file and remove the semicolon (;) before the following two lines of code

Extension=php_pdo_sqlsrv_53_ts.dll

Extension=php_sqlsrv_53_ts.dll

5. Restart the Wamp service and use Phpinfo to see if the PDO_SQLSRV is enabled:

6. Create php file, copy and paste the code below, check the link between PHP and SQL Server Database

1 2 3 4 5 6 7 8 9 10 11

<?php $serverName = "hostname or ip"; $connInfo = array("Database"=>"db_name", "UID"=>"db_username", "PWD"=>"db_password"); $conn = sqlsrv_connect($serverName, $connInfo); if($conn){  echo "Database connection established.<br />"; }else{  echo "Connection could not be established.<br />";  die( print_r(sqlsrv_errors(), true)); } ?>