# PHP 用 Microsoft SQL Server ドライバ

# はじめに

SQLSRV 拡張モジュールを使えば、PHP を実行する際に Microsoft SQL Server や SQL Azure データベースにアクセスできるようになります。 リリース 3.0 のドライバがサポートするのは SQL Server 2005 以降のバージョンで、SQL Server 2012 や SQL Server 2012 LocalDB にも対応します (LocalDB についての詳細な情報は » PHP Driver for SQL Server Support for LocalDB や » SQL Server 2012 Express LocalDB を参照ください)。

SQLSRV 拡張モジュールは Microsoft がサポートしており、 » http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx からダウンロードできます。 SQL Server 2012 LocalDB は » http://go.microsoft.com/fwlink/?LinkID=237665 からダウンロードできます。

- インストール/設定
  - 要件
  - インストール手順
  - 実行時設定
  - リソース型
- 定義済み定数
- SQLSRV 関数
  - 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 resources 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 — 行を配列として返す
  - 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

`↑` and `↓` to navigate • `Enter` to select • `Esc` to close • `/` to open