function cubrid_ColumnDataType($identifier, $table, $column) { $id_result = cubrid_mysql_query_native(get_SQL_ColumnDataType($table, $column), $identifier); $id_row = cubrid_fetch_row($id_result); cubrid_free_result($id_result); $calculated_value = $id_row[1]; return $calculated_value; }
/** * @group arnia-wrong-parameters */ public function testCubridFreeResult3() { if (OUTPUT_FUNCTION_NAME == true) { echo "\r\nRunning: " . __FUNCTION__ . " = "; } try { $this->assertTrue($this->createTestTable(), "Failed to create the test table."); $this->sql = "SELECT * FROM test_table"; $this->req = cubrid_execute($this->con, $this->sql); $val = cubrid_free_result(-1); $this->assertTrue(FALSE, "Expected Exception not thrown."); } catch (Exception $e) { //echo $e->getMessage()."\r\n"; $this->assertEquals(0, cubrid_error_code()); $this->assertEquals(0, cubrid_error_code_facility()); $this->assertEquals('', cubrid_error_msg()); } $this->deleteTestTable(); }
function query($query) { // This keeps the connection alive for very long running scripts if ($this->num_queries >= 500) { $this->disconnect(); $this->connect($this->dbuser, $this->dbpassword, $this->dbname, $this->dbhost, $this->dbport); } // Initialise return $return_val = 0; // Flush cached values.. $this->flush(); // For reg expressions $query = trim($query); // Log how the function was called $this->func_call = "\$db->query(\"{$query}\")"; // Keep track of the last query for debug.. $this->last_query = $query; // Count how many queries there have been $this->num_queries++; // Start timer $this->timer_start($this->num_queries); // Use core file cache function if ($cache = $this->get_cache($query)) { // Keep tack of how long all queries have taken $this->timer_update_global($this->num_queries); // Trace all queries if ($this->use_trace_log) { $this->trace_log[] = $this->debug(false); } return $cache; } // If there is no existing database connection then try to connect if (!isset($this->dbh) || !$this->dbh) { $this->connect($this->dbuser, $this->dbpassword, $this->dbname, $this->dbhost, $this->dbport); } // Perform the query via std cubrid_query function.. $this->result = @cubrid_query($query, $this->dbh); // If there is an error then take note of it.. if ($str = @cubrid_error($this->dbh)) { $this->register_error($str); $this->show_errors ? trigger_error($str, E_USER_WARNING) : null; return false; } // Query was an insert, delete, update, replace if (preg_match("/^(insert|delete|update|replace|truncate|drop|create|alter)\\s+/i", $query)) { $is_insert = true; $this->rows_affected = @cubrid_affected_rows($this->dbh); // Take note of the insert_id if (preg_match("/^(insert|replace)\\s+/i", $query)) { $this->insert_id = @cubrid_insert_id($this->dbh); } // Return number fo rows affected $return_val = $this->rows_affected; } else { $is_insert = false; // Take note of column info $i = 0; while ($i < @cubrid_num_fields($this->result)) { $this->col_info[$i] = @cubrid_fetch_field($this->result); $i++; } // Store Query Results $num_rows = 0; while ($row = @cubrid_fetch_object($this->result)) { // Store relults as an objects within main array $this->last_result[$num_rows] = $row; $num_rows++; } @cubrid_free_result($this->result); // Log number of rows the query returned $this->num_rows = $num_rows; // Return number of rows selected $return_val = $this->num_rows; } // disk caching of queries $this->store_cache($query, $is_insert); // If debug ALL queries $this->trace || $this->debug_all ? $this->debug() : null; // Keep tack of how long all queries have taken $this->timer_update_global($this->num_queries); // Trace all queries if ($this->use_trace_log) { $this->trace_log[] = $this->debug(false); } return $return_val; }
function sql_free_result($result) { $fresult = cubrid_free_result($result); if ($fresult === false) { output_error("SQL Error: " . sql_error(), E_USER_ERROR); return false; } $fresult = cubrid_close_request($result); if ($fresult === false) { output_error("SQL Error: " . sql_error(), E_USER_ERROR); return false; } if ($fresult === true) { return true; } }