ingres_pconnectingres_prepare
(PECL ingres >= 1.1.0)
ingres_prepare — Prepare a query for later execution
説明
Prepares a query for execution by ingres_execute().
The query becomes part of the currently open transaction. If there is no open transaction, ingres_query() opens a new transaction. To close the transaction, you can call either ingres_commit() to commit the changes made to the database or ingres_rollback() to cancel these changes. When the script ends, any open transaction is rolled back (by calling ingres_rollback()). You can also use ingres_autocommit() before opening a new transaction to have every SQL query immediately committed.
注意: Related Configurations
See also the ingres.describe, ingres.scrollable and ingres.utf8 directives in Runtime Configuration.
パラメータ
- link
-
The connection link identifier
- query
-
A valid SQL query (see the Ingres SQL reference guide) in the Ingres documentation. See the query parameter in ingres_query() for a list of SQL statements which cannot be executed using ingres_prepare()
返り値
ingres_prepare() returns a query result identifier that is used with ingres_execute() to execute the query. To see if an error occurred, use ingres_errno(), ingres_error(), or ingres_errsqlstate().
参考
- ingres_unbuffered_query() - Send an unbuffered SQL query to Ingres
- ingres_fetch_array() - 1 行分の結果を配列に取得する
- ingres_fetch_assoc() - Fetch a row of result into an associative array
- ingres_fetch_object() - 1 行分の結果をオブジェクトとして取得する
- ingres_fetch_row() - 1 行分の結果を数値添字配列として取得する
- ingres_commit() - トランザクションをコミットする
- ingres_rollback() - トランザクションをロールバックする
- ingres_autocommit() - autocommit をオンまたはオフに切替える
- ingres_set_environment() - Set environment features controlling output options
- ingres_errno() - 直近に発生した ingres エラー番号を取得する
- ingres_error() - 直近に発生したエラーのエラーメッセージを取得する
add a note
User Contributed Notesingres_prepare