pg_prepare

Function • Return type changed in PHP 8.1

Submits a request to the server to create a prepared statement with the given parameters, and waits 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_prepare Function synopsis

pg_prepare(
    $connection,
    string $statement_name,
    string $query = <default>
  ): PgSql\Result|false

Parameters

$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

OptionalTypestringDefault value

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

TypePgSql\Result|false

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

Changes to the pg_prepare Function

PHP 8.1

  • Return type added: PgSql\Result|false
  pg_prepare(
      $connection,
      string $statement_name,
      string $query = <default>
-   )
+   ): PgSql\Result|false

PHP 8.0

  • 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
  • Parameter default value added for position #3 ($query): <default>
  pg_prepare(
      $connection,
-     $stmtname,
+     string $statement_name,
-     $query
+     string $query = <default>
    )

pg_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