ovrimos_fetch_into
(PHP 4 >= 4.0.3, PHP 5 <= 5.0.5)
ovrimos_fetch_into — Fetches a row from the result set
Description
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.
Parameters
-
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
howis set to Absolute.
Return Values
Returns TRUE on success or FALSE on failure.
Examples
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);
}
?>
0044 203 3971 555 (UK)