PHP: Hypertext Preprocessor (original) (raw)

oci_fetch_row

(PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0)

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

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](reserved.constants.php#constant.false), indicating no more rows exist.

Calling oci_fetch_row() is identical to callingoci_fetch_array() with [OCI_NUM](oci8.constants.php#constant.oci-num) + [OCI_RETURN_NULLS](oci8.constants.php#constant.oci-return-nulls).

Parameters

statement

A valid OCI8 statement identifier created by oci_parse() and executed by oci_execute(), or a REF CURSOR statement identifier.

Return Values

Returns a numerically indexed array. If there are no more rows in the statement then [false](reserved.constants.php#constant.false) is returned.

Examples

Example #1 oci_fetch_row() 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=ocifetchrow(row = oci_fetch_row(row=ocif​etchr​ow(stid)) != false) {
echo row[0]."".row[0] . " " . row[0]."".row[1] . "
\n";
}oci_free_statement($stid);
oci_close($conn);?>`

See Also

• oci_fetch() - Fetches the next row from a query into internal buffers
• oci_fetch_all() - Fetches multiple rows from a query into a two-dimensional array
• oci_fetch_array() - Returns the next row from a query as an associative or numeric array
• oci_fetch_assoc() - Returns the next row from a query as an associative array
• oci_fetch_object() - Returns the next row from a query as an object

Found A Problem?

There are no user contributed notes for this page.