(PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)
pg_connection_status — Get connection status
pg_connection_status() returns the status of
the specified connection.
| Version | Description |
|---|---|
| 8.1.0 |
The connection parameter expects an PgSql\Connection
instance now; previously, a resource was expected.
|
Example #1 pg_connection_status() example
<?php
$dbconn = pg_connect("dbname=publisher") or die("Could not connect");
$stat = pg_connection_status($dbconn);
if ($stat === PGSQL_CONNECTION_OK) {
echo 'Connection status ok';
} else {
echo 'Connection status bad';
}
?>Being careful with the comparison operators is not enough:<?phpif (pg_connection_status($link)===PGSQL_CONNECTION_BAD) reconnect($link);?> The reconnect won't be trigged when $link is null.The manual is just wrong, there are three return values: PGSQL_CONNECTION_OK, PGSQL_CONNECTION_BAD, nullIf the connection variable is NULL this function returns 0 in PHP 5.0.2. Havent figured out any more erratic values for the connection variable but be careful.The wiki page doesn't currently reflect that, but if you're passing PGSQL_CONNECT_ASYNC to pg_connect, creating the connection won't block and transitions through extra states expressed by those constants.PGSQL_CONNECTION_AUTH_OKPGSQL_CONNECTION_AWAITING_RESPONSEPGSQL_CONNECTION_MADEPGSQL_CONNECTION_SETENVPGSQL_CONNECTION_SSL_STARTUPPGSQL_CONNECTION_STARTEDI think zytox is incorrect, at least in PHP 5.0.4.It returns null, but you have to be careful with your comparison operators.As an example:<?phpunset($null);if (pg_connection_status($null)===PGSQL_CONNECTION_OK) echo 'this is not called';if (pg_connection_status($null)==PGSQL_CONNECTION_OK) echo 'this is called because NULL==0 is true';?>