Comparing Execution Functions

Download PHP driver

The Microsoft Drivers for PHP for SQL Server 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