(PHP 4, PHP 5, PHP 7, PHP 8)
pg_close — Finaliza una conexión PostgreSQL
pg_close() cierra la conexión al servidor PostgreSQL
asociada a connection.
Nota:
No es generalmente necesario cerrar una conexión no persistente, ya que estas son cerradas automáticamente al final de un script.
Si existen instancias de PgSql\Lob que han sido abiertas con esta conexión, no se debe cerrar la conexión antes de haber cerrado todas las instancias de PgSql\Lob.
connectionAn PgSql\Connection instance.
When connection is null, the default connection is used.
The default connection is the last connection made by pg_connect()
or pg_pconnect().
As of PHP 8.1.0, using the default connection is deprecated.
Siempre devuelve true.
| Versión | Descripción |
|---|---|
| 8.2.0 |
The return type is true now; previously, it was bool.
|
| 8.1.0 |
The connection parameter expects an PgSql\Connection
instance now; previously, a recurso was expected.
|
| 8.0.0 |
connection ahora es nullable.
|
Ejemplo #1 Ejemplo con pg_close()
<?php
$dbconn = pg_connect("host=localhost port=5432 dbname=marie")
or die("Conexión imposible");
echo 'Conexión exitosa';
pg_close($dbconn);
?>El resultado del ejemplo sería:
Conexión exitosa
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.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