FBIRD_FETCH_ROW

Purpose

Use the fbird_fetch_row function to fetch a row of a result set into an array.

Syntax

<fetch_assoc> ::=
   fbird_fetch_row( res_hndl, [ flags ] )

Element 

Type

Description

res_hndl

resource

A valid result set handle

flags

int

Fetch flags

<return>

mixed

An array on success, False if no rows left

Semantics

The fbird_fetch_row() function fetches one row of data from the result set. The row is returned as an array. Each result column is stored in an array offset, starting at offset 0.

This function returns an array that corresponds to the fetched row. Subsequent calls will return the next row in the result set, or False if there are no more rows.

Example

The below example connects to a database, executes a query and fetches each row, echoing to the browser:

$conn = fbird_connect($host, $username, $password);
$sql = 'SELECT * FROM tblname';
$res = fbird_query($conn, $sql);
while ($row = fbird_fetch_assoc($sres)) {
   echo $row["EMAIL"]."\n";
}
fbird_free_result($res);
fbird_close($conn);

See also

fbird_fetch_object, fbird_fetch_assoc, fbird_query, fbird_execute

Extend this topic - Post a comment