pg_connection

说明

int pg_connection_status ( resource connection )

pg_connection_status() 返回一个连接的状态。可能的状态为 PGSQL_CONNECTION_OK 和 PGSQL_CONNECTION_BAD。

例子 1. pg_connection_status() 例子
<?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); $stat = pg_connection_status($dbconn); echo 'connection_status: '.$stat; ?>

例子 2. pg_connection_status() 例子
<?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); $stat = pg_connection_status($dbconn); echo 'connection_status: '.$stat; ?>

参见 pg_connection_busy()。

add a note User Contributed Notes

Mathieu De Zutter
02-Aug-2006 08:45


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

david dot tulloh at infaze dot com dot au
15-Jun-2005 11:33


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';

?>

zytox at hotmail dot com
03-Apr-2005 02:34


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.

add a note