SunshinePHP 2016


(PHP 5)

ibase_field_infoConsulta información sobre un determinado campo


array ibase_field_info ( resource $result , int $field_number )

Devuelve un array con información acerca de un campo de una consulta que ya se haya ejecutado.



Identificador de resultado de InterBase.


Posición del campo.

Valores devueltos

Devuelve un array con las siguientes claves: name, alias, relation, length y type.


Ejemplo #1 Ejemplo de ibase_field_info()

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

Ver también

add a note add a note

User Contributed Notes 2 notes

tiago at econtabil dot com
5 years ago
In Firebird 1.5 this function INT64 returned to the fields created as floating point numbers. In Firebird 2.x this function returns as NUMERIC (SIZE, PRECISION). Example: NUMERIC (18,2)

In Brazilian Portuguese:
No Firebird 1.5 esta função retornava INT64 para os campos criados como numéricos com ponto flutuante. No Firebird 2.x esta função retorna como NUMERIC(TAMANHO, PRECISAO). Exemplo: NUMERIC(18,2)
tiago at econtabil dot com
9 years ago
$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.
To Top