ifx_query Send Informix query php函数


ifx_query

(PHP 4, PHP <=5.2.0)

ifx_querySend Informix query

说明

resource ifx_query ( string $query , resource $link_identifier [, int $cursor_type [, mixed $blobidarray ]] )

Sends a query to the currently active database on the server that's associated with the specified link identifier.

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. I you omit this parameter the cursor is a normal sequential cursor.

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 valid Informix result identifier on success, or FALSE on errors.

范例

Example #1 Show all rows of the "orders" table as a HTML table

<?php
ifx_textasvarchar
(1);      // use "text mode" for blobs
$res_id ifx_query("select * from orders"$conn_id);
if (! 
$res_id) {
    
printf("Can't select orders : %s <br />%s<br /> "ifx_error(), ifx_errormsg());
    die;
}
ifx_htmltbl_result($res_id"border="1"");
ifx_free_result($res_id);
?>

Example #2 Insert some values into the "catalog" table

<?php

// create blob id's for a byte and text column
$textid ifx_create_blob(00"Text column in memory");
$byteid ifx_create_blob(10"Byte column in memory");

// store blob id's in a blobid array
$blobidarray[] = $textid;
$blobidarray[] = $byteid;

// launch query
$query "insert into catalog (stock_num, manu_code, " .
         
"cat_descr,cat_picture) values(1,'HRO',?,?)";
$res_id ifx_query($query$conn_id$blobidarray);
if (! 
$res_id) {
    
/* ... error ... */
}

// free result id
ifx_free_result($res_id);
?>

参见



相关阅读:
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 取得某像素的颜色索引值
imagecolorclosest 取得与指定的颜色最接近的颜色的索引值
快速导航

Copyright © 2016 phpStudy |