/** * Insert ID * * @access public * @return integer */ function insert_id() { return @cubrid_insert_id($this->conn_id); }
public function insertId() { if (!empty($this->connect)) { return cubrid_insert_id($this->connect); } else { return false; } }
public static function insertId() { return cubrid_insert_id(); }
/** * Get the id form last insert * * @return int */ public function insertId() { return cubrid_insert_id($this->link); }
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; }
/** * @group arnia-wrong-parameters */ public function testCubridInsertId3() { if (OUTPUT_FUNCTION_NAME == true) { echo "\r\nRunning: " . __FUNCTION__ . " = "; } try { $table = "test_table_2"; $this->sql = "CREATE TABLE test_table_2(column_integer INTEGER, column_serial INTEGER auto_increment)"; cubrid_execute($this->con, $this->sql); $this->sql = "INSERT INTO test_table_2(column_integer) VALUES(" . rand() . ")"; cubrid_execute($this->con, $this->sql); $value = cubrid_insert_id(-1); $this->assertTrue(FALSE, "Expected Exception not thrown."); } catch (Exception $e) { //echo $e->getMessage()."\r\n"; $this->assertEquals(-2006, cubrid_error_code()); $this->assertEquals(4, cubrid_error_code_facility()); $this->assertEquals('Invalid parameter', cubrid_error_msg()); } $this->sql = "DROP TABLE test_table_2"; cubrid_execute($this->con, $this->sql); }