Being careful with the comparison operators is not enough:
<?php
if (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, null
pg_connection_status
(PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)
pg_connection_status — Lit le statut de la connexion PostgreSQL
Description
pg_connection_status() retourne le statut de la
connexion connection.
Valeurs de retour
PGSQL_CONNECTION_OK ou
PGSQL_CONNECTION_BAD.
Historique
| Version | Description |
|---|---|
| 8.1.0 |
Le paramètre connection attend désormais une instance de
PgSql\Connection ; auparavant, une ressource était attendu.
|
Exemples
Exemple #1 Exemple avec pg_connection_status()
<?php
$dbconn = pg_connect("dbname=publisher") or die("Connexion impossible");
$stat = pg_connection_status($dbconn);
if ($stat === PGSQL_CONNECTION_OK) {
echo 'Connexion ok';
} else {
echo 'Connexion erronée';
}
?>
add a note
User Contributed Notes 4 notes
Mathieu De Zutter ¶
18 years ago
zytox at hotmail dot com ¶
19 years ago
If 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.
Anonymous ¶
6 years ago
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_OK
PGSQL_CONNECTION_AWAITING_RESPONSE
PGSQL_CONNECTION_MADE
PGSQL_CONNECTION_SETENV
PGSQL_CONNECTION_SSL_STARTUP
PGSQL_CONNECTION_STARTED
david dot tulloh at infaze dot com dot au ¶
19 years ago
I 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:
<?php
unset($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';
?>
