Last updated: Sat, 24 Mar 2007

ibase_field_info

(PHP 4, PHP 5)

ibase_field_info — Get information about a 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
ibase_field_info

tiago at econtabil dot com
07-Apr-2006 04: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

ibase_free_event_handler

ibase_fetch_row

Last updated: Sat, 24 Mar 2007