PHP: ibase_fetch_object - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

ibase_fetch_row ibase_fetch_assoc

Last updated: Sat, 27 Jan 2007

view this page in

# ibase_fetch_object

(PHP 3 >= 3.0.7, PHP 4, PHP 5)

ibase_fetch_object -- Get an object from a InterBase database

## Description

object ibase_fetch_object ( resource result_id [, int fetch_flag] )

Fetches a row as a pseudo-object from a `result_id` obtained either by ibase_query() or ibase_execute().

`<?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);
?>`

Subsequent calls to ibase_fetch_object() return the next row in the result set, or `FALSE` if there are no more rows.

`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.

See also ibase_fetch_row() and ibase_fetch_assoc().

add a note User Contributed Notes
ibase_fetch_object
richard at willmann dot sk
31-Dec-2000 05:29
`The loop below is execute for all NOT NULL columns!
$foo = get_object_vars($dbRow);
foreach ($foo as $col=>$val) {
...
}`
r dot metzger at spectraweb dot ch
27-Nov-2000 02:55
`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.`
edemorsy at online dot fr
14-Jul-2000 10:25
`I had an "empty result" problem, 'til I realized that InterBase stores field names in upper case, so when printing the result of your query you have to use upper case for your properties ( for example here $row->EMAIL )`
add a note
ibase_fetch_row ibase_fetch_assoc

Last updated: Sat, 27 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 09:32:46 2007 PST