ODBC_FETCH_INTO(3) 1 ODBC_FETCH_INTO(3)odbc_fetch_into - Fetch one result row into arraySYNOPSIS
int odbc_fetch_into (resource $result_id, array &$result_array, [int $rownumber])
DESCRIPTION
Fetch one result row into array.
PARAMETERS
o $result_id
- The result resource.
o $result_array
- The result array that can be of any type since it will be converted to type array. The array will contain the column values
starting at array index 0.
o $rownumber
- The row number.
RETURN VALUES
Returns the number of columns in the result; FALSE on error.
EXAMPLES
Example #1
odbc_fetch_into(3) examples
<?php
$rc = odbc_fetch_into($res_id, $my_array);
?>
or
<?php
$rc = odbc_fetch_into($res_id, $my_array, 2);
?>
PHP Documentation Group ODBC_FETCH_INTO(3)
Check Out this Related Man Page
OVRIMOS_FETCH_INTO(3)OVRIMOS_FETCH_INTO(3)ovrimos_fetch_into - Fetches a row from the result setSYNOPSIS
bool ovrimos_fetch_into (int $result_id, array &$result_array, [string $how], [int $rownumber])
DESCRIPTION
Fetches a row from the given result set, into $result_array.
PARAMETERS
o $result_id
- A result identifier, returned by ovrimos_execute(3) or ovrimos_exec(3).
o $result_array
- You must provide an array by reference. It will be filled with the fetched values.
o $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. |
| | |
+---------+---------------------------------------------------+
o $rownumber
- The row number, first one is 0. Only needed when $how is 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 . "
";
if (ovrimos_fetch_into($res, $row)) {
list($table_id, $table_name) = $row;
echo "table_id=" . $table_id . ", table_name=" . $table_name . "
";
} else {
echo "Next: error
";
}
} else {
echo "First: error
";
}
ovrimos_free_result($res);
}
ovrimos_close($conn);
}
?>
SEE ALSO ovrimos_fetch_row(3).
PHP Documentation Group OVRIMOS_FETCH_INTO(3)