ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:mysql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
v5:database:mysql [2023/01/24 21:51] – [Connecting With SSL] mnewnhamv5:database:mysql [2023/05/10 09:41] (current) – [mysqli driver] mysqlnd required since 5.22 dregad
Line 2: Line 2:
 ~~NOTOC~~ ~~NOTOC~~
 ===== mysqli driver ===== ===== mysqli driver =====
 +
 <WRAP right box round 300px> <WRAP right box round 300px>
 +
 == Specification == == Specification ==
 ^Driver Name|mysqli| ^Driver Name|mysqli|
Line 11: Line 13:
 ^ADOdb V5|Yes| ^ADOdb V5|Yes|
 ^ADOdb V6|Yes| ^ADOdb V6|Yes|
 +
 == Alternatives == == Alternatives ==
 [[v5:database:pdo#pdo_mysql|PDO driver for MySQL]] [[v5:database:pdo#pdo_mysql|PDO driver for MySQL]]
 +
 == See Also == == See Also ==
 [[v5:reference:connection:setconnectionparameter#mysql|setConnectionParameter()]] [[v5:reference:connection:setconnectionparameter#mysql|setConnectionParameter()]]
Line 25: Line 29:
  
 It replaces [[v5:database:mysql_legacy|]] (**mysql**, **mysqlt** and **mysqlpo**). It replaces [[v5:database:mysql_legacy|]] (**mysql**, **mysqlt** and **mysqlpo**).
 +
 +<WRAP important>
 +Starting with ADOdb 5.22, the mysqli driver requires the [[https://www.php.net/manual/en/book.mysqlnd.php|MySQL Native Driver (Mysqlnd)]]
 +</WRAP>
 +
  
 ------------------------------------------- -------------------------------------------
Line 79: Line 88:
 $password = 'Qzrt6r55geRt!'; $password = 'Qzrt6r55geRt!';
  
-$db->ssl_key    = null; 
-$db->ssl_cert   = null;  
 $db->ssl_ca     = '/opt/azure-cert/DigiCertGlobalRootCA.crt.pem'; $db->ssl_ca     = '/opt/azure-cert/DigiCertGlobalRootCA.crt.pem';
-$db->ssl_capath = null;  +
-$db->ssl_cipher = null; +
 /* /*
 * Open the connection * Open the connection
v5/database/mysql.1674593468.txt.gz · Last modified: 2023/01/24 21:51 by mnewnham