comparing-execution-functions.md

title	Comparing execution functions
description	This topic lists the different query execution functions when using the Microsoft Drivers for PHP for SQL Server
author	dlevy-msft-sql
ms.author	dlevy
ms.reviewer	davidengel, sumitsar, jathakkar
ms.date	08/10/2020
ms.service	sql
ms.subservice	connectivity
ms.topic	concept-article
helpviewer_keywords	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