Ingres 函数
php 手册 | 脚本学堂 | 脚本编程 | 网站编程 | 系统管理 | 服务器配置 | 数据库管理 | Php教程 | python教程 | 正则表达式 | 批处理脚本 | Centos教程 | Linux基础教程

ingres_query

(PHP 4 >= 4.0.2, PHP 5 <= 5.0.5, PECL ingres >= 1.0.0)

ingres_querySend a SQL query to Ingres

说明

bool ingres_query ( string $query [, resource $link ] )

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:

link

The connection link identifier. If not specified, the last opened link is used.

返回值

如果成功则返回 TRUE,失败则返回 FALSE

范例

Example #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];
}
?>

参见


Ingres 函数
php 手册 | 脚本学堂 | 脚本编程 | 网站编程 | 系统管理 | 服务器配置 | 数据库管理 | Php教程 | python教程 | 正则表达式 | 批处理脚本 | Centos教程 | Linux基础教程