PHP 手册
上一页 |  | 下一页

# sesam_execimm

(PHP 3 CVS only)

sesam_execimm -- Execute an "immediate" SQL-statement

## 说明

string sesam_execimm ( string query )

Executes an "immediate" statement.

Sets the `affected_rows` value for retrieval by the sesam_affected_rows() function.

Note that sesam_query() can handle both "immediate" and "select-type" queries. Use sesam_execimm() only if you know beforehand what type of statement will be executed. An attempt to use SELECT type queries with sesam_execimm() will return `$err["sqlstate"] == "42SBW"`.

## 参数

`query`

  An "immediate" statement (i.e., a statement like UPDATE, INSERT or DELETE which returns no result, and has no INPUT or OUTPUT variables). "select type" queries can not be used with sesam_execimm().

## 返回值

Returns a SESAM result identifier on success, or `FALSE` on error.

The returned "result identifier" can not be used for retrieving anything but the sesam_affected_rows(); it is only returned for symmetry with the sesam_query() function.

## 范例

例 1. sesam_execimm() Example

`<?php $stmt = "INSERT INTO mytable VALUES ('one', 'two')"; $result = sesam_execimm($stmt); $err = sesam_diagnostic(); echo "sqlstate = " . $err["sqlstate"] . "\n". "Affected rows = " . $err["rowcount"] . " == " . sesam_affected_rows($result) . "\n"; ?>`

## 参见

sesam_query()
sesam_affected_rows()

上一页 | 起始页 | 下一页
sesam_errormsg | 上一级 | sesam_fetch_array