Skip to content

Commit aa53b2e

Browse files
authored
Merge pull request #21047 from yitam/php510
Update documentation for php 5.10
2 parents 73ecacd + 0403b93 commit aa53b2e

7 files changed

Lines changed: 455 additions & 145 deletions

docs/connect/php/download-drivers-php-sql-server.md

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
title: "Download the Microsoft Drivers for PHP for SQL Server"
33
description: "Download the Microsoft Drivers for PHP for SQL Server to develop PHP applications that connect to SQL Server and Azure SQL Database."
44
ms.custom: ""
5-
ms.date: "01/29/2021"
5+
ms.date: 01/20/2022
66
ms.prod: sql
77
ms.prod_service: connectivity
88
ms.reviewer: ""
@@ -19,15 +19,15 @@ On Linux and macOS, the drivers for PHP are easily downloaded and installed usin
1919

2020
## Download
2121

22-
Microsoft Drivers 5.9 for PHP for SQL Server is the latest general availability (GA) version.
22+
Microsoft Drivers 5.10 for PHP for SQL Server is the latest general availability (GA) version.
2323

24-
**[![Download](../../ssms/media/download-icon.png) Download Microsoft Drivers for PHP for SQL Server (Windows)](https://go.microsoft.com/fwlink/?linkid=2152937)**
25-
[GitHub Release Tag v5.9.0 (Linux and macOS packages are available here)](https://github.com/Microsoft/msphpsql/releases/tag/v5.9.0)
24+
**[![Download](../../ssms/media/download-icon.png) Download Microsoft Drivers for PHP for SQL Server (Windows)](https://go.microsoft.com/fwlink/?linkid=2185805)**
25+
[GitHub Release Tag v5.10.0 (Linux and macOS packages are available here)](https://github.com/Microsoft/msphpsql/releases/tag/v5.10.0)
2626

2727
### Version information
2828

29-
- Release number: 5.9.0
30-
- Released: January 29, 2021
29+
- Release number: 5.10.0
30+
- Released: January 31, 2022
3131

3232
If you have feedback, the best way to contact the Microsoft Drivers for PHP for SQL Server team is by filing an issue on the [GitHub repository](https://github.com/Microsoft/msphpsql/issues).
3333

docs/connect/php/installation-tutorial-linux-mac.md

Lines changed: 81 additions & 58 deletions
Large diffs are not rendered by default.

docs/connect/php/microsoft-php-drivers-for-sql-server-support-matrix.md

Lines changed: 80 additions & 69 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
title: "Microsoft Drivers for PHP Support Matrix"
33
description: "This page contains the support matrix and support lifecycle policy for the Microsoft PHP Drivers for SQL Server."
44
ms.custom: ""
5-
ms.date: "01/29/2021"
5+
ms.date: 01/24/2022
66
ms.prod: sql
77
ms.prod_service: connectivity
88
ms.reviewer: ""
@@ -27,19 +27,20 @@ The following Microsoft PHP Drivers are supported, until the indicated End of Su
2727

2828
|Driver Name|Driver Package Version|End of Mainstream Support|
2929
|-|:-:|-|
30+
|Microsoft PHP Drivers 5.10 for SQL Server|5.10|January 31, 2027|
3031
|Microsoft PHP Drivers 5.9 for SQL Server|5.9|January 29, 2026|
3132
|Microsoft PHP Drivers 5.8 for SQL Server|5.8|January 31, 2025|
3233
|Microsoft PHP Drivers 5.6 for SQL Server|5.6|February 21, 2024|
3334
|Microsoft PHP Drivers 5.3 for SQL Server|5.3|July 20, 2023|
3435
|Microsoft PHP Drivers 5.2 for SQL Server|5.2|February 9, 2023|
3536
|Microsoft PHP Drivers 4.3 for SQL Server|4.3|July 6, 2022|
36-
|Microsoft PHP Drivers 4.0 for SQL Server|4.0|July 11, 2021|
3737
|   |   |   |
3838

3939
The following Microsoft PHP Drivers are no longer supported.
4040

4141
|Driver Name|Driver Package Version|End of Mainstream Support|
4242
|-|:-:|-|
43+
|Microsoft PHP Drivers 4.0 for SQL Server|4.0|July 11, 2021|
4344
|Microsoft PHP Drivers 3.2 for SQL Server|3.2|March 9, 2020|
4445
|Microsoft PHP Drivers 3.1 for SQL Server|3.1|December 12, 2019|
4546
|Microsoft PHP Drivers 3.0 for SQL Server|3.0|March 6, 2017|
@@ -50,90 +51,100 @@ The following Microsoft PHP Drivers are no longer supported.
5051
## SQL Server Version Certified Compatibility
5152
The following matrix lists database versions that have been tested and certified as compatible with the corresponding driver version. We strive to maintain backward compatibility with previous driver versions, but only the latest supported driver is tested and certified with new SQL Server versions as SQL Server is released.
5253

53-
|Driver version&nbsp;&#8594;<br />&#8595; Database version|5.9|5.8|5.6|5.3|5.2|4.3|4.0|3.2|
54-
|---|---|:---:|:---:|:---:|:---:|:---:|:---:|:---:|
55-
|Azure SQL Database |Yes|Yes|Yes|Yes|Yes|Yes| | |
56-
|Azure SQL Managed Instance|Yes|Yes|Yes|Yes|Yes|Yes| | |
57-
|Azure Synapse Analytics |Yes|Yes|Yes|Yes|Yes|Yes| | |
58-
|SQL Server 2019 |Yes|Yes| | | | | | |
59-
|SQL Server 2017 |Yes|Yes|Yes|Yes|Yes|Yes| | |
60-
|SQL Server 2016 |Yes|Yes|Yes|Yes|Yes|Yes|Yes| |
61-
|SQL Server 2014 |Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|
62-
|SQL Server 2012 |Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|
63-
|SQL Server 2008 R2 | | |Yes|Yes|Yes|Yes|Yes|Yes|
64-
|SQL Server 2008 | | | | | | |Yes|Yes|
65-
| &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; |
54+
|Driver version&nbsp;&#8594;<br />&#8595; Database version|5.10|5.9|5.8|5.6|5.3|5.2|4.3|4.0|3.2|
55+
|---|---|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|
56+
|Azure SQL Database |Yes|Yes|Yes|Yes|Yes|Yes|Yes| | |
57+
|Azure SQL Managed Instance|Yes|Yes|Yes|Yes|Yes|Yes|Yes| | |
58+
|Azure Synapse Analytics |Yes|Yes|Yes|Yes|Yes|Yes|Yes| | |
59+
|SQL Server 2019 |Yes|Yes|Yes| | | | | | |
60+
|SQL Server 2017 |Yes|Yes|Yes|Yes|Yes|Yes|Yes| | |
61+
|SQL Server 2016 |Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes| |
62+
|SQL Server 2014 |Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|
63+
|SQL Server 2012 |Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|
64+
|SQL Server 2008 R2 | | | |Yes|Yes|Yes|Yes|Yes|Yes|
65+
|SQL Server 2008 | | | | | | | |Yes|Yes|
66+
| &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; |
6667

6768
For information about using PHP with Azure SQL Database, see [Connecting to Microsoft Azure SQL Database](connecting-to-microsoft-azure-sql-database.md).
6869

6970
## PHP Version Support
7071

7172
The following versions of PHP are supported with the listed version of the Microsoft PHP Drivers:
7273

73-
|Driver version&nbsp;&#8594;<br />&#8595; PHP version|5.9|5.8|5.6|5.3|5.2|4.3|4.0|3.2|
74-
|:---:|---|---|---|---|---|---|---|---|
75-
|8.0|8.0.0+ | | | | | | | |
76-
|7.4|7.4.0+ |7.4.0+ | | | | | | |
77-
|7.3|7.3.0+ |7.3.0+ |7.3.0+ | | | | | |
78-
|7.2| |7.2+<sup>1</sup>|7.2+<sup>1</sup>|7.2+<sup>1</sup>|7.2+<sup>1</sup>| | | |
79-
|7.1| | |7.1.0+ |7.1.0+ |7.1.0+ |7.1.0+ | | |
80-
|7.0| | | |7.0.0+ |7.0.0+ |7.0.0+ |7.0.0+ | |
81-
|5.6| | | | | | | |5.6.4+ |
82-
|5.5| | | | | | | |5.5.16+ |
83-
|5.4| | | | | | | |5.4.32 |
84-
| &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; |
74+
|Driver version&nbsp;&#8594;<br />&#8595; PHP version|5.10|5.9|5.8|5.6|5.3|5.2|4.3|4.0|3.2|
75+
|:---:|---|---|---|---|---|---|---|---|---|
76+
|8.1|8.1.0+ | | | | | | | | |
77+
|8.0|8.0.0+ |8.0.0+ | | | | | | | |
78+
|7.4|7.4.0+ |7.4.0+ |7.4.0+ | | | | | | |
79+
|7.3| |7.3.0+ |7.3.0+ |7.3.0+ | | | | | |
80+
|7.2| | |7.2+<sup>1</sup>|7.2+<sup>1</sup>|7.2+<sup>1</sup>|7.2+<sup>1</sup>| | | |
81+
|7.1| | | |7.1.0+ |7.1.0+ |7.1.0+ |7.1.0+ | | |
82+
|7.0| | | | |7.0.0+ |7.0.0+ |7.0.0+ |7.0.0+ | |
83+
|5.6| | | | | | | | |5.6.4+ |
84+
|5.5| | | | | | | | |5.5.16+|
85+
|5.4| | | | | | | | |5.4.32 |
86+
| &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; |
8587

8688
<sup>1</sup> Versions 7.2.1 and later are supported on Windows, while versions 7.2.0 and later are supported on Linux and macOS.
8789

8890
## Supported Operating Systems
8991

9092
The following Windows operating system versions are supported with the listed version of the Microsoft PHP Drivers:
9193

92-
|Driver version&nbsp;&#8594;<br />&#8595; Operating system|5.9|5.8|5.6|5.3|5.2|4.3|4.0|3.2|
93-
|---|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|
94-
|Windows Server 2019 |Yes|Yes|Yes| | | | | |
95-
|Windows Server 2016 |Yes|Yes|Yes|Yes|Yes|Yes| | |
96-
|Windows Server 2012 R2 |Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|
97-
|Windows Server 2012 |Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|
98-
|Windows Server 2008 R2 SP1 | | | | | | |Yes|Yes|
99-
|Windows Server 2008 R2 | | | | | | | | |
100-
|Windows Server 2008 SP2 | | | | | | |Yes|Yes|
101-
|Windows 10 |Yes|Yes|Yes|Yes|Yes|Yes|Yes| |
102-
|Windows 8.1 |Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|
103-
|Windows 8 | | | | | |Yes|Yes|Yes|
104-
|Windows 7 SP1 | | | | | | |Yes|Yes|
105-
|Windows Vista SP2 | | | | | | |Yes|Yes|
106-
| &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; |
94+
|Driver version&nbsp;&#8594;<br />&#8595; Operating system|5.10|5.9|5.8|5.6|5.3|5.2|4.3|4.0|3.2|
95+
|---|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|
96+
|Windows Server 2022 |Yes| | | | | | | | |
97+
|Windows Server 2019 |Yes|Yes|Yes|Yes| | | | | |
98+
|Windows Server 2016 |Yes|Yes|Yes|Yes|Yes|Yes|Yes| | |
99+
|Windows Server 2012 R2 |Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|
100+
|Windows Server 2012 |Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|
101+
|Windows Server 2008 R2 SP1 | | | | | | | |Yes|Yes|
102+
|Windows Server 2008 R2 | | | | | | | | | |
103+
|Windows Server 2008 SP2 | | | | | | | |Yes|Yes|
104+
|Windows 11 |Yes| | | | | | | | |
105+
|Windows 10 |Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes| |
106+
|Windows 8.1 |Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes|
107+
|Windows 8 | | | | | | |Yes|Yes|Yes|
108+
|Windows 7 SP1 | | | | | | | |Yes|Yes|
109+
|Windows Vista SP2 | | | | | | | |Yes|Yes|
110+
| &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; |
107111

108112
The following Linux and macOS operating system versions (64-bit only) are supported with the listed version of the Microsoft PHP Drivers:
109113

110-
|Driver version&nbsp;&#8594;<br />&#8595; Operating system|5.9|5.8|5.6|5.3|5.2|4.3|4.0|3.2|
111-
|---|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|
112-
|Ubuntu 20.10 (64-bit) |Yes| | | | | | | |
113-
|Ubuntu 20.04 (64-bit) |Yes|Yes| | | | | | |
114-
|Ubuntu 19.10 (64-bit) | |Yes| | | | | | |
115-
|Ubuntu 18.10 (64-bit) | | |Yes| | | | | |
116-
|Ubuntu 18.04 (64-bit) |Yes|Yes|Yes|Yes| | | | |
117-
|Ubuntu 17.10 (64-bit) | | | |Yes|Yes| | | |
118-
|Ubuntu 16.04 (64-bit) |Yes|Yes|Yes|Yes|Yes|Yes|Yes| |
119-
|Ubuntu 15.10 (64-bit) | | | | | |Yes| | |
120-
|Ubuntu 15.04 (64-bit) | | | | | | |Yes| |
121-
|Debian 10 (64-bit) |Yes|Yes| | | | | | |
122-
|Debian 9 (64-bit) |Yes|Yes|Yes|Yes|Yes| | | |
123-
|Debian 8 (64-bit) | |Yes|Yes|Yes|Yes|Yes| | |
124-
|Red Hat Enterprise Linux 8 (64-bit) |Yes|Yes| | | | | | |
125-
|Red Hat Enterprise Linux 7 (64-bit) |Yes|Yes|Yes|Yes|Yes|Yes|Yes| |
126-
|Suse Enterprise Linux 15 (64-bit) |Yes|Yes|Yes| | | | | |
127-
|Suse Enterprise Linux 12 (64-bit) |Yes|Yes|Yes|Yes|Yes| | | |
128-
|Alpine Linux 3.12 (64-bit) |Yes| | | | | | | |
129-
|Alpine Linux 3.11 (64-bit) |Yes|Yes<sup>1</sup>| | | | | | |
130-
|macOS Big Sur (64-bit) |Yes| | | | | | | |
131-
|macOS Catalina (64-bit) |Yes|Yes| | | | | | |
132-
|macOS Mojave (64-bit) |Yes|Yes|Yes| | | | | |
133-
|macOS High Sierra (64-bit) | |Yes|Yes|Yes| | | | |
134-
|macOS Sierra (64-bit) | | |Yes|Yes|Yes|Yes| | |
135-
|macOS El Capitan (64-bit) | | | |Yes|Yes|Yes| | |
136-
| &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; |
114+
|Driver version&nbsp;&#8594;<br />&#8595; Operating system|5.10|5.9|5.8|5.6|5.3|5.2|4.3|4.0|3.2|
115+
|---|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|:---:|
116+
|Ubuntu 21.10 (64-bit) |Yes| | | | | | | | |
117+
|Ubuntu 21.04 (64-bit) |Yes| | | | | | | | |
118+
|Ubuntu 20.10 (64-bit) | |Yes| | | | | | | |
119+
|Ubuntu 20.04 (64-bit) |Yes|Yes|Yes| | | | | | |
120+
|Ubuntu 19.10 (64-bit) | | |Yes| | | | | | |
121+
|Ubuntu 18.10 (64-bit) | | | |Yes| | | | | |
122+
|Ubuntu 18.04 (64-bit) |Yes|Yes|Yes|Yes|Yes| | | | |
123+
|Ubuntu 17.10 (64-bit) | | | | |Yes|Yes| | | |
124+
|Ubuntu 16.04 (64-bit) | |Yes|Yes|Yes|Yes|Yes|Yes|Yes| |
125+
|Ubuntu 15.10 (64-bit) | | | | | | |Yes| | |
126+
|Ubuntu 15.04 (64-bit) | | | | | | | |Yes| |
127+
|Debian 11 (64-bit) |Yes| | | | | | | | |
128+
|Debian 10 (64-bit) |Yes|Yes|Yes|Yes| | | | | |
129+
|Debian 9 (64-bit) |Yes|Yes|Yes|Yes|Yes|Yes| | | |
130+
|Debian 8 (64-bit) | | |Yes|Yes|Yes|Yes|Yes| | |
131+
|Red Hat Enterprise Linux 8 (64-bit) |Yes|Yes|Yes| | | | | | |
132+
|Red Hat Enterprise Linux 7 (64-bit) |Yes|Yes|Yes|Yes|Yes|Yes|Yes|Yes| |
133+
|Suse Enterprise Linux 15 (64-bit) |Yes|Yes|Yes|Yes| | | | | |
134+
|Suse Enterprise Linux 12 (64-bit) |Yes|Yes|Yes|Yes|Yes|Yes| | | |
135+
|Alpine Linux 3.15 (64-bit) |Yes| | | | | | | | |
136+
|Alpine Linux 3.14 (64-bit) |Yes| | | | | | | | |
137+
|Alpine Linux 3.13 (64-bit) |Yes| | | | | | | | |
138+
|Alpine Linux 3.12 (64-bit) | |Yes| | | | | | | |
139+
|Alpine Linux 3.11 (64-bit) | |Yes|Yes<sup>1</sup>| | | |
140+
|macOS Monterey (64-bit) |Yes| | | | | | | | |
141+
|macOS Big Sur (64-bit) |Yes|Yes| | | | | | | |
142+
|macOS Catalina (64-bit) |Yes|Yes|Yes| | | | | | |
143+
|macOS Mojave (64-bit) | |Yes|Yes|Yes| | | | | |
144+
|macOS High Sierra (64-bit) | | |Yes|Yes|Yes| | | | |
145+
|macOS Sierra (64-bit) | | | |Yes|Yes|Yes|Yes| | |
146+
|macOS El Capitan (64-bit) | | | | |Yes|Yes|Yes| | |
147+
| &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; | &nbsp; |
137148

138149
<sup>1</sup> Alpine Linux support is experimental for version 5.8.0. Version 5.8.1 introduces production support.
139150

docs/connect/php/release-notes-php-sql-driver.md

Lines changed: 28 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
title: Release Notes for the Microsoft Drivers for PHP
33
description: This page discusses what was changed in each version of the Microsoft Drivers for PHP for SQL Server.
44
ms.custom: ""
5-
ms.date: 01/29/2021
5+
ms.date: 01/18/2022
66
ms.prod: sql
77
ms.prod_service: connectivity
88
ms.reviewer: v-davidengel
@@ -34,6 +34,33 @@ For any questions, ask GeneMi or CraigG.
3434
Thanks a lot. 2019-03-28 (DevO= 1467988)
3535
-->
3636

37+
## 5.10
38+
![download](../../ssms/media/download-icon.png) [Download Windows Package](https://go.microsoft.com/fwlink/?linkid=2185805)
39+
[GitHub Release Tag (Linux and macOS packages are available here)](https://github.com/Microsoft/msphpsql/releases/tag/v5.10.0)
40+
41+
### Version information
42+
43+
- Release number: 5.10.0<sup>1</sup>
44+
- Released: January 31, 2022
45+
46+
### What's new in 5.10
47+
48+
| New item | Details |
49+
| :------- | :------ |
50+
| Added support for PHP 8.1. | &nbsp; |
51+
| Dropped support for PHP 7.3. | &nbsp; |
52+
| Dropped support for macOS Mojave, Ubuntu 16.04, Alpine 3.11 and 3.12. | &nbsp; |
53+
| Added support for Windows 11 and Windows Server 2022. | &nbsp; |
54+
| Added support for macOS Monterey, Debian 11, Ubuntu 21.04 and 21.10, Alpine 3.13, 3.14 and 3.15. | &nbsp; |
55+
| Added support for Apple M1 ARM64 hardware. | Requires ODBC Driver 17.8 or above. |
56+
| Added support for Table-valued Parameters. | &nbsp; |
57+
| Allowed setting PDO::ATTR_EMULATE_PREPARES at the connection level. | &nbsp; |
58+
| Adjusted connection keyword and value validation for more flexibility. | &nbsp; |
59+
60+
<sup>1</sup> This release requires ODBC Driver 17.4.2 or above. Otherwise, a warning about failing to set an attribute will occur. This warning may be suppressed when using an older ODBC driver. If using SQLSRV, check [How to: Configure Error and Warning Handling Using the SQLSRV Driver](./how-to-configure-error-and-warning-handling-using-the-sqlsrv-driver.md). If using PDO_SQLSRV, warnings are by default suppressed but can be logged. Check [Logging Activity](./logging-activity.md) for details.
61+
62+
## Previous releases
63+
3764
## 5.9
3865

3966
![download](../../ssms/media/download-icon.png) [Download Windows Package](https://go.microsoft.com/fwlink/?linkid=2152937)
@@ -64,8 +91,6 @@ Thanks a lot. 2019-03-28 (DevO= 1467988)
6491

6592
<sup>1</sup> This release requires ODBC Driver 17.4.2 or above. Otherwise, a warning about failing to set an attribute will occur. This warning may be suppressed when using an older ODBC driver. If using SQLSRV, check [How to: Configure Error and Warning Handling Using the SQLSRV Driver](./how-to-configure-error-and-warning-handling-using-the-sqlsrv-driver.md). If using PDO_SQLSRV, warnings are by default suppressed but can be logged. Check [Logging Activity](./logging-activity.md) for details.
6693

67-
## Previous releases
68-
6994
## 5.8.1
7095

7196
This release only applies to Linux and macOS.

0 commit comments

Comments
 (0)