PHP 手冊
上一頁 |  | 下一頁

# ingres_query

(PHP 4 >= 4.0.2, PHP 5)

ingres_query -- Send a SQL query to Ingres II

## Description

bool ingres_query ( string query [, resource link])

切記!
這個函數是實驗性質的。這個函數的行為、名稱、和關於此函數的任何其他文件在未來PHP的發行中可能會在不通知的情況下改變。 使用此延伸需自行承擔風險。

Returns `TRUE` on success, or `FALSE` on failure.

ingres_query() sends the given query to the Ingres server. This query must be a valid SQL query (see the Ingres SQL reference guide)

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.

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

示範 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]; } ?>`

See also ingres_fetch_array(), ingres_fetch_object(), ingres_fetch_row(), ingres_commit(), ingres_rollback(), and ingres_autocommit().

上一頁 | 最開頭 | 下一頁
ingres_pconnect | 上一層 | ingres_rollback