PHP Function SQLSRV_configure

Article about php function sqlsrv_configure

Configures SQLSRV options. Returns the configuration settings as an associative array.

The SQLSRV extension uses connection pooling to improve performance by minimizing the number of new connections created. To disable connection pooling, set the "ConnectionPooling" option in the $connectionOptions array to 0 or FALSE.

If the SQLSRV extension is used with a MySQL DB, an additional parameter is required to configure which database the statement executes on. This is because SQLSRV can only connect to one MySQL DB at a time, regardless of how many query methods are executed. The SQLSRV option "DbName" configures the database to be connected to.

The default is a random database name that is assigned each time an executed query calls sqlsrv_prepare().

Commits the transaction that was begun with sqlsrv_begin_transaction(). Returns TRUE on success, FALSE on failure.

Makes the next row of the result set available for reading. The first row has index 0. Returns the data for the row, either as a numerically indexed array or as an associative array depending on the row access modifier. The default PHP data type for the returned field data is also defined here.

Frees all resources associated with the specified statement. If sqlsrv_free_stmt() is called on an in-progress statement that alters server state, the statement execution is terminated and rolled back. The statement resource can be reused by calling sqlsrv_prepare() again.