ibase_field

Description

array ibase_field_info ( resource result, int field_number )

Returns an array with information about a field after a select query has been run. The array is in the form of name, alias, relation, length, type.


<?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"; 
    }
?>

See also: ibase_num_fields().

add a note User Contributed Notes

tiago at econtabil dot com
07-Apr-2006 07:40


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.

add a note