PHP : Function Reference : IBM DB2, Cloudscape and Apache Derby Functions : db2_get

Example 944. Setting and retrieving parameters through a connection resource

<?php
/* Database Connection Parameters */
$database = 'SAMPLE';
$user     = 'db2inst1';
$password = 'ibmdb2';

/* Obtain Connection Resource */
$conn = db2_connect($database, $user, $password);


echo "Client attributes passed through conection string:\n";

/* Create the associative options array with valid key-value pairs */

/* Assign the attributes through connection string */

/* Access the options specified */
$options1 = array('userid' => 'db2inst1');
$conn1 = db2_connect($database, $user, $password, $options1);
$val = db2_get_option($conn1, 'userid');

echo $val . "\n";

$options2 = array('acctstr' => 'account');
$conn2 = db2_connect($database, $user, $password, $options2);
$val = db2_get_option($conn2, 'acctstr');

echo $val . "\n";

$options3 = array('applname' => 'myapp');
$conn3 = db2_connect($database, $user, $password, $options3);
$val = db2_get_option($conn3, 'applname');

echo $val . "\n";

$options4 = array('wrkstnname' => 'workstation');
$conn4 = db2_connect($database, $user, $password, $options4);
$val = db2_get_option($conn4, 'wrkstnname');

echo $val . "\n";


echo "Client attributes passed post-conection:\n";

/* Create the associative options array with valid key-value pairs */

/* Assign the attributes after a connection is made */

/* Access the options specified */
$options5 = array('userid' => 'db2inst1');
$conn5 = db2_connect($database, $user, $password);
$rc = db2_set_option($conn5, $options5, 1);
$val = db2_get_option($conn5, 'userid');

echo $val . "\n";

$options6 = array('acctstr' => 'account');
$conn6 = db2_connect($database, $user, $password);
$rc = db2_set_option($conn6, $options6, 1);
$val = db2_get_option($conn6, 'acctstr');

echo $val . "\n";

$options7 = array('applname' => 'myapp');
$conn7 = db2_connect($database, $user, $password);
$rc = db2_set_option($conn7, $options7, 1);
$val = db2_get_option($conn7, 'applname');

echo $val . "\n";

$options8 = array('wrkstnname' => 'workstation');
$conn8 = db2_connect($database, $user, $password);
$rc = db2_set_option($conn8, $options8, 1);
$val = db2_get_option($conn8, 'wrkstnname');

echo $val . "\n";
?>

The above example will output:

copy to clipboard

Client attributes passed through conection string:

db2inst1

account

myapp

workstation

Client attributes passed post-connection:

db2inst1

account

myapp

workstation

db2_get_option

Retrieves an option value for a statement resource or a connection resource (PECL ibm_db2:1.6.0-1.6.2)
string db2_get_option ( resource resource, string option )

Example 944. Setting and retrieving parameters through a connection resource

Change Language

db2_get_option

Retrieves an option value for a statement resource or a connection resource (PECL ibm_db2:1.6.0-1.6.2) string db2_get_option ( resource resource, string option )

Example 944. Setting and retrieving parameters through a connection resource

Change Language

Retrieves an option value for a statement resource or a connection resource (PECL ibm_db2:1.6.0-1.6.2)
string db2_get_option ( resource resource, string option )