PostgreSQL 函数
在线手册：中文 英文
PHP手册

pg_close

(PHP 4, PHP 5)

pg_close — 关闭一个 PostgreSQL 连接

说明

bool pg_close ( resource $connection )

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

Note:

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

Example #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 资源之前不要关闭连接。

参数

connection

PostgreSQL database connection resource. When connection is not present, the default connection is used. The default connection is the last connection made by pg_connect() or pg_pconnect().

返回值

成功时返回 TRUE， 或者在失败时返回 FALSE.

范例

Example #2 pg_close() example

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

以上例程会输出：

Connected successfully

参见

PostgreSQL 函数
在线手册：中文 英文
PHP手册
PHP手册 - N: 关闭一个 PostgreSQL 连接

用户评论:

nox at macports dot org (27-Jul-2007 09:02)

An E_WARNING level warning is generated if the supplied argument is not a valid postgresql link resource.

amays (15-Nov-2005 11: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 02: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