PHP Manual
Function Reference
Database Extensions
Vendor Specific Database Extensions
CUBRID
dBase
Firebird/InterBase
IBM DB2
MongoDB
MySQL
OCI8
PostgreSQL
SQLite3
SQLSRV
SQLite3Result::reset
Introduction
Vendor Specific Database Extensions
PHP Manual
Microsoft SQL Server Driver for PHP
Table of Contents
Introduction
Installing/Configuring
Requirements
Installation
Runtime Configuration
Resource Types
Predefined Constants
SQLSRV Functions
sqlsrv_begin_transaction
— Begins a database transaction
sqlsrv_cancel
— Cancels a statement
sqlsrv_client_info
— Returns information about the client and specified connection
sqlsrv_close
— Closes an open connection and releases resourses associated with the connection
sqlsrv_commit
— Commits a transaction that was begun with sqlsrv_begin_transaction
sqlsrv_configure
— Changes the driver error handling and logging configurations
sqlsrv_connect
— Opens a connection to a Microsoft SQL Server database
sqlsrv_errors
— Returns error and warning information about the last SQLSRV operation performed
sqlsrv_execute
— Executes a statement prepared with sqlsrv_prepare
sqlsrv_fetch
— Makes the next row in a result set available for reading
sqlsrv_fetch_array
— Returns a row as an array
sqlsrv_fetch_object
— Retrieves the next row of data in a result set as an object
sqlsrv_field_metadata
— Retrieves metadata for the fields of a statement prepared by sqlsrv_prepare or sqlsrv_query
sqlsrv_free_stmt
— Frees all resources for the specified statement
sqlsrv_get_config
— Returns the value of the specified configuration setting
sqlsrv_get_field
— Gets field data from the currently selected row
sqlsrv_has_rows
— Indicates whether the specified statement has rows
sqlsrv_next_result
— Makes the next result of the specified statement active
sqlsrv_num_fields
— Retrieves the number of fields (columns) on a statement
sqlsrv_num_rows
— Retrieves the number of rows in a result set
sqlsrv_prepare
— Prepares a query for execution
sqlsrv_query
— Prepares and executes a query
sqlsrv_rollback
— Rolls back a transaction that was begun with sqlsrv_begin_transaction
sqlsrv_rows_affected
— Returns the number of rows modified by the last INSERT, UPDATE, or DELETE query executed
sqlsrv_send_stream_data
— Sends data from parameter streams to the server
sqlsrv_server_info
— Returns information about the server