db2_connect

Returns a connection to a database (PECL ibm_db2:1.0-1.6.2)
resource db2_connect ( string database, string username, string password [, array options] )

Example 920. 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.

copy to clipboard

<?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:

copy to clipboard

Connection succeeded.

Example 921. Creating an uncataloged connection

An uncataloged connection enables you to dynamically connect to a database.

copy to clipboard

<?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:

copy to clipboard

Connection succeeded.

Example 922. 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.

copy to clipboard

<?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:

copy to clipboard

Connection succeeded.

Autocommit is off.

Example 923. i5/OS best performance

To achieve best performance for your i5/OS ibm_db2 1.5.1 PHP application use the default host, userid, and password for your db2_connect().

copy to clipboard

<?php

  $library = "ADC";

  $i5 = db2_connect("", "", "", array("i5_lib"=>"qsys2"));

  $result = db2_exec($i5, 

       "select * from systables where table_schema = '$library'");

  while ($row = db2_fetch_both($result)) {               

     echo $row['TABLE_NAME']."</br>";                     

  }                                                      

  db2_close($i5);
?>

The above example will output:

copy to clipboard

ANIMALS

NAMES

PICTURES

Change Language

db2_autocommit
db2_bind_param
db2_client_info
db2_close
db2_column_privileges
db2_columns
db2_commit
db2_conn_error
db2_conn_errormsg
db2_connect
db2_cursor_type
db2_escape_string
db2_exec
db2_execute
db2_fetch_array
db2_fetch_assoc
db2_fetch_both
db2_fetch_object
db2_fetch_row
db2_field_display_size
db2_field_name
db2_field_num
db2_field_precision
db2_field_scale
db2_field_type
db2_field_width
db2_foreign_keys
db2_free_result
db2_free_stmt
db2_get_option
db2_lob_read
db2_next_result
db2_num_fields
db2_num_rows
db2_pconnect
db2_prepare
db2_primary_keys
db2_procedure_columns
db2_procedures
db2_result
db2_rollback
db2_server_info
db2_set_option
db2_special_columns
db2_statistics
db2_stmt_error
db2_stmt_errormsg
db2_table_privileges
db2_tables

db2_connect

Returns a connection to a database (PECL ibm_db2:1.0-1.6.2) resource db2_connect ( string database, string username, string password [, array options] )

Example 920. Creating a cataloged connection

Example 921. Creating an uncataloged connection

Example 922. Creating a connection with autocommit off by default

Example 923. i5/OS best performance

Change Language

Returns a connection to a database (PECL ibm_db2:1.0-1.6.2)
resource db2_connect ( string database, string username, string password [, array options] )