ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:reference:connection:setconnectionparameter

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
v5:reference:connection:setconnectionparameter [2022/03/24 17:42] – mnewnhamv5:reference:connection:setconnectionparameter [2022/03/24 17:51] – mnewnham
Line 17: Line 17:
 ==== MySQL ==== ==== 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.
 +<code php>
 +
 +$db = ADONewConnection('mysqli');
 +$db->setConnectionParameter(MYSQLI_SET_CHARSET_NAME, 'utf8mb4');
 +$db->connect('hostname', 'user', 'password', 'database');
 +</code>
 ==== Firebird ==== ==== Firebird ====
-//$parameterName// must be one of the 3 following values:+//$parameterName// must be a string containing one of the 3 following values:
   * role   * role
   * dialect   * dialect
   * buffers   * buffers
 +
 +<code php>
 +$db = ADONewConnection('firebird');
 +$db->setConnectionParameter('dialect',2);
 +$db->connect($database,$user,$password);
 +</code>
 +
 ==== Oracle ==== ==== Oracle ====
-//$parameterName// may be one of the following+//$parameterName// must be one of the following
 === session_mode === === session_mode ===
 Sets the Oracle Session Mode. The default value is ''OCI_DEFAULT''. Other values are: Sets the Oracle Session Mode. The default value is ''OCI_DEFAULT''. Other values are:
Line 30: Line 43:
   * ''OCI_SYSDBA''   * ''OCI_SYSDBA''
 <code php> <code php>
 +$db = ADONewConnection('oci8');
 $db->setConnectionParameter('session_mode',OCI_SYSDBA); $db->setConnectionParameter('session_mode',OCI_SYSDBA);
 $db->connect($database,$user,$password); $db->connect($database,$user,$password);
Line 38: Line 52:
  
  
-===== Usage =====+===== Other Usage =====
 <code php> <code php>
-/* +
- * Connecting to a MySQL database +
- */ +
-$db = ADONewConnection('mysqli'); +
-$db->setConnectionParameter(MYSQLI_SET_CHARSET_NAME, 'utf8mb4'); +
-$db->connect('hostname', 'user', 'password', 'database');+
  
 /* /*
v5/reference/connection/setconnectionparameter.txt · Last modified: 2022/07/13 03:47 by mnewnham