Podręcznik PHP
Poprzedni |  | Następny

# oci_pconnect

(PHP 5)

oci_pconnect -- Connect to an Oracle database using a persistent connection

## Opis

resource oci_pconnect ( string username, string password [, string db [, string charset [, int session_mode]]] )

Creates a persistent connection to an Oracle server and logs on.

Persistent connections are cached and re-used between requests, resulting in reduced overhead on each page load; a typical PHP application will have a single persistent connection open against an Oracle server per Apache child process (or PHP FastCGI/CGI process). See the Persistent Database Connections section for more information.

## Parametry

`username`

  The Oracle user name.

`password`

  The password for `username`.

`db`

  This optional parameter can either contain the name of the local Oracle instance or the name of the entry in `tnsnames.ora`.

  If the not specified, PHP uses environment variables `ORACLE_SID` and `TWO_TASK` to determine the name of local Oracle instance and location of `tnsnames.ora` accordingly.

`charset`

  Używając serwera Oracle w wersji 9.2 lub nowszej można podać parametr `charset`, który zostanie użyty przy nowym połączeniu. Używając serwera Oracle < 9.2 ten parametr zostanie zignorowany, a zamiast niego użyta zostanie zmienna środowiskowa NLS_LANG.

`session_mode`

  This parameter is available since version 1.1 and accepts the following values: `OCI_DEFAULT`, `OCI_SYSOPER` and `OCI_SYSDBA`. If either `OCI_SYSOPER` or `OCI_SYSDBA` were specified, this function will try to establish privileged connection using external credentials. Privileged connections are disabled by default. To enable them you need to set oci8.privileged_connect to `On`.

## Zwracane wartości

Returns a connection identifier or `FALSE` on error.

## Notatki

> Notatka: Starting with version 1.1 of the oci8 extension, the lifetime and maximum amount of persistent Oracle connections can be tuned by setting the following configuration values: oci8.persistent_timeout, oci8.ping_interval and oci8.max_persistent.

> Notatka: If you're using PHP with Oracle Instant Client, you can use easy connect naming method described here: http://download-west.oracle.com/docs/cd/B12037_01/network.101/b10775/naming.htm#i498306. Basically this means you can specify "//db_host[:port]/database_name" as database name. But if you want to use the old way of naming you must set either `ORACLE_HOME` or `TNS_ADMIN`.

> Notatka: In PHP versions before 5.0.0 you must use ociplogon() instead. This name still can be used, it was left as alias of oci_pconnect() for downwards compatability. This, however, is deprecated and not recommended.

## Patrz także

oci_connect()
oci_new_connect()

Poprzedni | Spis treści | Następny
oci_password_change | Początek rozdziału | oci_result