pg_close

说明

bool pg_close ( resource connection )

pg_close() 关闭由所给资源 connection 指定的到 PostgreSQL 数据库的非持久连接。如果成功则返回 TRUE，失败则返回 FALSE。

注: 使用 pg_close() 并不很必要，因为非持久连接在本脚本执行结束后会自动关闭。

例子 1. pg_close() 例子
<?php $dbconn = pg_connect("host=localhost port=5432 dbname=mary") or die("Could not connect"); print("Connected successfully"); pg_close($dbconn); ?>

如果在此连接中打开了 large object 资源，则在关闭所有 large object 资源之前不要关闭连接。

add a note User Contributed Notes

amays
16-Nov-2005 07:47


pg_close(...) will not technically close a persistent connection but instead returns it back to the connection pool thus giving you the desired effect of having the connection closed within your script.



http://www.sitepoint.com/article/accessing-postgresql-php/3



best wishes to all.

mark at redbrick dot dcu dot ie
24-Mar-2003 10:31


This function closes the current database connection specified by a handle returned from a pg_connect() call.



<?php

    $pgsql_conn = pg_connect("dbname=mark host=localhost");



    if ($pgsql_conn) {

        print "Successfully connected to: " . pg_host($pgsql_conn) . "<br/>\n";

    } else {

        print pg_last_error($pgsql_conn);

        exit;

    }



    // Do database stuff here.



    if(!pg_close($pgsql_conn)) {

        print "Failed to close connection to " . pg_host($pgsql_conn) . ": " .

       pg_last_error($pgsql_conn) . "<br/>\n";

    } else {

        print "Successfully disconnected from database";

    }

?>



Of course you normally wouldn't print a message.  



Regards, --mark

add a note