引用地址：

https://docs.microsoft.com/en-us/sql/connect/php/system-requirements-for-the-php-sql-driver?view=sql-server-2017

System Requirements for the Microsoft Drivers for PHP for SQL Server

In this article

  1. PHP
  2. ODBC Driver
  3. SQL Server
  4. Operating Systems
  5. Driver Versions
  6. See Also

Download PHP Driver

This document lists the components that must be installed on your system to access data in a SQL Server or Azure SQL Database using the Microsoft Drivers for PHP for SQL Server.

Versions 3.1 and later of the Microsoft PHP Drivers for SQL Server are officially supported. For full details on support lifecycles and requirements including earlier versions of the PHP drivers, see the support matrix.

PHP

For information about how to download and install the latest stable PHP binaries, see the PHP web site. The Microsoft Drivers for PHP for SQL Server require the following versions of PHP:

PHP for SQL Server driver version →
↓ PHP version		 5.6 5.3 5.2 4.3 4.0 3.2 3.1
7.3 7.3.0+            
7.2 7.2+1 7.2+1 7.2+1        
7.1 7.1.0+ 7.1.0+ 7.1.0+ 7.1.0+      
7.0   7.0.0+ 7.0.0+ 7.0.0+ 7.0.0+    
5.6           5.6.4+  
5.5           5.5.16+ 5.5.16+
5.4           5.4.32 5.4.32
  1. Versions 7.2.1 and later are supported on Windows, while versions 7.2.0 and later are supported on Linux and macOS.

ODBC Driver

The correct version of the Microsoft ODBC Driver for SQL Server is required on the computer on which PHP is running. You can download all supported versions of the driver for supported platforms on this page.

If you are downloading the Windows version of the driver on a 64-bit version of Windows, the ODBC 64-bit installer installs both 32-bit and 64-bit ODBC drivers. If you use a 32-bit version of Windows, use the ODBC x86 installer. On non-Windows platforms, only 64-bit versions of the driver are available.

PHP for SQL Server driver version →
↓ ODBC Driver version		 5.6 5.3 5.2 4.3 4.0 3.2 3.1
ODBC Driver 17+ Y Y Y        
ODBC Driver 13.1 Y Y Y Y Y    
ODBC Driver 13         Y    
ODBC Driver 11 Y Y Y Y Y Y Y

If you are using the SQLSRV driver, sqlsrv_client_info returns information about which version of SQL Server Microsoft ODBC Driver for SQL Server is being used by the Microsoft Drivers for PHP for SQL Server. If you are using the PDO_SQLSRV driver, you can use PDO::getAttribute to discover the version.

SQL Server

Azure SQL Databases are supported. For information, see Connecting to Microsoft Azure SQL Database.

PHP for SQL Server driver version →
↓ SQL Server version		 5.6 5.3 5.2 4.3 4.0 3.2 3.1
Azure SQL Database Y Y Y Y      
Azure SQL Managed Instance Y Y Y Y      
Azure SQL Data Warehouse Y Y Y Y      
SQL Server 2017 Y Y Y Y      
SQL Server 2016 Y Y Y Y Y    
SQL Server 2014 Y Y Y Y Y Y Y
SQL Server 2012 Y Y Y Y Y Y Y
SQL Server 2008 R2 Y Y Y Y Y Y Y
SQL Server 2008         Y Y Y

Operating Systems

Supported operating systems for each version of the driver are as follows:

PHP for SQL Server driver version →
↓ Operating system		 5.6 5.3 5.2 4.3 4.0 3.2 3.1
Windows Server 2016 Y Y Y Y      
Windows Server 2012 R2 Y Y Y Y Y Y Y
Windows Server 2012 Y Y Y Y Y Y Y
Windows Server 2008 R2 SP1         Y Y Y
Windows Server 2008 SP2         Y Y Y
Windows 10 Y Y Y Y Y    
Windows 8.1 Y Y Y Y Y Y Y
Windows 8       Y Y Y Y
Windows 7 SP1         Y Y Y
Windows Vista SP2         Y Y Y
Ubuntu 18.10 (64-bit) Y            
Ubuntu 18.04 (64-bit) Y Y          
Ubuntu 17.10 (64-bit)   Y Y        
Ubuntu 16.04 (64-bit) Y Y Y Y Y    
Ubuntu 15.10 (64-bit)       Y      
Ubuntu 15.04 (64-bit)         Y    
Debian 9 (64-bit) Y Y Y        
Debian 8 (64-bit) Y Y Y Y      
Red Hat Enterprise Linux 7 (64-bit) Y Y Y Y Y    
Suse Enterprise Linux 15 (64-bit) Y            
Suse Enterprise Linux 12 (64-bit) Y Y Y        
macOS Mojave (64-bit) Y            
macOS High Sierra (64-bit) Y Y          
macOS Sierra (64-bit) Y Y Y Y      
macOS El Capitan (64-bit)   Y Y Y      

Driver Versions

This section lists the driver files that are included with each version of the Microsoft Drivers for PHP for SQL Server. Each installation package contains SQLSRV and PDO_SQLSRV driver files in threaded and non-threaded variants. On Windows, they are also available in 32-bit and 64-bit variants. To configure the driver for use with the PHP runtime, follow the installation instructions in Loading the Microsoft Drivers for PHP for SQL Server.

On supported versions of Linux and macOS, the appropriate drivers can be installed using PHP's PECL package system, following the Linux and macOS installation instructions. Alternatively, you can download prebuilt binaries for your platform from the Microsoft Drivers for PHP for SQL Server Github project page -- the tables below list the files found in the prebuilt binary packages.

Microsoft Drivers 5.6 for PHP for SQL Server:

On Windows, the following versions of the driver are included:

Driver file PHP version Thread safe? Use with PHP .dll
32-bit php_sqlsrv_71_nts.dll
32-bit php_pdo_sqlsrv_71_nts.dll		 7.1 no 32-bit php7.dll
32-bit php_sqlsrv_71_ts.dll
32-bit php_pdo_sqlsrv_71_ts.dll		 7.1 yes 32-bit php7ts.dll
64-bit php_sqlsrv_71_nts.dll
64-bit php_pdo_sqlsrv_71_nts.dll		 7.1 no 64-bit php7.dll
64-bit php_sqlsrv_71_ts.dll
64-bit php_pdo_sqlsrv_71_ts.dll		 7.1 yes 64-bit php7ts.dll
32-bit php_sqlsrv_72_nts.dll
32-bit php_pdo_sqlsrv_72_nts.dll		 7.2 no 32-bit php7.dll
32-bit php_sqlsrv_72_ts.dll
32-bit php_pdo_sqlsrv_72_ts.dll		 7.2 yes 32-bit php7ts.dll
64-bit php_sqlsrv_72_nts.dll
64-bit php_pdo_sqlsrv_72_nts.dll		 7.2 no 64-bit php7.dll
64-bit php_sqlsrv_72_ts.dll
64-bit php_pdo_sqlsrv_72_ts.dll		 7.2 yes 64-bit php7ts.dll
32-bit php_sqlsrv_73_nts.dll
32-bit php_pdo_sqlsrv_73_nts.dll		 7.3 no 32-bit php7.dll
32-bit php_sqlsrv_73_ts.dll
32-bit php_pdo_sqlsrv_73_ts.dll		 7.3 yes 32-bit php7ts.dll
64-bit php_sqlsrv_73_nts.dll
64-bit php_pdo_sqlsrv_73_nts.dll		 7.3 no 64-bit php7.dll
64-bit php_sqlsrv_73_ts.dll
64-bit php_pdo_sqlsrv_73_ts.dll		 7.3 yes 64-bit php7ts.dll

On Linux, the following versions of the driver are included:

Driver file PHP version Thread safe?
php_sqlsrv_71_nts.so
php_pdo_sqlsrv_71_nts.so		 7.1 no
php_sqlsrv_71_ts.so
php_pdo_sqlsrv_71_ts.so		 7.1 yes
php_sqlsrv_72_nts.so
php_pdo_sqlsrv_72_nts.so		 7.2 no
php_sqlsrv_72_ts.so
php_pdo_sqlsrv_72_ts.so		 7.2 yes
php_sqlsrv_73_nts.so
php_pdo_sqlsrv_73_nts.so		 7.3 no
php_sqlsrv_73_ts.so
php_pdo_sqlsrv_73_ts.so		 7.3 yes

Microsoft Drivers 5.3 for PHP for SQL Server:

On Windows, the following versions of the driver are included:

Driver file PHP version Thread safe? Use with PHP .dll
32-bit php_sqlsrv_7_nts.dll
32-bit php_pdo_sqlsrv_7_nts.dll		 7.0 no 32-bit php7.dll
32-bit php_sqlsrv_7_ts.dll
32-bit php_pdo_sqlsrv_7_ts.dll		 7.0 yes 32-bit php7ts.dll
64-bit php_sqlsrv_7_nts.dll
64-bit php_pdo_sqlsrv_7_nts.dll		 7.0 no 64-bit php7.dll
64-bit php_sqlsrv_7_ts.dll
64-bit php_pdo_sqlsrv_7_ts.dll		 7.0 yes 64-bit php7ts.dll
32-bit php_sqlsrv_71_nts.dll
32-bit php_pdo_sqlsrv_71_nts.dll		 7.1 no 32-bit php7.dll
32-bit php_sqlsrv_71_ts.dll
32-bit php_pdo_sqlsrv_71_ts.dll		 7.1 yes 32-bit php7ts.dll
64-bit php_sqlsrv_71_nts.dll
64-bit php_pdo_sqlsrv_71_nts.dll		 7.1 no 64-bit php7.dll
64-bit php_sqlsrv_71_ts.dll
64-bit php_pdo_sqlsrv_71_ts.dll		 7.1 yes 64-bit php7ts.dll
32-bit php_sqlsrv_72_nts.dll
32-bit php_pdo_sqlsrv_72_nts.dll		 7.2 no 32-bit php7.dll
32-bit php_sqlsrv_72_ts.dll
32-bit php_pdo_sqlsrv_72_ts.dll		 7.2 yes 32-bit php7ts.dll
64-bit php_sqlsrv_72_nts.dll
64-bit php_pdo_sqlsrv_72_nts.dll		 7.2 no 64-bit php7.dll
64-bit php_sqlsrv_72_ts.dll
64-bit php_pdo_sqlsrv_72_ts.dll		 7.2 yes 64-bit php7ts.dll

On Linux, the following versions of the driver are included:

Driver file PHP version Thread safe?
php_sqlsrv_7_nts.so
php_pdo_sqlsrv_7_nts.so		 7.0 no
php_sqlsrv_7_ts.so
php_pdo_sqlsrv_7_ts.so		 7.0 yes
php_sqlsrv_71_nts.so
php_pdo_sqlsrv_71_nts.so		 7.1 no
php_sqlsrv_71_ts.so
php_pdo_sqlsrv_71_ts.so		 7.1 yes
php_sqlsrv_72_nts.so
php_pdo_sqlsrv_72_nts.so		 7.2 no
php_sqlsrv_72_ts.so
php_pdo_sqlsrv_72_ts.so		 7.2 yes

Microsoft Drivers 5.2 for PHP for SQL Server:

On Windows, the following versions of the driver are included:

Driver file PHP version Thread safe? Use with PHP .dll
32-bit php_sqlsrv_7_nts.dll
32-bit php_pdo_sqlsrv_7_nts.dll		 7.0 no 32-bit php7.dll
32-bit php_sqlsrv_7_ts.dll
32-bit php_pdo_sqlsrv_7_ts.dll		 7.0 yes 32-bit php7ts.dll
64-bit php_sqlsrv_7_nts.dll
64-bit php_pdo_sqlsrv_7_nts.dll		 7.0 no 64-bit php7.dll
64-bit php_sqlsrv_7_ts.dll
64-bit php_pdo_sqlsrv_7_ts.dll		 7.0 yes 64-bit php7ts.dll
32-bit php_sqlsrv_71_nts.dll
32-bit php_pdo_sqlsrv_71_nts.dll		 7.1 no 32-bit php7.dll
32-bit php_sqlsrv_71_ts.dll
32-bit php_pdo_sqlsrv_71_ts.dll		 7.1 yes 32-bit php7ts.dll
64-bit php_sqlsrv_71_nts.dll
64-bit php_pdo_sqlsrv_71_nts.dll		 7.1 no 64-bit php7.dll
64-bit php_sqlsrv_71_ts.dll
64-bit php_pdo_sqlsrv_71_ts.dll		 7.1 yes 64-bit php7ts.dll
32-bit php_sqlsrv_72_nts.dll
32-bit php_pdo_sqlsrv_72_nts.dll		 7.2 no 32-bit php7.dll
32-bit php_sqlsrv_72_ts.dll
32-bit php_pdo_sqlsrv_72_ts.dll		 7.2 yes 32-bit php7ts.dll
64-bit php_sqlsrv_72_nts.dll
64-bit php_pdo_sqlsrv_72_nts.dll		 7.2 no 64-bit php7.dll
64-bit php_sqlsrv_72_ts.dll
64-bit php_pdo_sqlsrv_72_ts.dll		 7.2 yes 64-bit php7ts.dll

On Linux, the following versions of the driver are included:

Driver file PHP version Thread safe?
php_sqlsrv_7_nts.so
php_pdo_sqlsrv_7_nts.so		 7.0 no
php_sqlsrv_7_ts.so
php_pdo_sqlsrv_7_ts.so		 7.0 yes
php_sqlsrv_71_nts.so
php_pdo_sqlsrv_71_nts.so		 7.1 no
php_sqlsrv_71_ts.so
php_pdo_sqlsrv_71_ts.so		 7.1 yes
php_sqlsrv_72_nts.so
php_pdo_sqlsrv_72_nts.so		 7.2 no
php_sqlsrv_72_ts.so
php_pdo_sqlsrv_72_ts.so		 7.2 yes

Microsoft Drivers 4.3 for PHP for SQL Server:

On Windows, the following versions of the driver are included:

Driver file PHP version Thread safe? Use with PHP .dll
32-bit php_sqlsrv_7_nts.dll
32-bit php_pdo_sqlsrv_7_nts.dll		 7.0 no 32-bit php7.dll
32-bit php_sqlsrv_7_ts.dll
32-bit php_pdo_sqlsrv_7_ts.dll		 7.0 yes 32-bit php7ts.dll
64-bit php_sqlsrv_7_nts.dll
64-bit php_pdo_sqlsrv_7_nts.dll		 7.0 no 64-bit php7.dll
64-bit php_sqlsrv_7_ts.dll
64-bit php_pdo_sqlsrv_7_ts.dll		 7.0 yes 64-bit php7ts.dll
32-bit php_sqlsrv_71_nts.dll
32-bit php_pdo_sqlsrv_71_nts.dll		 7.1 no 32-bit php7.dll
32-bit php_sqlsrv_71_ts.dll
32-bit php_pdo_sqlsrv_71_ts.dll		 7.1 yes 32-bit php7ts.dll
64-bit php_sqlsrv_71_nts.dll
64-bit php_pdo_sqlsrv_71_nts.dll		 7.1 no 64-bit php7.dll
64-bit php_sqlsrv_71_ts.dll
64-bit php_pdo_sqlsrv_71_ts.dll		 7.1 yes 64-bit php7ts.dll

On Linux, the following versions of the driver are included:

Driver file PHP version Thread safe?
php_sqlsrv_7_nts.so
php_pdo_sqlsrv_7_nts.so		 7.0 no
php_sqlsrv_7_ts.so
php_pdo_sqlsrv_7_ts.so		 7.0 yes
php_sqlsrv_71_nts.so
php_pdo_sqlsrv_71_nts.so		 7.1 no
php_sqlsrv_71_ts.so
php_pdo_sqlsrv_71_ts.so		 7.1 yes

Microsoft Drivers 4.0 for PHP for SQL Server:

On Windows, the following versions of the driver are included:

Driver file PHP version Thread safe? Use with PHP .dll
php_sqlsrv_7_nts_x86.dll
php_pdo_sqlsrv_7_nts_x86.dll		 7.0 no 32-bit php7.dll
php_sqlsrv_7_ts_x86.dll
php_pdo_sqlsrv_7_ts_x86.dll		 7.0 yes 32-bit php7ts.dll
php_sqlsrv_7_nts_x64.dll
php_pdo_sqlsrv_7_nts_x64.dll		 7.0 no 64-bit php7.dll
php_sqlsrv_7_ts_x64.dll
php_pdo_sqlsrv_7_ts_x64.dll		 7.0 yes 64-bit php7ts.dll

On Linux, the following versions of the driver are included:

Driver file PHP version Thread safe?
php_sqlsrv_7_nts.so
php_pdo_sqlsrv_7_nts.so		 7.0 no
php_sqlsrv_7_ts.so
php_pdo_sqlsrv_7_ts.so		 7.0 yes

Microsoft Drivers 3.2 for PHP for SQL Server:

On Windows, the following versions of the driver are included:

Driver file PHP version Thread safe? Use with PHP .dll
php_sqlsrv_54_nts.dll
php_pdo_sqlsrv_54_nts.dll		 5.4 no php5.dll
php_sqlsrv_54_ts.dll
php_pdo_sqlsrv_54_ts.dll		 5.4 yes php5ts.dll
php_sqlsrv_55_nts.dll
php_pdo_sqlsrv_55_nts.dll		 5.5 no php5.dll
php_sqlsrv_55_ts.dll
php_pdo_sqlsrv_55_ts.dll		 5.5 yes php5ts.dll
php_sqlsrv_56_nts.dll
php_pdo_sqlsrv_56_nts.dll		 5.6 no php5.dll
php_sqlsrv_56_ts.dll
php_pdo_sqlsrv_56_ts.dll		 5.6 yes php5ts.dll

Microsoft Drivers 3.1 for PHP for SQL Server:

On Windows, the following versions of the driver are included:

Driver file PHP version Thread safe? Use with PHP .dll
php_sqlsrv_54_nts.dll
php_pdo_sqlsrv_54_nts.dll		 5.4 no php5.dll
php_sqlsrv_54_ts.dll
php_pdo_sqlsrv_54_ts.dll		 5.4 yes php5ts.dll
php_sqlsrv_55_nts.dll
php_pdo_sqlsrv_55_nts.dll		 5.5 no php5.dll
php_sqlsrv_55_ts.dll
php_pdo_sqlsrv_55_ts.dll		 5.5 yes php5ts.dll

See Also

Getting Started with the Microsoft Drivers for PHP for SQL Server

Programming Guide for the Microsoft Drivers for PHP for SQL Server

SQLSRV Driver API Reference

PDO_SQLSRV Driver API Reference

最新文章

  1. php工作笔记8-并发和数据类型
  2. shell脚本的执行方式
  3. C++中的内联成员函数与非内联成员函数
  4. UVALive 6125 I’ve Got Your Back(gammon) 题解
  5. js库之art.dialog
  6. c#中如何做日期的三元判断（日期不为空赋值）
  7. linux 网桥的配置与实现
  8. C#简单实现发送手机短信
  9. 关于HttpsURLConnection的连接问题
  10. SVN—patch的应用
  11. 解决Cell重用内容混乱的几种简单方法,有些方法会增加内存
  12. debian-pve-ceph
  13. 【漫画解读】HDFS存储原理
  14. WebSocket实战之——JavaScript例子
  15. 20165310 NstSec2019 Week1 Exp0 Kali安装
  16. Java Map释放内存置null以及调用clear()的区别
  17. python的动态加载机制？？
  18. [工具]JSON校验、转换在线工具
  19. Kettle中配置oracle RAC
  20. 小白学flask之路由，反向路由，路由参数

热门文章

  1. JAVA程序的基本结构
  2. 服务端spark gbdt模型计算性能优化
  3. BZOJ.4182.Shopping(点分治/dsu on tree 树形依赖背包 多重背包 单调队列)
  4. Shell脚本笔记（八）循环
  5. linux 文件打包压缩成.tar.gz
  6. AC自动机相关Fail树和Trie图相关基础知识
  7. Markdown使用简介 及 学习资源整理
  8. 屏幕录制软件camtasia studio 8序列号激活
  9. Ruby语法基础(二)
  10. mysql连接查询（A表某字段 like B表字段）