ingres_query
(PHP 4 >= 4.0.2, PHP 5 <= 5.0.5, PECL ingres:1.0-1.4.3)
ingres_query — Send a SQL query to Ingres II
Описание
ingres_query() sends the given query to the Ingres server.
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 either call 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.
Список параметров
- query
-
A valid SQL query (see the Ingres SQL reference guide).
Some types of SQL queries can't be sent with this function:
- close (see ingres_close())
- commit (see ingres_commit())
- connect (see ingres_connect())
- disconnect (see ingres_close())
- get dbevent
- prepare to commit
- rollback (see ingres_rollback())
- savepoint
- set autocommit (see ingres_autocommit())
- all cursor related queries are unsupported
- link
-
The connection link identifier. If not specified, the last opened link is used.
Возвращаемые значения
Возвращает TRUE в случае успешного завершения или FALSE в случае возникновения ошибки.
Примеры
Пример #1 ingres_query() example
<?php
ingres_connect($database, $user, $password);
ingres_query("select * from table");
while ($row = ingres_fetch_row()) {
echo $row[1];
echo $row[2];
}
?>
- 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
Коментарии
If you reuse a query result variable, you should free that variable to close off the previous query before running a second.
I.E.
$rc = ingres_query($conn, ...
// do stuff
unset($rc);