pg_send_query_params

Function • Params changed in PHP 8.1

Submits a command and separate parameters to the server without waiting for the result(s).

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

pg_send_query_params(
    PgSql\Connection $connection,
    string $query,
    array $params
  ): int|bool

Parameters

$connection

TypePgSql\Connection

$query

Typestring

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

Typearray

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

Typeint|bool

Returns true on success, false or 0 on failure. Use pg_get_result to determine the query result.

Changes to the pg_send_query_params Function

PHP 8.1

  • Parameter type added for parameter #1 ($connection): PgSql\Connection
  pg_send_query_params(
-     $connection,
+     PgSql\Connection $connection,
      string $query,
      array $params
    ): int|bool

PHP 8.0

  • Return type added: int|bool
  • Parameter type added for parameter #2 ($query): string
  • Parameter type added for parameter #3 ($params): array
  pg_send_query_params(
      $connection,
-     $query,
+     string $query,
-     $params
+     array $params
-   )
+   ): int|bool

pg_send_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