Differences

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

--- v5:reference:connection:setconnectionparameter [2022/07/13 03:30] – [IDM DB2] mnewnham
+++ v5:reference:connection:setconnectionparameter [2026/01/30 04:21] (current) – [MySQL] mnewnham
@@ Line 16: / Line 16: @@
 ===== Database Specific Values =====
 ==== 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.
+//$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, or one of the specified ADOdb MySQLi custom connection parameters.
+=== Custom Parameters ===
+^Key^Example Value^Description^
+|socket||A string describing the location of an override socket name on the MySql server|
+|port|3306|An override value for the connection port|
+|clientFlags|MYSQLI_CLIENT_SSL_VERIFY_SERVER_CERT|Any of the allowed clientFlags values|
+|ssl|array('key'=>"key.pem", 'cert'=>"cert.pem", 'ca'=>"cacert.pem", 'capath' => null, 'cipher'=>null)| An array of values that describes an SSL connection to the MySQL Server|
+=== Examples ===
 <code php>
@@ Line 98: / Line 107: @@
 </code>
+==== PDO Driver ====
+Any parameter from the PHP [[https://www.php.net/manual/en/pdo.setattribute|PDO Attribute List]]
+<code php>
+/*
+ * Example Setting Timeout Duration
+ */
+$db->setConnectionParameter(PDO::ATTR_TIMEOUT,60);
+$db->connect(mysql:$dsn,'user','password');
+</code>