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');