What is PhpDig?
PhpDig is a PHP MySQL based
Web Spider & Search Engine.



ibase_fetch_object — Fetches a row of data as an object.


object ibase_fetch_object(result[, flags]);
resource result: Result set handle
int flags (optional): Flags controlling how to fetch certain types of columns


Object containing current record, FALSE on error


Reads the current row in the InterBase result set and returns an object with each member containing the value of the corresponding field and each key containing the field name. Returns FALSE if there are no more rows fetch or error occurred. Also advances the current record pointer in the result set to the next one.

Note that InterBase returns the column names uppercased, unless you put the columns name inside double quotes when originally creating the table (CREATE TABLE ("lowercased_name" int, ...).

The flags controlling how to fetch certain types of columns are ORed together with || and they are:

  • IBASE_UNIXTIME: fetch date, time and timestamp columns as Unix timestamp instead of normal textual format (see also ibase_timefmt() ). With time columns, this essentially means getting seconds from midnight.

  • IBASE_TEXT: fetch the contents of a BLOB columns instead of its internal ID in database.


Available in PHP 3 since 3.0.7, PHP 4 since 4.0RC1


Example 541. Retrieve rows from database

$db = ibase_connect('/opt/interbase/examples/employee.gdb') or die("Couldn't connect to database!");
$rs = ibase_query($db, 'SELECT hire_date, full_name FROM employees');
while ($row = ibase_fetch_object($rs)) {
    print $row->HIRE_DATE . "\t";
    print $row->FULL_NAME . "\n";
// ... and once again, this time fetching hire_date as Unix timestamp
$rs = ibase_query($db, 'SELECT hire_date, full_name FROM employees');
while ($row = ibase_fetch_object($rs, IBASE_UNIXTIME)) {
    print $row->HIRE_DATE . "\t";
    print $row->FULL_NAME . "\n";

PHP Functions Essential Reference. Copyright © 2002 by New Riders Publishing (Authors: Zak Greant, Graeme Merrall, Torben Wilson, Brett Michlitsch). This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later (the latest version is presently available at The authors of this book have elected not to choose any options under the OPL. This online book was obtained from and is designed to provide information about the PHP programming language, focusing on PHP version 4.0.4 for the most part. The information is provided on an as-is basis, and no warranty or fitness is implied. All persons and entities shall have neither liability nor responsibility to any person or entity with respect to any loss or damage arising from the information contained in this book.

Powered by: vBulletin Version 3.0.7
Copyright ©2000 - 2005, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.