PHP connection to SQL Server 2008 database

Source: Internet
Author: User
Tags sql server driver vc9

Original: PHP connects to SQL Server 2008 database

With regard to PHP connection to SQL Server 2008, the 2000 version can be modified directly from the PHP configuration file, more than 2005 of the version will not be required to use the Microsoft Company provided driver (SQL Server Driver for PHP).

  SQL Server Driver for PHP:

1. Download the driver, install the release program after the download is complete, with the following files:















Sqlserverdriverforphp_readme.htm ( Readme file )

about the difference between VC6 and VC9

The VC6 version is compiled with the Visual Studio 6 compiler, and if you are using apache+php under Windows, select the VC6 version.

The VC9 version is compiled with the Visual Studio 2008 compiler, and if you are using iis+php under Windows, select the VC9 version.

This article PHP test environment: WAMP5 Environment Package;

1. Unzip the SQL Server driver for PHP driver into the Ext folder in the PHP file (because the computer system is XP, so download the 2.0 version).

2. After extensions in the configuration file php.ini file , add:



  Note: This should be based on your PHP version of the original, if your version is 5.2 is the input



3. Restart Apache Service

4. Finally test whether the success, in PHP to perform phpinfo () view sqlsrv, look at the picture Red line, so that the connection is successful!!


Test code:

<?PHP$serverName= "localhost";//Database server address$uid= "SA";//Database user name$pwd= "123456";//Database Password$connectionInfo=Array("UID" =$uid, "PWD" =$pwd, "Database" = "Hzf");$conn= Sqlsrv_connect ($serverName,$connectionInfo);if($conn==false){     Echo"Connection Failed! ";  die(Print_r(Sqlsrv_errors (),true));}//Execute SQL statement with result set$query= Sqlsrv_query ($conn, "SELECT * from test_id"); while($row= Sqlsrv_fetch_array ($query)){Echo $row[0]. " <br/> ";}?>

Output Result:

The above method is for the php5.2 version, the remaining version has not been tried, I hope the novice friends a little Help

PHP connection to SQL Server 2008 database

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.