function field_data() { $retval = array(); $tablePrimaryKeys = array(); while ($field = cubrid_fetch_field($this->result_id)) { $F = new stdClass(); $F->name = $field->name; $F->type = $field->type; $F->default = $field->def; $F->max_length = $field->max_length; $res = cubrid_query($this->conn_id, "SELECT COUNT(*) FROM db_index WHERE class_name = '" . $field->table . "' AND is_primary_key = 'YES' AND index_name = 'pk_" . $field->table . "_" . $field->name . "'"); if ($res) { $row = cubrid_fetch_array($res, CUBRID_NUM); $F->primary_key = $row[0] > 0 ? 1 : null; } else { $F->primary_key = null; } if (is_resource($res)) { cubrid_close_request($res); $this->result_id = FALSE; } $retval[] = $F; } return $retval; }
function sql_query($query, $link = null) { global $NumQueries; if (isset($link)) { $result = cubrid_query($query, $link); } if (!isset($link)) { $result = cubrid_query($query); } if ($result === false) { output_error("SQL Error: " . sql_error(), E_USER_ERROR); return false; } if ($result !== false) { ++$NumQueries; return $result; } }
/** * Execute the query * * @access private called by the base class * @param string an SQL query * @return resource */ function _execute($sql) { $sql = $this->_prep_query($sql); return @cubrid_query($sql, $this->conn_id); }
/** * Execute the query * * @param string $sql an SQL query * @return resource */ protected function _execute($sql) { return @cubrid_query($sql, $this->conn_id); }
/** * Field data * * Generates an array of objects containing field meta-data * * @access public * @return array */ function field_data() { $retval = array(); $tablePrimaryKeys = array(); while ($field = cubrid_fetch_field($this->result_id)) { $F = new stdClass(); $F->name = $field->name; $F->type = $field->type; $F->default = $field->def; $F->max_length = $field->max_length; // At this moment primary_key property is not returned when // cubrid_fetch_field is called. The following code will // provide a patch for it. primary_key property will be added // in the next release. // TODO: later version of CUBRID will provide primary_key // property. // When PK is defined in CUBRID, an index is automatically // created in the db_index system table in the form of // pk_tblname_fieldname. So the following will count how many // columns are there which satisfy this format. // The query will search for exact single columns, thus // compound PK is not supported. $res = cubrid_query($this->conn_id, "SELECT COUNT(*) FROM db_index WHERE class_name = '" . $field->table . "' AND is_primary_key = 'YES' AND index_name = 'pk_" . $field->table . "_" . $field->name . "'"); if ($res) { $row = cubrid_fetch_array($res, CUBRID_NUM); $F->primary_key = $row[0] > 0 ? 1 : null; } else { $F->primary_key = null; } if (is_resource($res)) { cubrid_close_request($res); $this->result_id = FALSE; } $retval[] = $F; } return $retval; }
public function query($query, $security = array()) { $this->query = cubrid_query($query, $this->connect); return $this->query; }
#!/usr/bin/php <?php $sql = "insert into foo1 values(1,1)"; for ($i = 0; $i < 1; $i++) { $con = @cubrid_connect("test-db-server", 33113, "testdb", "dba", ""); if ($con) { $req = cubrid_query($sql, $con); if ($req) { echo "cubrid_query error"; } while ($row = cubrid_fetch($req)) { echo "to: \$ row [0], b: \$ row [1] \\ n"; } if ($req) { cubrid_close_request($req); } cubrid_disconnect($con); } else { echo "failed cubrid_connect . \\ n "; sleep(1); } }
/** * Main function for querying to database * * @param $query The SQL querey statement * @return string|objet Return the resource id of query */ public function query($sql) { if (is_null($this->link)) { $this->init(); } $query = cubrid_query($sql, $this->link); $this->lastQuery = $sql; if ($this->lastError = cubrid_error($this->link)) { if ($this->throwError) { throw new \Exception($this->lastError); } else { $this->printError(); return false; } } return $query; }
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; }
<?php mysql_query($res, <<<SQL select {$a} from table SQL ); pg_query($res, "select {$a} from table "); sqlsrv_query($res, "select " . $a . " from table "); \cubrid_query($res, 'select ' . $a . ' from table '); //sybase_query //ingres_query // OK, as no concatenation mysqli_query($res, <<<SQL select * from table SQL ); // Nowdoc \ingres_query($res, <<<'SQL' select * from table $table; SQL );