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 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 — 行を配列として返す
- 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