| |
db2_connect (no version information, might be only in CVS) db2_connect --
Returns a connection to a database
Descriptionresource db2_connect ( string database, string username, string password [, array options] ) | Warning | This function is
EXPERIMENTAL. The behaviour of this function, the
name of this function, and anything else documented about this
function may change without notice in a future release of PHP.
Use this function at your own risk. |
Creates a new connection to an IBM DB2 Universal Database, IBM Cloudscape,
or Apache Derby database.
Parameters
- database
For a cataloged connection to a database, database
represents the database alias in the DB2 client catalog.
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.
Return Values
Returns a connection handle resource if the connection attempt is
successful. If the connection attempt fails, db2_connect()
returns FALSE.
Examples
Example 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.";
}
?>
|
The above example will output: |
Example 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.";
}
?>
|
The above example will output: |
Example 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.";
}
?>
|
The above example will output: Connection succeeded.
Autocommit is off. |
|
Copyright © 1997 - 2007 by the PHP Documentation Group. This material may be distributed only subject to the terms and conditions set forth in the Open Publication License, v1.0 or later. A copy of the Open Publication License is distributed with this manual, the latest version is presently available at http://www.opencontent.org/openpub/.
Please see full copyright text at http://www.php.net/manual/en/copyright.php
Original version of the above documentation is available at http://www.php.net/manual/en/
|
- Please click on Another perl meta searching mysql script
- Please Also click on our Web developers Showcase
|
