(PHP 3 >= 3.0.4, PHP 4, PHP 5)
ocifetchinto -- Fetches the next row into an array
Description
int
ocifetchinto ( resource statement, array &result [, int mode] )
ocifetchinto() fetches the next row of SELECT
statement into the result array.
ocifetchinto() overwrites previous content of
result. By default
result will contain a zero-based array of all
columns that are not NULL.
The mode parameter allows you to change the
default behaviour. You can specify more the one flag by simply adding
them up (e.g. OCI_ASSOC+OCI_RETURN_NULLS). Valid values are:
|
OCI_ASSOC - return an associative array.
|
|
OCI_NUM - return a numeric array starting with
zero (default behaviour).
|
|
OCI_RETURN_NULLS - return the empty values for
column, which values is NULL.
|
|
OCI_RETURN_LOBS - return the value of a LOB
instead of the descriptor.
|
Example 1. ocifetchinto() example
<?php
$conn = ocilogon("username", "password");
$query = "SELECT apples FROM oranges";
$statement = OCIParse ($conn, $query);
OCIExecute ($statement);
while (OCIFetchInto ($statement, $row, OCI_ASSOC)) {
echo $row['apples'];
}
?>
|
|
See also
oci_fetch_array(),
oci_fetch_object(),
oci_fetch_assoc(),
oci_fetch_row(),
oci_fetch() and
oci_execute().
