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	David-Engel
ms.author	davidengel
ms.date	08/10/2020
ms.service	sql
ms.subservice	connectivity
ms.topic	conceptual
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