php man page for pg_pconnect

Query: pg_pconnect

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

PG_PCONNECT(3)															    PG_PCONNECT(3)

pg_pconnect - Open a persistent PostgreSQL connection

SYNOPSIS
resource pg_pconnect (string $connection_string, [int $connect_type])
DESCRIPTION
pg_pconnect(3) opens a connection to a PostgreSQL database. It returns a connection resource that is needed by other PostgreSQL functions. If a second call is made to pg_pconnect(3) with the same $connection_string as an existing connection, the existing connection will be returned unless you pass PGSQL_CONNECT_FORCE_NEW as $connect_type. To enable persistent connection, the pgsql.allow_persistent php.ini directive must be set to "On" (which is the default). The maximum num- ber of persistent connection can be defined with the pgsql.max_persistent php.ini directive (defaults to -1 for no limit). The total number of connections can be set with the pgsql.max_links php.ini directive. pg_close(3) will not close persistent links generated by pg_pconnect(3).
PARAMETERS
o $connection_string - The $connection_string can be empty to use all default parameters, or it can contain one or more parameter settings separated by whitespace. Each parameter setting is in the form keyword = value. Spaces around the equal sign are optional. To write an empty value or a value containing spaces, surround it with single quotes, e.g., keyword = 'a value'. Single quotes and backslashes within the value must be escaped with a backslash, i.e., ' and \. The currently recognized parameter keywords are: $host, $hostaddr, $port, $dbname, $user, $password, $connect_timeout, $options, $tty (ignored), $sslmode, $requiressl (deprecated in favor of $sslmode), and $service. Which of these arguments exist depends on your PostgreSQL version. o $connect_type - If PGSQL_CONNECT_FORCE_NEW is passed, then a new connection is created, even if the $connection_string is identical to an exist- ing connection.
RETURN VALUES
PostgreSQL connection resource on success, FALSE on failure.
EXAMPLES
Example #1 Using pg_pconnect(3) <?php $dbconn = pg_pconnect("dbname=mary"); //connect to a database named "mary" $dbconn2 = pg_pconnect("host=localhost port=5432 dbname=mary"); // connect to a database named "mary" on "localhost" at port "5432" $dbconn3 = pg_pconnect("host=sheep port=5432 dbname=mary user=lamb password=foo"); //connect to a database named "mary" on the host "sheep" with a username and password $conn_string = "host=sheep port=5432 dbname=test user=lamb password=bar"; $dbconn4 = pg_pconnect($conn_string); //connect to a database named "test" on the host "sheep" with a username and password ?>
SEE ALSO
pg_connect(3), Persistent Database Connections. PHP Documentation Group PG_PCONNECT(3)
Related Man Pages
pg_last_notice(3) - php
pg_pconnect(3) - php
pg_query(3) - php
pg_query_params(3) - php
pg_send_prepare(3) - php
Similar Topics in the Unix Linux Community
To remove the extra spaces in unix
Improving Performance Through Persistent Connections
Grep multiple lines and redirect to file
Mysql is not connected in php