ingres_prepare
(PECL ingres >= 1.1.0)
ingres_prepare — Prepare a query for later execution
Description
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.
Note: Related Configurations
See also the ingres.describe, ingres.scrollable and ingres.utf8 directives in Runtime Configuration.
Parameters
-
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()
Return Values
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().
See Also
- ingres_unbuffered_query() - Send an unbuffered SQL query to Ingres
- ingres_fetch_array() - Fetch a row of result into an array
- ingres_fetch_assoc() - Fetch a row of result into an associative array
- ingres_fetch_object() - Fetch a row of result into an object
- ingres_fetch_row() - Fetch a row of result into an enumerated array
- ingres_commit() - Commit a transaction
- ingres_rollback() - Roll back a transaction
- ingres_autocommit() - Switch autocommit on or off
- ingres_set_environment() - Set environment features controlling output options
- ingres_errno() - Get the last Ingres error number generated
- ingres_error() - Get a meaningful error message for the last error generated
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- Ingres DBMS, EDBC, and Enterprise Access Gateways
- ingres_autocommit_state
- ingres_autocommit
- ingres_charset
- ingres_close
- ingres_commit
- ingres_connect
- ingres_cursor
- ingres_errno
- ingres_error
- ingres_errsqlstate
- ingres_escape_string
- ingres_execute
- ingres_fetch_array
- ingres_fetch_assoc
- ingres_fetch_object
- ingres_fetch_proc_return
- ingres_fetch_row
- ingres_field_length
- ingres_field_name
- ingres_field_nullable
- ingres_field_precision
- ingres_field_scale
- ingres_field_type
- ingres_free_result
- ingres_next_error
- ingres_num_fields
- ingres_num_rows
- ingres_pconnect
- ingres_prepare
- ingres_query
- ingres_result_seek
- ingres_rollback
- ingres_set_environment
- ingres_unbuffered_query
Коментарии
404 Not Found