©
This document uses PHP Chinese website manual Release
(PHP 5)
ibase_fetch_object — Get an object from a InterBase database
$result_id
[, int $fetch_flag
= 0
] )Fetches a row as a pseudo-object from a given result identifier.
Subsequent calls to ibase_fetch_object() return the next row in the result set.
result_id
An InterBase result identifier obtained either by ibase_query() or ibase_execute() .
fetch_flag
fetch_flag
is a combination of the constants
IBASE_TEXT
and IBASE_UNIXTIME
ORed together. Passing IBASE_TEXT
will cause this
function to return BLOB contents instead of BLOB ids. Passing
IBASE_UNIXTIME
will cause this function to return
date/time values as Unix timestamps instead of as formatted strings.
Returns an object with the next row information, or FALSE
if there are
no more rows.
Example #1 ibase_fetch_object() example
<?php
$dbh = ibase_connect ( $host , $username , $password );
$stmt = 'SELECT * FROM tblname' ;
$sth = ibase_query ( $dbh , $stmt );
while ( $row = ibase_fetch_object ( $sth )) {
echo $row -> email . "\n" ;
}
ibase_close ( $dbh );
?>
[#1] r dot metzger at spectraweb dot ch [2000-11-27 02:55:03]
Interbase not always stores in uppercase. It depends how you created the table. If you use CREATE TABLE xyz("email" varchar(90)) you can get informations with $row->email.
If you use CREATE TABLE xyz(email varchar(90)) you have to use $row->EMAIL.