Shulou(Shulou.com)06/03 Report--

Editor to share with you several examples of PHP5.6.11 access to SQL Server2008R2 analysis, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

PHP naturally supports MySQL, but sometimes you want it to access SQL Server. What should I do?

Recently, I have found some information and successfully tested several situations in which PHP visited SQLSvr. Due to the time limit, we have not tested any more different environments. The records that have been tested are as follows:

Test environment: win7 x64 sp1,IIS 7.5, Apache 2.432-bit version, PHP 5.2.6 win32, PHP 5.6.11 win32 ts (thread safe version)

Note: since the "Microsoft Drivers for PHP for SQL Server" driver is currently only available in 32-bit version, it is not recommended to use php 64-bit if you are using the sql server database, otherwise it will lead to the problem of unable to connect to the sql server database!

Php 5.2.6 successfully accessed sql2000 on iis

Php 5.2.6 successfully accessed sql2008r2 on iis

Php 5.6.11 successfully accessed sql2008r2 on apache

[5.2.6-> SQL2000]

Why test with the old php version 5.2.6, because php version 5.2 has a built-in php_mssql.dll module?

The extension=php_mssql.dll configuration option in php.ini is enabled, and mssql2000 seems to be supported by default.

Open phpinfo to see the contents of the relevant support modules:

It is now convenient to install PHP under PS.IIS 7.0. you can install it through a third-party gadget PHP Manager, or you can easily switch the php version under iis. This is not the main content of this article, so we will not introduce it here.

Download and install php manager for iis 7 address: http://phpmanager.codeplex.com/

Write a small routine for a test:

The result of running under IIS 7.5 is as follows: successful!

[5.6.11-> SQL2008R2]

Php_mssql.dll is no longer available for more than 5.6 PHP, and it seems that sql server versions above sql2000 are no longer natively supported. You can find them on Microsoft's official website through third-party modules:

Microsoft Drivers for PHP for SQL Server

Http://www.microsoft.com/en-us/download/details.aspx?id=20098

There are four files in the download link address:

SQLSRV30.EXE

SQLSRV31.EXE

SQLSRV32.EXE

SQLSRV40.EXE

Different versions of PHp are supported

Version 4.0 supports PHP 7.0 +

Version 3.2 supports PHP 5.6, 5.5, and 5.4

Version 3.1 supports PHP 5.5 and 5.4

Version 3.0 supports PHP 5.4.

If you want to download a SQLSRV20.EXE for PHP 5.2, this file can also be easily found on the Internet.

(although the old version 5.2 should have been eliminated a long time ago, it is still needed in some environments.)

Php_pdo_sqlsrv_52_ts_vc6.dll

Php_sqlsrv_52_ts_vc6.dll

1. I have PHP 5.6.11 win32 ts in my hand, and I need this.

Php_sqlsrv_56_ts.dll

Php_pdo_sqlsrv_56_ts.dll

Copy these two files to the php\ ext directory

2. Add the following two sentences to php.ini:

Extension=C:\ PHP5\ ext\ php_sqlsrv_56_ts.dll

Extension=C:\ PHP5\ ext\ php_pdo_sqlsrv_56_ts.dll

3. Restart IIS or Apache

4. Through phpinfo, you can see that the following module shows that our PHP should be able to access SQL Server 2008R2 at this time

5. Write a Mini Program to verify:

If the following prompt appears:

You may also need to install Microsoft ®ODBC Driver 11 for SQL Server ®- Windows

Download address: https://www.microsoft.com/zh-cn/download/details.aspx?id=36434

If it is correct, it should be OK:

PS. Since the new module accesses SQL Server 2008R2 through PDO, if it is accessed locally, it can be accessed directly through ip address and sa account.

If php and sql2008r2 are on different computers, you have to set TCP port 1433 to access. See the second figure below. Change the dynamic port to 0 and set the port to 14333. If your SQL2000 already occupies 1433, add a xxxx port number after the access address.

Sqlsrv:Server=192.168.1.xxx\ sql2008r2,14333;Database=master

The above is all the contents of the article "sample Analysis of several situations in which PHP5.6.11 visits SQL Server2008R2". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.