This is a simple example of this function, which returns the name of which PostreSQL Database you are currently connected to.
<?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;
}
?>
This function is extremely useful for sites which connect to multiple Postgresql services.
Regards, --mark
pg_host
(PHP 4, PHP 5, PHP 7)
pg_host — Returns the host name associated with the connection
Descrierea
pg_host
( resource
$connection = ?
) : string
pg_host() returns the host name of the given
PostgreSQL connection resource is
connected to.
Parametri
-
connection -
PostgreSQL database connection resource. When
connectionis not present, the default connection is used. The default connection is the last connection made by pg_connect() or pg_pconnect().
Valorile întoarse
A string containing the name of the host the
connection is to, or false on error.
Exemple
Example #1 pg_host() example
<?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;
}
?>
A se vedea și
- pg_connect() - Open a PostgreSQL connection
- pg_pconnect() - Open a persistent PostgreSQL connection
add a note
User Contributed Notes 1 note
mark at redbrick dot dcu dot ie ¶
21 years ago
