Differences

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

--- v5:reference:connection:setconnectionparameter [2021/03/10 11:50] – Document need to use predefined constants for mysqli and add example dregad
+++ v5:reference:connection:setconnectionparameter [2022/07/12 00:32] – [Oracle] mnewnham
@@ Line 14: / Line 14: @@
 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.
+===== 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.
-===== Usage =====
 <code php>
-/*
- * Connecting to a MySQL database
- */
 $db = ADONewConnection('mysqli');
 $db->setConnectionParameter(MYSQLI_SET_CHARSET_NAME, 'utf8mb4');
 $db->connect('hostname', 'user', 'password', 'database');
+</code>
+==== Firebird ====
+//$parameterName// must be a string containing one of the 3 following values:
+  * role
+  * dialect
+  * buffers
+<code php>
+$db = ADONewConnection('firebird');
+$db->setConnectionParameter('dialect',2);
+$db->connect($database,$user,$password);
+</code>
+==== 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''
+<code php>
+$db = ADONewConnection('oci8');
+$db->setConnectionParameter('session_mode',OCI_SYSDBA);
+$db->connect($database,$user,$password);
+</code>
+=== client_identifier ===
+(ADOdb >= 5.21.3)
+Sets the [[https://www.php.net/manual/en/function.oci-set-client-identifier.php|Oracle Client Identifier]].
+<code php>
+$db = ADONewConnection('oci8');
+$db->setConnectionParameter('client_identifier',$_SESSION['username']);
+$db->connect($database,$user,$password);
+</code>
+===== Other Usage =====
+<code php>
 /*