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

copy to clipboard

<?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

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

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

Code Examples / Notes » ibase_field_info

Change Language

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