Web студия "GrandView"
  Главная   Написать Контакты
   
   
О проекте
Руководство php
 

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().



ibase_fetch_row> <ibase_fetch_assoc
Last updated: Sat, 27 Jan 2007
 
add a note 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 )

ibase_fetch_row> <ibase_fetch_assoc
Last updated: Sat, 27 Jan 2007
 
 
Новости
11 июля 2007
Сайт запущен
© 2007 info@grandviewstudio.com

Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/sites/grandviewstudiocom/www/65f67d67a94ad980786580ae69e11c07/sape.php on line 324

Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/sites/grandviewstudiocom/www/65f67d67a94ad980786580ae69e11c07/sape.php on line 330
Z058440144362 Z348613067571