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