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



PHP : Function Reference : Firebird/InterBase Functions : ibase_field_info

ibase_field_info

Get information about a field (PHP 4, PHP 5)
array ibase_field_info ( resource result, int field_number )

Example 684. ibase_field_info() example

<?php
$rs
= ibase_query("SELECT * FROM tablename");
$coln = ibase_num_fields($rs);
for (
$i = 0; $i < $coln; $i++) {
   
$col_info = ibase_field_info($rs, $i);
   echo
"name: ". $col_info['name']. "\n";
   echo
"alias: ". $col_info['alias']. "\n";
   echo
"relation: ". $col_info['relation']. "\n";
   echo
"length: ". $col_info['length']. "\n";
   echo
"type: ". $col_info['type']. "\n";
}
?>

Code Examples / Notes » ibase_field_info

tiago

Example:
$db = ibase_connect($host,$username,$password, "None", 0, 3 ) or die ('Error trying connect to Database!');
$select = "SELECT * from TABLE";
$sql = ibase_query($db,$select) or die($select);
$total_fields= ibase_num_fields($sql);
for ($j = 1; $j <= $total_fields; $j++)
 {
   $info_field = ibase_field_info($sql, $j-1 );
   print("Name: " . $info_campo[1]); // print the field name
   print("Type:". $info_campo[4]); //print the field type
   print("Size: " . $info_campo[3]); // print the field size
 }
This function does not return the type from the fields as we are accustomed in interbase.
Example: Fields VARCHAR are returns as VARYING. Fields of the type CHAR return TEXT.
Tested in Firebird 1.5 Super Server.


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