pg_send_prepare

Function • Params changed in PHP 8.1

Sends a request to create a prepared statement with the given parameters, without waiting for completion.

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

pg_send_prepare(
    PgSql\Connection $connection,
    string $statement_name,
    string $query
  ): int|bool

Parameters

$connection

TypePgSql\Connection

$statement_name

Typestring

The name to give the prepared statement. Must be unique per-connection. If "" is specified, then an unnamed statement is created, overwriting any previously defined unnamed statement.

$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.

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_prepare Function

PHP 8.1

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

PHP 8.0

  • Return type added: int|bool
  • Parameter name of parameter #2 changed: $stmtname to $statement_name
  • Parameter type added for parameter #2 ($statement_name): string
  • Parameter type added for parameter #3 ($query): string
  pg_send_prepare(
      $connection,
-     $stmtname,
+     string $statement_name,
-     $query
+     string $query
-   )
+   ): int|bool

pg_send_prepare 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