Microsoft Drivers for PHP for SQL Server version 2.0 and 3.0 |
SQLSRV Driver API Reference |
See Also Send Feedback |
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:
Function |
Description |
---|---|
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. |