PHP 手册
Ovrimos SQL 函数

ovrimos_fetch_into

(PHP 4 >= 4.0.3, PHP 5 <= 5.0.5)

ovrimos_fetch_intoFetches a row from the result set

说明

bool ovrimos_fetch_into ( int $result_id , array &$result_array [, string $how [, int $rownumber ]] )

Fetches a row from the given result set, into result_array.

参数

result_id

A result identifier, returned by ovrimos_execute() or ovrimos_exec().

result_array

You must provide an array by reference. It will be filled with the fetched values.

how

Determines how the rows are fetched. This can be one of the following strings (case is not significant):

Option Notes
Next Forward direction from current position. This is the default value.
Prev Backward direction from current position.
First Forward direction from the start.
Last Backward direction from the end.
Absolute Absolute position from the start. Requires rownumber.

rownumber

The row number, first one is 0. Only needed when how is set to Absolute.

返回值

成功时返回 TRUE, 或者在失败时返回 FALSE.

范例

Example #1 A fetch into example

<?php
$conn
=ovrimos_connect("neptune""8001""admin""password");
if (
$conn!=0) {
    echo 
"Connection ok!";
    
$res=ovrimos_exec($conn"select table_id, table_name from sys.tables");
    if (
$res != 0) {
        echo 
"Statement ok!";
        if (
ovrimos_fetch_into($res$row)) {
            list(
$table_id$table_name) = $row;
            echo 
"table_id=" $table_id ", table_name=" $table_name "\n";
            if (
ovrimos_fetch_into($res$row)) {
                list(
$table_id$table_name) = $row;
                echo 
"table_id=" $table_id ", table_name=" $table_name "\n";
            } else {
                echo 
"Next: error\n";
            }
        } else {
            echo 
"First: error\n";
        }
        
ovrimos_free_result($res);
    }
    
ovrimos_close($conn);
}
?>

参见


Ovrimos SQL 函数
PHP 手册