PHP cubrid_query函数代码示例

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