   #PHP Manual Informix functions ifx_fetch_row ifx_fieldtypes

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                              ifx_fieldproperties

   (PHP 3>= 3.0.3, PHP 4 )
   ifx_fieldproperties -- List of SQL fieldproperties

Description

   array ifx_fieldproperties ( int result_id)

   Returns an associative array with fieldnames as key and the SQL
   fieldproperties as data for a query with result_id. Returns FALSE on
   error.

   Returns the Informix SQL fieldproperties of every field in the query
   as an associative array. Properties are encoded as:
   "SQLTYPE;length;precision;scale;ISNULLABLE" where SQLTYPE = the
   Informix type like "SQLVCHAR" etc. and ISNULLABLE = "Y" or "N".

   Example 1. Informix SQL fieldproperties
   <?php
   $properties = ifx_fieldproperties ($resultid);
   if (! isset($properties)) {
       /* ... error ... */
   }
   for ($i = 0; $i < count($properties); $i++) {
       $fname = key ($properties);
       printf ("%s:\t type =  %s\n", $fname, $properties[$fname]);
       next ($properties);
   }
   ?>
   ______________________________________________________________________

   Prev          Home           Next
   ifx_fetch_row  Up  ifx_fieldtypes
