This is an old revision of the document!

setConnectionParameter

Syntax

From ADOdb Version 5.21.0

void setConnectionParameter(
    string $parameterName,
    mixed $parameterValue
    )

Description

The function setConnectionParameter() permits the setting of parameters before a database connection is established. This allows the specified parameters to be passed to the connect statement.

If used in a portable environment, parameters set in this manner should be predicated on the database provider, as unexpected results may occur if applied to the wrong database.

Database Specific Values

MySQL

$parameterName must be one of the predefined constants defined in PHP documentation for the mysqli_options() function.

$db = ADONewConnection('mysqli');
$db->setConnectionParameter(MYSQLI_SET_CHARSET_NAME, 'utf8mb4');
$db->connect('hostname', 'user', 'password', 'database');

Firebird

$parameterName must be a string containing one of the 3 following values:

role
dialect
buffers

$db = ADONewConnection('firebird');
$db->setConnectionParameter('dialect',2);
$db->connect($database,$user,$password);

Oracle

$parameterName must be one of the following

session_mode

Sets the Oracle Session Mode. The default value is OCI_DEFAULT. Other values are:

OCI_CRED_EXT
OCI_SYSOPER
OCI_SYSDBA

$db = ADONewConnection('oci8');
$db->setConnectionParameter('session_mode',OCI_SYSDBA);
$db->connect($database,$user,$password);

client_identifier

Sets the Oracle Client Identifier

$db = ADONewConnection('oci8');
$db->setConnectionParameter('client_identifier',$_SESSION['username']);
$db->connect($database,$user,$password);

Other Usage

 
/*
 * Connecting to DB2 Database
 */
$db->setConnectionParameter('autocommit',DB2_AUTOCOMMIT_ON);
$db->connect('database','user','password');
 
/*
 * Connecting to a SQL Server database
 */
$db->setConnectionParameter('CharacterSet','UTF-8');
$db->connect('database','user','password');