i5_list_fields

 

Gets list of fields for resource.

 

array i5_list_fields (

resource result/file )

 

Details

 

Returns an indexed table showing each file field name or SQL request. Table size allows knowing fields number. This number can be known directly using i5_num_fields function.

 

Parameters

 

result

Resource describing file or other record set.

 

 

Returns:

Array containing field names, in order.

 

I5_ERR_PHP_HDLDFT

256

No default connection found.

I5_ERR_PHP_OPTIONSTYPE

259

The type of " I5_OPTIONS_ALIAS" option must be x and not x

I5_ERR_PHP_OPTIONSNUMBER

260

Option number -1 is unknown.

I5_ERR_PHP_TYPEPARAM

262

Type of element x in parameter -1 must be y. Type z was provided.

 

 

Example

 

<?php
$conn = i5_connect("MY_AS", "USER", "PASSWORD");

if ($conn) {
    $res = i5_query("SELECT * FROM animals");
    $fields = i5_list_fields($res);

    $nb_fields = count($fields);

    echo "ANIMALS table contains ".$nb_fields." columns.\n";

 

    $fich = i5_open("EASYCOM/SP_CUST");

    $fields = i5_list_fields($fich);

    $nb_fields = count($fields);

    echo "SP_CUST file contains ".$nb_fields." fields.";

    }

 

 

 

See also

 

i5_field_name

i5_field_len

i5_field_scale

i5_field_type

i5_info