Firebird 2.0
PHP5 Programming
Manual

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


previous page goto index next page

Legal information