php man page for oci_fetch_row

Query: oci_fetch_row

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

OCI_FETCH_ROW(3)														  OCI_FETCH_ROW(3)

oci_fetch_row - Returns the next row from a query as a numeric array

SYNOPSIS
array oci_fetch_row (resource $statement)
DESCRIPTION
Returns a numerically indexed array containing the next result-set row of a query. Each array entry corresponds to a column of the row. This function is typically called in a loop until it returns FALSE, indicating no more rows exist. Calling oci_fetch_row(3) is identical to calling oci_fetch_array(3) with OCI_NUM + OCI_RETURN_NULLS.
PARAMETERS
o $statement -A valid OCI8 statement identifier created by oci_parse(3) and executed by oci_execute(3), or a REF CURSOR statement identifier.
RETURN VALUES
Returns a numerically indexed array. If there are no more rows in the $statement then FALSE is returned.
EXAMPLES
Example #1 oci_fetch_row(3) Example <?php $conn = oci_connect('hr', 'welcome', 'localhost/XE'); if (!$conn) { $e = oci_error(); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); } $stid = oci_parse($conn, 'SELECT department_id, department_name FROM departments'); oci_execute($stid); while (($row = oci_fetch_row($stid)) != false) { echo $row[0] . " " . $row[1] . "<br> "; } oci_free_statement($stid); oci_close($conn); ?>
NOTES
Note See oci_fetch_array(3) for more examples of fetching rows.
SEE ALSO
oci_fetch(3), oci_fetch_all(3), oci_fetch_array(3), oci_fetch_assoc(3), oci_fetch_object(3). PHP Documentation Group OCI_FETCH_ROW(3)
Related Man Pages
oci_execute(3) - php
oci_fetch_all(3) - php
oci_fetch_object(3) - php
oci_field_scale(3) - php
oci_field_type_raw(3) - php
Similar Topics in the Unix Linux Community
how to return an array of elements from oracle to shell script
Matching words in Perl
Data selection
for each value in an array, execute select statement
While loop within if statement