pg_update

Function • Params changed in PHP 8.1

Update table.

PHP 5
PHP 7
PHP 8.0
Improved
PHP 8.1
Improved
PHP 8.2-8.3
PHP 8.4
PHP 8.5
PHP 8.6

pg_update Function synopsis

pg_update(
    PgSql\Connection $connection,
    string $table_name,
    array $values,
    array $conditions,
    int $flags = PGSQL_DML_EXEC
  ): string|bool

Parameters

$connection

TypePgSql\Connection

$table_name

Typestring

Name of the table into which to update rows.

$values

Typearray

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

Typearray

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

OptionalTypeintDefault valuePGSQL_DML_EXEC

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.

Return value

Typestring|bool

Returns true on success, false on failure Returns string if PGSQL_DML_STRING is passed via $flags.

Changes to the pg_update Function

PHP 8.1

  • Parameter type added for parameter #1 ($connection): PgSql\Connection
  pg_update(
-     $connection,
+     PgSql\Connection $connection,
      string $table_name,
      array $values,
      array $conditions,
      int $flags = PGSQL_DML_EXEC
    ): string|bool

PHP 8.0

  • Return type added: string|bool
  • Parameter name of parameter #1 changed: $db to $connection
  • Parameter name of parameter #2 changed: $table to $table_name
  • Parameter type added for parameter #2 ($table_name): string
  • Parameter name of parameter #3 changed: $fields to $values
  • Parameter type added for parameter #3 ($values): array
  • Parameter name of parameter #4 changed: $ids to $conditions
  • Parameter type added for parameter #4 ($conditions): array
  • Parameter name of parameter #5 changed: $options to $flags
  • Parameter type added for parameter #5 ($flags): int
  • Parameter default value added for position #5 ($flags): PGSQL_DML_EXEC
  pg_update(
-     $db,
+     $connection,
-     $table,
+     string $table_name,
-     $fields,
+     array $values,
-     $ids,
+     array $conditions,
-     $options
+     int $flags = PGSQL_DML_EXEC
-   )
+   ): string|bool

pg_update Function Availability

PHP VersionAvailability
PHP 8.6Upcoming Release Yes
PHP 8.5Supported (Latest) Yes
PHP 8.4Supported Yes
PHP 8.3Security-Fixes Only Yes
PHP 8.2Security-Fixes Only Yes
PHP 8.1Unsupported Yes
PHP 8.0Unsupported Yes
PHP 7.4Unsupported Yes
PHP 7.3Unsupported Yes
PHP 7.2Unsupported Yes
PHP 7.1Unsupported Yes
PHP 7.0Unsupported Yes
PHP 5.6Unsupported Yes
PHP 5.5Unsupported Yes
PHP 5.4Unsupported Yes
PHP 5.3Unsupported Yes