Differences

This shows you the differences between two versions of the page.

--- v5:reference:setconnectionparameter [2016/01/13 02:31] – ↷ Page moved from reference:setconnectionparameter to v5:reference:setconnectionparameter mnewnham
+++ v5:reference:connection:setconnectionparameter [2021/03/10 11:50] – Document need to use predefined constants for mysqli and add example dregad
@@ Line 3: / Line 3: @@
 <WRAP right box>
 == Syntax ==
-  From ADOdb Version 5.21.0
+From ADOdb Version 5.21.0
   void setConnectionParameter(
       string $parameterName,
@@ Line 13: / Line 12: @@
 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
+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.
+On MySQL, //$parameterName// must be one of the [[https://www.php.net/manual/en/mysqli.options.php|predefined constants]] defined in PHP documentation for the //mysqli_options()// function.
 ===== Usage =====
 <code php>
 /*
- * Connecting to DB2 Database
+ * 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
+ * Connecting to a SQL Server database
-*/
+ */
 $db->setConnectionParameter('CharacterSet','UTF-8');
 $db->connect('database','user','password');
 </code>