function _insertid($table, $column) { if (!is_resource($this->_resultid) || get_resource_type($this->_resultid) !== 'pgsql result') { return false; } $oid = pg_getlastoid($this->_resultid); // to really return the id, we need the table and column-name, else we can only return the oid != id return empty($table) || empty($column) ? $oid : $this->GetOne("select {$column} FROM {$table} WHERE oid=" . (int) $oid); }
function _insertid() { return pg_getlastoid($this->_resultid); }
function _insertid() { if (!is_resource($this->_resultid)) { return false; } return pg_getlastoid($this->_resultid); }
function getInsertID() { return pg_getlastoid($this->result[$this->stack_last]); }
function _insertid() { if (!is_resource($this->_resultid) || get_resource_type($this->_resultid) !== 'pgsql result') { return false; } return pg_getlastoid($this->_resultid); }
function db_last_oid() { global $sys_dbhost, $sys_dbuser, $sys_dbpasswd, $sys_dbname, $db_debug, $conn, $conn_update, $QUERY_COUNT; global $DBSERVER, $OWNER, $PW, $DB; return pg_getlastoid($conn); }
/** * * Returns the last primary key from an insert * * @param qhandle query result set handle * @param table_name is the name of the table you inserted into * @param pkey_field_name is the field name of the primary key * */ function db_insertid($qhandle, $table_name, $pkey_field_name) { $oid = @pg_getlastoid($qhandle); if ($oid) { $sql = "SELECT {$pkey_field_name} AS id FROM {$table_name} WHERE oid='{$oid}'"; //echo $sql; $res = db_query($sql); if (db_numrows($res) > 0) { return db_result($res, 0, 'id'); } else { // echo "No Rows Matched"; // echo db_error(); return 0; } } else { // echo "No OID"; // echo db_error(); return 0; } }
function get_last_insert_id($table, $field) { if (!isset($table) || $table == '' || !isset($field) || $field == '') { return -1; } $oid = pg_getlastoid($this->Query_ID); if ($oid == -1) { return -1; } $result = @pg_Exec($this->Link_ID, "select {$field} from {$table} where oid={$oid}"); if (!$result) { return -1; } $Record = @pg_fetch_array($result, 0); @pg_freeresult($result); if (!is_array($Record)) { return -1; } return $Record[0]; }
function _insertid($table,$column) { if (!is_resource($this->_resultid) || get_resource_type($this->_resultid) !== 'pgsql result') return false; $oid = pg_getlastoid($this->_resultid); // to really return the id, we need the table and column-name, else we can only return the oid != id return empty($table) || empty($column) ? $oid : $this->GetOne("SELECT $column FROM $table ORDER BY $column DESC LIMIT 1"); }
<?php include 'config.inc'; $db = pg_connect($conn_str); $result = pg_exec("SELECT * FROM " . $table_name); pg_numrows($result); pg_numfields($result); pg_fieldname($result, 0); pg_fieldsize($result, 0); pg_fieldtype($result, 0); pg_fieldprtlen($result, 0); pg_fieldisnull($result, 0); pg_result($result, 0, 0); $result = pg_exec("INSERT INTO " . $table_name . " VALUES (7777, 'KKK')"); $oid = pg_getlastoid($result); pg_freeresult($result); pg_errormessage(); $result = pg_exec("UPDATE " . $table_name . " SET str = 'QQQ' WHERE str like 'RGD';"); pg_cmdtuples($result); echo "OK";
/** * Return the last insert ID * @return integer */ protected function insert_id() { return @pg_getlastoid($this->resResult); }
function Add_table($value, $func_fields = null, $func_table = null, $id_name = null) { //global $link; global $DBHandle; if ($func_fields != "") { $this->fields = $func_fields; } if ($func_table != "") { $this->table = $func_table; } $QUERY = "INSERT INTO \"" . $this->table . "\" (" . $this->fields . ") values (" . trim($value) . ")"; if ($this->debug_st) { echo "<br>QUERY:" . $QUERY; } if (!($res = $DBHandle->query($QUERY))) { //if (! $res=DbExec($link, $QUERY)) { //$this -> errstr = "Could not create a new instance in the table '".$this -> table."'"; $this->errstr = $DBHandle->Error; return false; } if ($id_name != "") { $oid = pg_getlastoid($res); if ($oid < 0) { return false; } $sql = 'SELECT "' . $id_name . '" FROM "' . $this->table . '" WHERE oid=\'' . $oid . '\''; if (!($res = $DBHandle->query($sql))) { return false; } $DBHandle->next_record(); $row[] = $DBHandle->Record; return $row[0][0]; } return true; }
/** * Find the primary key of the last insertion on the current db connection * * @param string $table name of table the insert was performed on * @param string $field the autoincrement primary key of the table * @return integer the id, -1 if fails */ public function get_last_insert_id($table, $field = '') { switch ($GLOBALS['phpgw_info']['server']['db_type']) { case 'postgres': $params = explode('.', $this->adodb->pgVersion); if ($params[0] < 8 || $params[0] == 8 && $params[1] == 0) { $oid = pg_getlastoid($this->adodb->_resultid); if ($oid == -1) { return -1; } $result = @pg_Exec($this->adodb->_connectionID, "select {$field} from {$table} where oid={$oid}"); } else { $result = @pg_Exec($this->adodb->_connectionID, "select lastval()"); } if (!$result) { return -1; } $Record = @pg_fetch_array($result, 0); @pg_freeresult($result); if (!is_array($Record)) { return -1; } return $Record[0]; break; case 'mssql': /* MSSQL uses a query to retrieve the last * identity on the connection, so table and field are ignored here as well. */ if (!isset($table) || $table == '' || !isset($field) || $field == '') { return -1; } $result = @mssql_query("select @@identity", $this->adodb->_queryID); if (!$result) { return -1; } return mssql_result($result, 0, 0); break; default: return $this->adodb->Insert_ID($table, $field); } }
function _insertid($table, $column) { if (!is_resource($this->_resultid) || get_resource_type($this->_resultid) !== 'pgsql result') { return false; } $oid = pg_getlastoid($this->_resultid); // to really return the id, we need the table and column-name, else we can only return the oid != id return empty($table) || empty($column) ? $oid : $this->GetOne("SELECT CURRVAL('" . $table . "_" . $column . "_seq')"); }