 |
|
 PhpDig.net |
What is PhpDig?
PhpDig is a PHP MySQL based Web Spider & Search Engine. |
ibase_fetch_object
Description
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.
Note
Available in PHP 3 since 3.0.7, PHP 4 since 4.0RC1
Example
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";
}