comparing-execution-functions.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
Comparing execution functions	This topic lists the different query execution functions when using the Microsoft Drivers for PHP for SQL Server	David-Engel	davidengel	08/10/2020	sql	connectivity	conceptual	executing queries

Comparing Execution Functions

[!INCLUDEDriver_PHP_Download]

The [!INCLUDEssDriverPHP] provides several options for executing functions.

SQLSRV Execution Functions

If you are using the SQLSRV driver, use sqlsrv_query to execute a single query and sqlsrv_prepare with sqlsrv_execute 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

• PDO::query

• PDO::prepare and PDOStatement::execute.

See Also

SQLSRV Driver API Reference

PDO_SQLSRV Driver Reference

Programming Guide for the Microsoft Drivers for PHP for SQL Server