PHP Handbuch
Zurück |  | Weiter

# db2_pconnect

(PECL)

db2_pconnect -- Returns a persistent connection to a database

## Beschreibung

resource db2_pconnect ( string database, string username, string password [, array options] )

Returns a persistent connection to an IBM DB2 Universal Database, IBM Cloudscape, or Apache Derby database. For more information on persistent connections, refer to Kapitel 41.

Calling db2_close() on a persistent connection always returns `TRUE`, but the underlying DB2 client connection remains open and waiting to serve the next matching db2_pconnect() request.

## Parameter Liste

`database`

  The database alias in the DB2 client catalog.

`username`

  The username with which you are connecting to the database.

`password`

  The password with which you are connecting to the database.

`options`

  An associative array of connection options that affect the behavior of the connection, where valid array keys include:

  `autocommit`

    Passing the `DB2_AUTOCOMMIT_ON` value turns autocommit on for this connection handle.

    Passing the `DB2_AUTOCOMMIT_OFF` value turns autocommit off for this connection handle.

  `DB2_ATTR_CASE`

    Passing the `DB2_CASE_NATURAL` value specifies that column names are returned in natural case.

    Passing the `DB2_CASE_LOWER` value specifies that column names are returned in lower case.

    Passing the `DB2_CASE_UPPER` value specifies that column names are returned in upper case.

  `CURSOR`

    Passing the `DB2_FORWARD_ONLY` value specifies a forward-only cursor for a statement resource. This is the default cursor type and is supported on all database servers.

    Passing the `DB2_SCROLLABLE` value specifies a scrollable cursor for a statement resource. This mode enables random access to rows in a result set, but currently is supported only by IBM DB2 Universal Database.

## Rückgabewerte

Returns a connection handle resource if the connection attempt is successful. db2_pconnect() tries to reuse an existing connection resource that exactly matches the `database`, `username`, and `password` parameters. If the connection attempt fails, db2_pconnect() returns `FALSE`.

## Beispiele

Beispiel 1. A db2_pconnect() example In the following example, the first call to db2_pconnect() returns a new persistent connection resource. The second call to db2_pconnect() returns a persistent connection resource that simply reuses the first persistent connection resource.
`<?php $database = 'SAMPLE'; $user = 'db2inst1'; $password = 'ibmdb2'; $pconn = db2_pconnect($database, $user, $password); if ($pconn) { echo "Persistent connection succeeded."; } else { echo "Persistent connection failed."; } $pconn2 = db2_pconnect($database, $user, $password); if ($pconn) { echo "Second persistent connection succeeded."; } else { echo "Second persistent connection failed."; } ?>`
Das oben gezeigte Beispiel erzeugt folgende Ausgabe:
    Persistent connection succeeded.
    Second persistent connection succeeded.

## Siehe auch

db2_connect()

Zurück | Zum Anfang | Weiter
db2_num_rows | Nach oben | db2_prepare