PHP pg_getlastoid函数代码示例

 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')");
 }