pg_update

(PHP 4 >= 4.3.0, PHP 5)

pg_update --  更新表

说明

mixed pg_update ( resource connection, string table_name, array data, array condition [, int options] )

pg_update()condition 作为条件查询数据库,用 data 中的数据更新符合条件的记录。如果指定了 options,则 pg_convert() 会按照指定选项作用到 data 上。

例子 1. pg_update

<?php
    $db
= pg_connect ('dbname=foo');
    
$data = array('field1'=>'AA', 'field2'=>'BB');
    
// This is safe, since $_POST is converted automatically
    
$res = pg_update($db, 'post_log', $_POST, $data);
    if (
$res) {
        echo
"Data is updated: $res\n";
    }
    else {
        echo
"User must have sent wrong inputs\n";
    }
?>

警告

本函数是实验性的。本函数的行为,包括函数名称以及其它任何关于本函数的文档可能会在没有通知的情况下随 PHP 以后的发布而改变。使用本函数风险自担。

参见 pg_convert()


add a note add a note User Contributed Notes
jhooks
13-Apr-2006 10:54
> Return Values
>
> Returns TRUE on success or FALSE on failure. Returns string if
> PGSQL_DML_STRING is passed via options.

I have found in my copy of PHP (version 4.4.0) that if you use the 'PGSQL_DML_STRING' option, the function does not execute any query.  It merely returns the query which would have been executed. 

Another thing I noticed, pg_update does not seem to make use of pg_trace (atleast in 4.4.0).

PS this isn't a bug report, just an explanation of some undocumented features I noticed.  As the manual says, the function is still in development so this behaviour may differ from version to version.
sdibb at myway dot com
14-Jun-2005 10:26
This function is similar to PEAR::DB's autoExecute() function, with the only difference being that the where clause is an array instead of a string.

Also, if you want to use your instance of the DB class with this function, you can reference the existing resource connection with $db->connection.

An example would be:
<?
     pg_update
($db->connection, $arr_update, $arr_where);
?>