pg_query_params

Function • Return type changed in PHP 8.1

Submits a command to the server and waits for the result, with the ability to pass parameters separately from the SQL command text.

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

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

Parameters

$connection
$query

The parameterized SQL statement. Must contain only a single statement. (multiple statements separated by semi-colons are not allowed.) If any parameters are used, they are referred to as $1, $2, etc.

$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_query_params Function

PHP 8.1

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

PHP 8.0

  • Parameter type added for parameter #3 ($params): array
  • Parameter default value added for position #3 ($params): <default>
  pg_query_params(
      $connection,
      $query,
-     $params
+     array $params = <default>
    )

pg_query_params 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