PHP_SQLSRV
Table of contents
- Introducing the Microsoft Drivers for PHP for SQL Server
- What's New in the Microsoft Drivers for PHP for SQL Server
- Support Resources
- About Code Examples in the Documentation
- Getting Started
- System Requirements
- Loading the Microsoft Drivers for PHP for SQL Server
- Configuring IIS
- Programming Guide
- Connecting to the Server
- How to: Connect Using Windows Authentication
- How to: Connect Using SQL Server Authentication
- How to: Connect on a Specified Port
- Connection Pooling
- How to: Disable Multiple Active Resultsets (MARS)
- Connection Options
- PHP Driver for SQL Server Support for LocalDB
- PHP Driver for SQL Server Support for High Availability, Disaster Recovery
- Connecting to SQL Azure
- Comparing Execution Functions
- Direct Statement Execution and Prepared Statement Execution in the PDO_SQLSRV Driver
- Retrieving Data
- Retrieving Data as a Stream Using the SQLSRV Driver
- Data Types with Stream Support Using the SQLSRV Driver
- How to: Retrieve Character Data as a Stream Using the SQLSRV Driver
- How to: Retrieve Binary Data as a Stream Using the SQLSRV Driver
- Using Directional Parameters
- How to: Specify Parameter Direction Using the SQLSRV Driver
- How to: Retrieve Output Parameters Using the SQLSRV Driver
- How to: Retrieve Input/Output Parameters Using the SQLSRV Driver
- Specifying a Cursor Type and Selecting Rows
- Cursor Types (SQLSRV Driver)
- Cursor Types (PDO_SQLSRV Driver)
- How to: Retrieve Date and Time Type as Strings Using the SQLSRV Driver
- Updating Data
- How to: Perform Parameterized Queries
- How to: Send Data as a Stream
- How to: Perform Transactions
- Converting Data Types
- Default SQL Server Data Types
- Default PHP Data Types
- How to: Specify SQL Server Data Types When Using the SQLSRV Driver
- How to: Specify PHP Data Types
- How to: Send and Retrieve UTF-8 Data Using Built-In UTF-8 Support
- Handling Errors and Warnings
- How to: Configure Error and Warning Handling Using the SQLSRV Driver
- How to: Handle Errors and Warnings Using the SQLSRV Driver
- Logging Activity
- Security Considerations
- SQLSRV Driver API Reference
- sqlsrv_begin_transaction
- sqlsrv_cancel
- sqlsrv_client_info
- sqlsrv_close
- sqlsrv_commit
- sqlsrv_configure
- sqlsrv_connect
- sqlsrv_errors
- sqlsrv_execute
- sqlsrv_fetch
- sqlsrv_fetch_array
- sqlsrv_fetch_object
- sqlsrv_field_metadata
- sqlsrv_free_stmt
- sqlsrv_get_config
- sqlsrv_get_field
- sqlsrv_has_rows
- sqlsrv_next_result
- sqlsrv_num_fields
- sqlsrv_num_rows
- sqlsrv_prepare
- sqlsrv_query
- sqlsrv_rollback
- sqlsrv_rows_affected
- sqlsrv_send_stream_data
- sqlsrv_server_info
- PDO_SQLSRV Driver Reference
- PDO Class
- PDO::__construct
- PDO::beginTransaction
- PDO::commit
- PDO::errorCode
- PDO::errorInfo
- PDO::exec
- PDO::getAttribute
- PDO::getAvailableDrivers
- PDO::lastInsertId
- PDO::prepare
- PDO::query
- PDO::quote
- PDO::rollback
- PDO::setAttribute
- PDOStatement Class
- PDOStatement::bindColumn
- PDOStatement::bindParam
- PDOStatement::bindValue
- PDOStatement::closeCursor
- PDOStatement::columnCount
- PDOStatement::debugDumpParams
- PDOStatement::errorCode
- PDOStatement::errorInfo
- PDOStatement::execute
- PDOStatement::fetch
- PDOStatement::fetchAll
- PDOStatement::fetchColumn
- PDOStatement::fetchObject
- PDOStatement::getAttribute
- PDOStatement::getColumnMeta
- PDOStatement::nextRowset
- PDOStatement::rowCount
- PDOStatement::setAttribute
- PDOStatement::setFetchMode
- Constants (Microsoft Drivers for PHP for SQL Server)
- Example Application (SQLSRV Driver)
- Example Application (PDO_SQLSRV Driver)