(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
PostgreSQL veritabanı bağlantısı özkaynağı.
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.
Başarı durumunda true
, başarısızlık durumunda false
döner. Returns string if PGSQL_DML_STRING
is passed via flags
.
Sürüm: | Açıklama |
---|---|
8.1.0 | bağlantı bağımsız değişkeni artık PgSql\Connection nesnesi kabul ediyor, evvelce bir özkaynak kabul ederdi. |
Örnek 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.