Forum und email

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.

Warning

Varoitus! Tämä funktio on EKSPERIMENTAALINEN. Tämän funktion ominaisuudet, käyttäytyminen, parametrit ja nimi voivat muuttua varoituksetta seuraavissa PHP versioissa.

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

Palauttaa TRUE onnistuessaan, muutoin FALSE. Returns string if PGSQL_DML_STRING is passed via options .

Examples

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

See Also