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.

Firebird

$parameterName must be one of the 3 following values:

role
dialect
buffers

Usage

/*
 * Connecting to a MySQL database
 */
$db = ADONewConnection('mysqli');
$db->setConnectionParameter(MYSQLI_SET_CHARSET_NAME, 'utf8mb4');
$db->connect('hostname', 'user', 'password', 'database');
 
/*
 * 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');