PHP ��U
前一頁 |  | 下一頁

# pg_update

(PHP 4 >= 4.3.0, PHP 5)

pg_update -- Update table

## Description

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

pg_update() updates records that matches condition with data. If options is specified, pg_convert() is applied to data with specified options.

警告
�o�Ө�ƬO����ʽ��C�o�Ө�ƪ�欰�B�W�١B�M����ƪ����L���b��PHP�o�椤�i��|�b�q�p�U���ܡC �ϥΦ��ݦۦ�Ӿ᭷�I�C

## Parameters

connection

  PostgreSQL database connection resource.

table_name

  Name of the table into which to update rows.

data

  An array whose keys are field names in the table table_name, and whose values are what matched rows are to be updated to.

condition

  An array whose keys are field names in the table table_name, and whose values are the conditions that a row must meet to be updated.

options

  Any number of `PGSQL_CONV_OPTS`, `PGSQL_DML_NO_CONV`, `PGSQL_DML_EXEC` or `PGSQL_DML_STRING` combined. If `PGSQL_DML_STRING` is part of the options then query string is returned.

## Return Values

�\�^��`TRUE`�Ѧ^��`FALSE`�C Returns string if `PGSQL_DML_STRING` is passed via options.

## �d��

範例 1. pg_update() example

`<?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"; } ?>`

## �Ѧ�

pg_convert()

前一頁 | 內容 | 下一頁
pg_untrace | 上一層 | pg_version