PHPのお勉強！

PHP TOP
PHP 8.4.2 Released!

    pg_connection_status

    (PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)

    pg_connection_status — 接続ステータスを取得する

    説明

    pg_connection_status(PgSql\Connection $connection): int

    pg_connection_status() は、 connection で指定した接続のステータスを返します。

    パラメータ

    connection

    PgSql\Connection クラスのインスタンス。

    戻り値

    PGSQL_CONNECTION_OK あるいは PGSQL_CONNECTION_BAD 。

    変更履歴

    バージョン 説明
    8.1.0 connection は、PgSql\Connection クラスのインスタンスを期待するようになりました。 これより前のバージョンでは、リソース を期待していました。

    例

    例1 pg_connection_status() の例

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

    参考

    Found A Problem?

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes 4 notes

    up
    6
    Mathieu De Zutter
    18 years ago
    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
    up
    2
    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.
    up
    2
    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';
    ?>
    up
    -1
    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
    ＋add a note