Web студия "GrandView"

Описание

bool pg_close ( [resource connection] )

pg_close() closes the non-persistent connection to a PostgreSQL database associated with the given connection resource.

Замечание: Using pg_close() is not usually necessary, as non-persistent open connections are automatically closed at the end of the script.

If there is open large object resource on the connection, do not close the connection before closing all large object resources.

Список параметров

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().

Примеры

Пример 1. 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

add a note User Contributed Notes
pg_close

nox at macports dot org
27-Jul-2007 01:02


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

amays
15-Nov-2005 03: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 06: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

pg_close

Описание

Список параметров

Возвращаемые значения

Примеры

Смотрите также