pg_execute

Function • Return type changed in PHP 8.1

Sends a request to execute a prepared statement with given parameters, and waits for the result.

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_execute Function synopsis

pg_execute(
    $connection,
    $statement_name,
    array $params = <default>
  ): PgSql\Result|false

Parameters

$connection
$statement_name

The name of the prepared statement to execute. if "" is specified, then the unnamed statement is executed. The name must have been previously prepared using pg_prepare, pg_send_prepare or a PREPARE SQL command.

$params

OptionalTypearrayDefault value

An array of parameter values to substitute for the $1, $2, etc. placeholders in the original prepared query string. The number of elements in the array must match the number of placeholders.

Return value

TypePgSql\Result|false

An PgSql\Result instance on success, or false on failure.

Changes to the pg_execute Function

PHP 8.1

  • Return type added: PgSql\Result|false
  pg_execute(
      $connection,
      $statement_name,
      array $params = <default>
-   )
+   ): PgSql\Result|false

PHP 8.0

  • Parameter name of parameter #2 changed: $stmtname to $statement_name
  • Parameter type added for parameter #3 ($params): array
  • Parameter default value added for position #3 ($params): <default>
  pg_execute(
      $connection,
-     $stmtname,
+     $statement_name,
-     $params
+     array $params = <default>
    )

pg_execute 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