(PHP 4 >= 4.3.0, PHP 5, PHP 7, PHP 8)
pg_update — Update table
$connection
,$table_name
,$values
,$conditions
,$flags
= PGSQL_DML_EXEC
pg_update() updates records that matches conditions
with values
.
If flags
is specified, pg_convert() is applied to values
with the specified flags.
By default pg_update() passes raw values. Values must be escaped or the PGSQL_DML_ESCAPE
flag must be specified in flags
. PGSQL_DML_ESCAPE
quotes and escapes parameters/identifiers. Therefore, table/column names become case sensitive.
Note that neither escape nor prepared query can protect LIKE query, JSON, Array, Regex, etc. These parameters should be handled according to their contexts. i.e. Escape/validate values.
connection
Uma instância de PgSql\Connection.
table_name
Name of the table into which to update rows.
values
An array whose keys are field names in the table table_name
, and whose values are what matched rows are to be updated to.
conditions
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.
flags
Any number of PGSQL_CONV_FORCE_NULL
, PGSQL_DML_NO_CONV
, PGSQL_DML_ESCAPE
, PGSQL_DML_EXEC
, PGSQL_DML_ASYNC
or PGSQL_DML_STRING
combined. If PGSQL_DML_STRING
is part of the flags
then query string is returned. When PGSQL_DML_NO_CONV
or PGSQL_DML_ESCAPE
is set, it does not call pg_convert() internally.
Retorna true
em caso de sucesso ou false
em caso de falha. Returns string if PGSQL_DML_STRING
is passed via flags
.
Versão | Descrição |
---|---|
8.1.0 | O parâmetro connection agora espera uma instância de PgSql\Connection; anteriormente, um resource era esperado. |
Exemplo #1 pg_update() example
<?php
$db = pg_connect('dbname=foo');
$data = array('field1'=>'AA', 'field2'=>'BB');
// This is safe somewhat, since all values are escaped.