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.
ibase_fetch_object
(PHP 5, PHP 7 < 7.4.0)
ibase_fetch_object — Get an object from a InterBase database
Description
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.
Parameters
-
result_id -
An InterBase result identifier obtained either by ibase_query() or ibase_execute().
-
fetch_flag -
fetch_flagis a combination of the constantsIBASE_TEXTandIBASE_UNIXTIMEORed together. PassingIBASE_TEXTwill cause this function to return BLOB contents instead of BLOB ids. PassingIBASE_UNIXTIMEwill cause this function to return date/time values as Unix timestamps instead of as formatted strings.
Return Values
Returns an object with the next row information, or false if there are
no more rows.
Examples
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);
?>See Also
- ibase_fetch_row() - Fetch a row from an InterBase database
- ibase_fetch_assoc() - Fetch a result row from a query as an associative array
add a note
User Contributed Notes 1 note
r dot metzger at spectraweb dot ch ¶
23 years ago
