Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : Firebird/InterBase Functions : ibase_fetch_object

ibase_fetch_object

Get an object from a InterBase database (PHP 4, PHP 5)
object ibase_fetch_object ( resource result_id [, int fetch_flag] )

Example 683. 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);
?>

Code Examples / Notes » ibase_fetch_object

richard

The loop below is execute for all NOT NULL columns!
$foo = get_object_vars($dbRow);
foreach ($foo as $col=>$val) {
...
}


r dot metzger

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

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 )

Change Language


Follow Navioo On Twitter
ibase_add_user
ibase_affected_rows
ibase_backup
ibase_blob_add
ibase_blob_cancel
ibase_blob_close
ibase_blob_create
ibase_blob_echo
ibase_blob_get
ibase_blob_import
ibase_blob_info
ibase_blob_open
ibase_close
ibase_commit_ret
ibase_commit
ibase_connect
ibase_db_info
ibase_delete_user
ibase_drop_db
ibase_errcode
ibase_errmsg
ibase_execute
ibase_fetch_assoc
ibase_fetch_object
ibase_fetch_row
ibase_field_info
ibase_free_event_handler
ibase_free_query
ibase_free_result
ibase_gen_id
ibase_maintain_db
ibase_modify_user
ibase_name_result
ibase_num_fields
ibase_num_params
ibase_param_info
ibase_pconnect
ibase_prepare
ibase_query
ibase_restore
ibase_rollback_ret
ibase_rollback
ibase_server_info
ibase_service_attach
ibase_service_detach
ibase_set_event_handler
ibase_timefmt
ibase_trans
ibase_wait_event
eXTReMe Tracker