ifx_prepare Prepare an SQL-statement for execution php函数


ifx_prepare

(PHP 4, PHP <=5.2.0)

ifx_preparePrepare an SQL-statement for execution

说明

resource ifx_prepare ( string $query , resource $link_identifier [, int $cursor_def ], mixed $blobidarray )

Prepares a query for later use with ifx_do().

For "select-type" queries a cursor is declared and opened. Non-select queries are "execute immediate".

For either query type the number of (estimated or real) affected rows is saved for retrieval by ifx_affected_rows().

If the contents of the TEXT (or BYTE) column allow it, you can also use ifx_textasvarchar(1) and ifx_byteasvarchar(1). This allows you to treat TEXT (or BYTE) columns just as if they were ordinary (but long) VARCHAR columns for select queries, and you don't need to bother with blob id's.

With ifx_textasvarchar(0) or ifx_byteasvarchar(0) (the default situation), select queries will return BLOB columns as blob id's (integer value). You can get the value of the blob as a string or file with the blob functions (see below).

参数

query

The query string.

link_identifier

The link identifier.

cursor_def

This optional parameter allows you to make this a scroll and/or hold cursor. It's a bitmask and can be either IFX_SCROLL, IFX_HOLD, or both or'ed together.

blobidarray

If you have BLOB (BYTE or TEXT) columns in the query, you can add a blobidarray parameter containing the corresponding "blob ids", and you should replace those columns with a "?" in the query text.

返回值

Returns a valid result identifier for use by ifx_do(), or FALSE on errors.

参见

  • ifx_do() - Execute a previously prepared SQL-statement



相关阅读:
ifx_query Send Informix query
ifx_textasvarchar Set the default text mode
ifx_update_blob Updates the content of the blob object
ifx_update_char Updates the content of the char object
ignore_user_abort Set whether a client disconnect should abort script execution
image2wbmp 以 WBMP 格式将图像输出到浏览器或文件
imagealphablending 设定图像的混色模式
imageantialias 是否使用抗锯齿(antialias)功能
imagearc 画椭圆弧
imagechar 水平地画一个字符
imagecharup 垂直地画一个字符
imagecolorallocate 为一幅图像分配颜色
imagecolorallocatealpha 为一幅图像分配颜色 + alpha
imagecolorat 取得某像素的颜色索引值
快速导航

Copyright © 2016 phpStudy |