SQLSRV Driver API Reference
The API name for the SQLSRV driver in the Microsoft Drivers for PHP for SQL Server is sqlsrv. All sqlsrv functions begin with sqlsrv_ and are followed by a verb or a noun. Those followed by a verb perform some action and those followed by a noun return some form of metadata.
In This Section
The SQLSRV driver contains the following functions:
Begins a transaction.
Cancels a statement; discards any pending results for the statement.
Provides information about the client.
Closes a connection. Frees all resources associated with the connection.
Commits a transaction.
Changes error handling and logging configurations.
Creates and opens a connection.
Returns error and/or warning information about the last operation.
Executes a prepared statement.
Makes the next row of data available for reading.
Retrieves the next row of data as a numerically indexed array, an associative array, or both.
Retrieves the next row of data as an object.
Returns field metadata.
Closes a statement. Frees all resources associated with the statement.
Returns the value of the specified configuration setting.
Retrieves a field in the current row by index. The PHP return type can be specified.
Detects if a result set has one or more rows.
Makes the next result available for processing.
Reports the number of rows in a result set.
Retrieves the number of fields in an active result set.
Prepares a Transact-SQL query without executing it. Implicitly binds parameters.
Prepares and executes a Transact-SQL query.
Rolls back a transaction.
Returns the number of modified rows.
Sends up to eight kilobytes (8 KB) of data to the server with each call to the function.
Provides information about the server.