PHP.nl

pg_connect

pg_connect

Open a PostgreSQL connection

 **pg_connect** string $connection_string int $flags

opens a connection to a

PostgreSQL database specified by the . pg_connect``connection_string

If a second call is made to with the same as an existing connection, the existing connection will be returned unless you pass as . pg_connect``connection_string``PGSQL_CONNECT_FORCE_NEW``flags

The old syntax with multiple parameters has been deprecated.

connection_string The 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 . Spaces around the equal sign are optional. To write an empty value or a value containing spaces, surround it with single quotes, e.g., . Single quotes and backslashes within the value must be escaped with a backslash, i.e., ' and \.
connection_string``keyword = value``keyword = 'a value'

   The currently recognized parameter keywords are:
   , , ,
    (defaults to value of ),
   ,
   , ,
   ,  (ignored), ,
    (deprecated in favor of ), and
   .  Which of these arguments exist depends
   on your PostgreSQL version.
  `host``hostaddr``port``dbname``user``user``password``connect_timeout``options``tty``sslmode``requiressl``sslmode``service`


   The  parameter can be used to set command line parameters 
   to be invoked by the server.
  `options`

flags If is passed, then a new connection is created, even if the is identical to an existing connection. PGSQL_CONNECT_FORCE_NEW``connection_string

   If  is given, then the
   connection is established asynchronously. The state of the connection
   can then be checked via  or
   .
  `PGSQL_CONNECT_ASYNC``pg_connect_poll``pg_connection_status`

Returns an instance on success, return.falseforfailure. PgSql\Connection

**Voorbeeld: Using **

<?php
$dbconn = pg_connect("dbname=mary");
//connect to a database named "mary"

$dbconn2 = pg_connect("host=localhost port=5432 dbname=mary");
// connect to a database named "mary" on "localhost" at port "5432"

$dbconn3 = pg_connect("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_connect($conn_string);
//connect to a database named "test" on the host "sheep" with a username and password

$dbconn5 = pg_connect("host=localhost options='--client_encoding=UTF8'");
//connect to a database on "localhost" and set the command line parameter which tells the encoding is in UTF-8
?>

pg_pconnect``pg_close``pg_host``pg_port``pg_tty``pg_options``pg_dbname

Vorige ← pg_connect_poll Volgende pg_connection_busy →

Documentatie