Addressed blocking and non-blocking issues

david-puglielli · david-puglielli · commit d2f681650e02 · 2018-03-26T15:54:18.000-07:00
diff --git a/docs/connect/php/about-code-examples-in-the-documentation.md b/docs/connect/php/about-code-examples-in-the-documentation.md
@@ -1,7 +1,7 @@
 ---
 title: "About Code Examples in the Documentation | Microsoft Docs"
 ms.custom: ""
-ms.date: "03/23/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
@@ -22,6 +22,7 @@ ms.workload: "Inactive"
 # About Code Examples in the Documentation
 [!INCLUDE[Driver_PHP_Download](../../includes/driver_php_download.md)]
 
+## Remarks about the code examples
 There are several points to note when you execute the code examples in the [!INCLUDE[ssDriverPHP](../../includes/ssdriverphp_md.md)] documentation:  
   
 -   Nearly all the examples assume that SQL Server 2008 or later and the AdventureWorks database are installed on the local computer.  
diff --git a/docs/connect/php/code-samples-for-php-sql-driver.md b/docs/connect/php/code-samples-for-php-sql-driver.md
@@ -1,7 +1,7 @@
 ---
 title: "Code Samples for the Microsoft Drivers for PHP for SQL Server | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/comparing-execution-functions.md b/docs/connect/php/comparing-execution-functions.md
@@ -1,7 +1,7 @@
 ---
 title: "Comparing Execution Functions | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
@@ -25,9 +25,11 @@ ms.workload: "Inactive"
 [!INCLUDE[Driver_PHP_Download](../../includes/driver_php_download.md)]
 
 The [!INCLUDE[ssDriverPHP](../../includes/ssdriverphp_md.md)] provides several options for executing functions.  
-  
+
+## SQLSRV Execution Functions  
 If you are using the SQLSRV driver, use [sqlsrv_query](../../connect/php/sqlsrv-query.md) to execute a single query and [sqlsrv_prepare](../../connect/php/sqlsrv-prepare.md) with [sqlsrv_execute](../../connect/php/sqlsrv-execute.md) to execute a prepared statement multiple times with different parameter values for each execution.  
-  
+
+## PDO_SQLSRV Execution Functions 
 If you are using the PDO_SQLSRV driver, you can execute a query with one of the following:  
   
 -   [PDO::exec](../../connect/php/pdo-exec.md)  
diff --git a/docs/connect/php/configuring-iis-for-php-sql-driver.md b/docs/connect/php/configuring-iis-for-php-sql-driver.md
@@ -1,7 +1,7 @@
 ---
 title: "Configuring IIS for the Microsoft Drivers for PHP for SQL Server | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/connecting-to-the-server.md b/docs/connect/php/connecting-to-the-server.md
@@ -1,7 +1,7 @@
 ---
 title: "Connecting to the Server | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/connection-options.md b/docs/connect/php/connection-options.md
@@ -1,7 +1,7 @@
 ---
 title: "Connection Options | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
@@ -24,6 +24,7 @@ ms.workload: "On Demand"
 
 This topic lists the options that are permitted in the associative array (when using [sqlsrv_connect](../../connect/php/sqlsrv-connect.md) in the SQLSRV driver) or the keywords that are permitted in the data source name (dsn) (when using [PDO::__construct](../../connect/php/pdo-construct.md) in the PDO_SQLSRV driver).  
 
+## Table of Connection Options
 |Key|Value|Description|Default|  
 |-------|---------|---------------|-----------|  
 |APP|String|Specifies the application name used in tracing.|No value set.|  
diff --git a/docs/connect/php/converting-data-types.md b/docs/connect/php/converting-data-types.md
@@ -1,7 +1,7 @@
 ---
 title: "Converting Data Types | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/direct-statement-execution-prepared-statement-execution-pdo-sqlsrv-driver.md b/docs/connect/php/direct-statement-execution-prepared-statement-execution-pdo-sqlsrv-driver.md
@@ -1,7 +1,7 @@
 ---
 title: "Direct Statement - Prepared Statement Execution PDO_SQLSRV Driver | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/example-application-pdo-sqlsrv-driver.md b/docs/connect/php/example-application-pdo-sqlsrv-driver.md
@@ -1,7 +1,7 @@
 ---
 title: "Example Application (PDO_SQLSRV Driver) | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/example-application-sqlsrv-driver.md b/docs/connect/php/example-application-sqlsrv-driver.md
@@ -1,7 +1,7 @@
 ---
 title: "Example Application (SQLSRV Driver) | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/getting-started-with-the-php-sql-driver.md b/docs/connect/php/getting-started-with-the-php-sql-driver.md
@@ -1,7 +1,7 @@
 ---
 title: "Getting Started with the Microsoft Drivers for PHP for SQL Server | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/handling-errors-and-warnings.md b/docs/connect/php/handling-errors-and-warnings.md
@@ -1,7 +1,7 @@
 ---
 title: "Handling Errors and Warnings | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/how-to-configure-error-and-warning-handling-using-the-sqlsrv-driver.md b/docs/connect/php/how-to-configure-error-and-warning-handling-using-the-sqlsrv-driver.md
@@ -1,7 +1,7 @@
 ---
 title: "Configure Error and Warning Handling Using the SQLSRV Driver | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/how-to-connect-on-a-specified-port.md b/docs/connect/php/how-to-connect-on-a-specified-port.md
@@ -1,7 +1,7 @@
 ---
 title: "How to: Connect on a Specified Port | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/how-to-connect-using-sql-server-authentication.md b/docs/connect/php/how-to-connect-using-sql-server-authentication.md
@@ -1,7 +1,7 @@
 ---
 title: "How to: Connect Using SQL Server Authentication | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/how-to-connect-using-windows-authentication.md b/docs/connect/php/how-to-connect-using-windows-authentication.md
@@ -1,7 +1,7 @@
 ---
 title: "How to: Connect Using Windows Authentication | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/how-to-perform-parameterized-queries.md b/docs/connect/php/how-to-perform-parameterized-queries.md
@@ -1,7 +1,7 @@
 ---
 title: "How to: Perform Parameterized Queries | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/how-to-send-data-as-a-stream.md b/docs/connect/php/how-to-send-data-as-a-stream.md
@@ -1,7 +1,7 @@
 ---
 title: "How to: Send Data as a Stream | Microsoft Docs"
 ms.custom: ""
-ms.date: "01/19/2017"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
@@ -29,7 +29,7 @@ The [!INCLUDE[ssDriverPHP](../../includes/ssdriverphp_md.md)] takes advantage of
   
 The third example shows how to send stream data to the server using the PDO_SQLSRV driver.  
   
-## Example  
+## Example: Sending Stream Data at Execution
 The following example inserts a row into the *Production.ProductReview* table of the AdventureWorks database. The customer comments (*$comments*) are opened as a stream with the PHP [fopen](http://php.net/manual/en/function.fopen.php) function and then streamed to the server upon execution of the query.  
   
 The example assumes that SQL Server and the [AdventureWorks](https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/adventure-works) database are installed on the local computer. All output is written to the console.  
@@ -85,7 +85,7 @@ sqlsrv_close( $conn);
 ?>  
 ```  
   
-## Example  
+## Example: Sending Stream Data Using sqlsrv_send_stream_data
 The next example is the same as the preceding example, but the default behavior of sending all stream data at execution is turned off. The example uses [sqlsrv_send_stream_data](../../connect/php/sqlsrv-send-stream-data.md) to send stream data to the server. Up to eight kilobytes (8 kB) of data is sent with each call to **sqlsrv_send_stream_data**. The script counts the number of calls made by **sqlsrv_send_stream_data** and displays the count to the console.  
   
 The example assumes that SQL Server and the [AdventureWorks](https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/adventure-works) database are installed on the local computer. All output is written to the console.  
@@ -152,7 +152,7 @@ sqlsrv_close( $conn);
   
 Although the examples in this topic send character data to the server, data in any format can be sent as a stream. For example, you can also use the techniques that are demonstrated in this topic to send images in binary format as streams.  
   
-## Example  
+## Example: Sending an Image as a Stream 
   
 ```  
 <?php  
diff --git a/docs/connect/php/installation-tutorial-linux-mac.md b/docs/connect/php/installation-tutorial-linux-mac.md
@@ -1,6 +1,6 @@
 ---
-title: "Installation Tutorial for Linux and macOS | Microsoft Docs"
-ms.date: "02/16/2018"
+title: "Linux and macOS Installation Tutorial for the Microsoft Drivers for PHP for SQL Server | Microsoft Docs"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
@@ -16,7 +16,7 @@ manager: "v-mabarw"
 ms.workload: "Inactive"
 ---
 
-# PHP Linux and Mac Drivers Installation Tutorial
+# Linux and macOS Installation Tutorial for the Microsoft Drivers for PHP for SQL Server
 The following instructions assume a clean environment and show how to install PHP 7.x, the Microsoft ODBC driver, Apache, and the Microsoft Drivers for PHP for SQL Server on Ubuntu 16.04 and 17.10, RedHat 7, Debian 8 and 9, Suse 12, and macOS X 10.11 and 10.12. These instructions advise installing the drivers using PECL, but you can also download the prebuilt binaries from the [Microsoft Drivers for PHP for SQL Server](https://github.com/Microsoft/msphpsql/releases) Github project page and install them following the instructions in [Loading the Microsoft Drivers for PHP for SQL Server](../../connect/php/loading-the-php-sql-driver.md). For an explanation of extension loading and why we do not add the extensions to php.ini, see the section on [loading the drivers](../../connect/php/loading-the-php-sql-driver.md##loading-the-driver-at-php-startup).
 
 These instruction install PHP 7.2 by default -- see the notes at the beginning of each section to install PHP 7.0 or 7.1.
@@ -321,3 +321,10 @@ function FormatErrors( $errors )
 ?>
 ```
 Point your browser to http://localhost/testsql.php (http://localhost:8080/testsql.php on macOS). You should now be able to connect to your SQL Server/Azure SQL database.
+
+## See Also  
+[Getting Started with the Microsoft Drivers for PHP for SQL Server](../../connect/php/getting-started-with-the-php-sql-driver.md)
+
+[Loading the Microsoft Drivers for PHP for SQL Server](../../connect/php/loading-the-php-sql-driver.md)
+
+[System Requirements for the Microsoft Drivers for PHP for SQL Server](../../connect/php/system-requirements-for-the-php-sql-driver.md)
diff --git a/docs/connect/php/loading-the-php-sql-driver.md b/docs/connect/php/loading-the-php-sql-driver.md
@@ -1,7 +1,7 @@
 ---
 title: "Loading the Microsoft Drivers for PHP for SQL Server | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/logging-activity.md b/docs/connect/php/logging-activity.md
@@ -1,7 +1,7 @@
 ---
 title: "Logging Activity | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/microsoft-php-driver-for-sql-server.md b/docs/connect/php/microsoft-php-driver-for-sql-server.md
@@ -1,7 +1,7 @@
 ---
 title: "Microsoft Drivers for PHP for SQL Server | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.component: "php"
diff --git a/docs/connect/php/microsoft-php-drivers-for-sql-server-support-matrix.md b/docs/connect/php/microsoft-php-drivers-for-sql-server-support-matrix.md
@@ -1,7 +1,7 @@
 ---
 title: "Microsoft Drivers for PHP for SQL Server Support Matrix | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/overview-of-the-php-sql-driver.md b/docs/connect/php/overview-of-the-php-sql-driver.md
@@ -1,7 +1,7 @@
 ---
 title: "Overview of the Microsoft Drivers for PHP for SQL Server | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/pdo-class.md b/docs/connect/php/pdo-class.md
@@ -1,7 +1,7 @@
 ---
 title: "PDO Class | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/pdo-sqlsrv-driver-reference.md b/docs/connect/php/pdo-sqlsrv-driver-reference.md
@@ -1,7 +1,7 @@
 ---
 title: "PDO_SQLSRV Driver Reference | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/pdostatement-class.md b/docs/connect/php/pdostatement-class.md
@@ -1,7 +1,7 @@
 ---
 title: "PDOStatement Class | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/php-driver-for-sql-server-support-for-high-availability-disaster-recovery.md b/docs/connect/php/php-driver-for-sql-server-support-for-high-availability-disaster-recovery.md
@@ -1,7 +1,7 @@
 ---
-title: "Support for High Availability, Disaster Recovery | Microsoft Docs"
+title: "Support for High Availability, Disaster Recovery for the Microsoft Drivers for PHP for SQL Server | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/php-driver-for-sql-server-support-for-localdb.md b/docs/connect/php/php-driver-for-sql-server-support-for-localdb.md
@@ -1,7 +1,7 @@
 ---
 title: "Support for LocalDB | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.reviewer: ""
 ms.suite: "sql"
diff --git a/docs/connect/php/programming-guide-for-php-sql-driver.md b/docs/connect/php/programming-guide-for-php-sql-driver.md
@@ -1,7 +1,7 @@
 ---
 title: "Programming Guide for the Microsoft Drivers for PHP for SQL Server | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/release-notes-for-the-php-sql-driver.md b/docs/connect/php/release-notes-for-the-php-sql-driver.md
@@ -1,7 +1,7 @@
 ---
 title: "Release Notes for the Microsoft Drivers for PHP for SQL Server | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/retrieving-data.md b/docs/connect/php/retrieving-data.md
@@ -1,7 +1,7 @@
 ---
 title: "Retrieving Data | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/security-considerations-for-php-sql-driver.md b/docs/connect/php/security-considerations-for-php-sql-driver.md
@@ -1,7 +1,7 @@
 ---
 title: "Security Considerations for the Microsoft Drivers for PHP for SQL Server | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/sqlsrv-begin-transaction.md b/docs/connect/php/sqlsrv-begin-transaction.md
@@ -1,7 +1,7 @@
 ---
 title: "sqlsrv_begin_transaction | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/sqlsrv-commit.md b/docs/connect/php/sqlsrv-commit.md
@@ -1,7 +1,7 @@
 ---
 title: "sqlsrv_commit | Microsoft Docs"
 ms.custom: ""
-ms.date: "02/16/2018"
+ms.date: "03/26/2018"
 ms.prod: "sql-non-specified"
 ms.prod_service: "drivers"
 ms.service: ""
diff --git a/docs/connect/php/sqlsrv-configure.md b/docs/connect/php/sqlsrv-configure.md
diff --git a/docs/connect/php/sqlsrv-connect.md b/docs/connect/php/sqlsrv-connect.md
diff --git a/docs/connect/php/sqlsrv-driver-api-reference.md b/docs/connect/php/sqlsrv-driver-api-reference.md
diff --git a/docs/connect/php/sqlsrv-fetch-array.md b/docs/connect/php/sqlsrv-fetch-array.md
diff --git a/docs/connect/php/sqlsrv-rollback.md b/docs/connect/php/sqlsrv-rollback.md
diff --git a/docs/connect/php/step-1-configure-development-environment-for-php-development.md b/docs/connect/php/step-1-configure-development-environment-for-php-development.md
diff --git a/docs/connect/php/support-resources-for-the-php-sql-driver.md b/docs/connect/php/support-resources-for-the-php-sql-driver.md
diff --git a/docs/connect/php/updating-data-microsoft-drivers-for-php-for-sql-server.md b/docs/connect/php/updating-data-microsoft-drivers-for-php-for-sql-server.md
