For an uncataloged connection to a database, database represents a complete connection string in the following format: DRIVER={IBM DB2 ODBC DRIVER};DATABASE=database;HOSTNAME=hostname;PORT=port;PROTOCOL=TCPIP; UID=username;PWD=password; where the parameters represent the following values:

database: The name of the database.
hostname: The hostname or IP address of the database server.
port: The TCP/IP port on which the database is listening for requests.
username: The username with which you are connecting to the database.
password: The password with which you are connecting to the database.

username

The username with which you are connecting to the database.

For uncataloged connections, you must pass a NULL value or empty string.

password

The password with which you are connecting to the database.

For uncataloged connections, you must pass a NULL value or empty string.

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.

Возвращаемые значения

Returns a connection handle resource if the connection attempt is successful. If the connection attempt fails, db2_connect() returns FALSE.

Примеры

Пример 1. Creating a cataloged connection
Cataloged connections require you to have previously cataloged the target database through the DB2 Command Line Processor (CLP) or DB2 Configuration Assistant.
<?php $database = 'SAMPLE'; $user = 'db2inst1'; $password = 'ibmdb2'; $conn = db2_connect($database, $user, $password); if ($conn) {     echo "Connection succeeded.";     db2_close($conn); } else {     echo "Connection failed."; } ?>
Результат выполнения данного примера:
Connection succeeded.

Пример 2. Creating an uncataloged connection
An uncataloged connection enables you to dynamically connect to a database.
<?php $database = 'SAMPLE'; $user = 'db2inst1'; $password = 'ibmdb2'; $hostname = 'localhost'; $port = 50000; $conn_string = "DRIVER={IBM DB2 ODBC DRIVER};DATABASE=$database;" .   "HOSTNAME=$hostname;PORT=$port;PROTOCOL=TCPIP;UID=$user;PWD=$password;"; $conn = db2_connect($conn_string, '', ''); if ($conn) {     echo "Connection succeeded.";     db2_close($conn); } else {     echo "Connection failed."; } ?>
Результат выполнения данного примера:
Connection succeeded.

Пример 3. Creating a connection with autocommit off by default
Passing an array of options to db2_connect() enables you to modify the default behavior of the connection handle.
<?php $database = 'SAMPLE'; $user = 'db2inst1'; $password = 'ibmdb2'; $options = array('autocommit' => DB2_AUTOCOMMIT_OFF); $conn = db2_connect($database, $user, $password, $options); if ($conn) {     echo "Connection succeeded.\n";     if (db2_autocommit($conn)) {          echo "Autocommit is on.\n";     }     else {          echo "Autocommit is off.\n";     }     db2_close($conn); } else {     echo "Connection failed."; } ?>
Результат выполнения данного примера:
Connection succeeded. Autocommit is off.

Смотрите также

db2_close()

db2_pconnect()

Функции по алфавиту

Содержание

Функции по категориям

Есть еще вопросы или что-то непонятно - добро пожаловать на наш форум портала PHP.SU