Differences

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

--- v5:database:mysql [2020/01/13 13:31] – Move deprecated legacy drivers to separate page dregad
+++ v5:database:mysql [2023/05/10 09:41] – [mysqli driver] mysqlnd required since 5.22 dregad
@@ Line 2: / Line 2: @@
 ~~NOTOC~~
 ===== mysqli driver =====
 <WRAP right box round 300px>
 == Specification ==
 ^Driver Name|mysqli|
-^Data Provider|mysql|
+^Data Provider|[[v5:userguide:learn_extensions:new_driver#Understanding The Data Provider|mysql]]|
 ^Status|Active((This driver is actively supported by ADOdb project members))|
 ^Windows|Yes|
@@ Line 11: / Line 13: @@
 ^ADOdb V5|Yes|
 ^ADOdb V6|Yes|
 == Alternatives ==
 [[v5:database:pdo#pdo_mysql|PDO driver for MySQL]]
+== See Also ==
+[[v5:reference:connection:setconnectionparameter#mysql|setConnectionParameter()]]
 </WRAP>
@@ Line 23: / Line 29: @@
 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 65: / Line 76: @@
 </code>
+==== Connecting To A Microsoft Azure MySQL Instance ====
+<code php>
+/*
+* Enable ADOdb
+*/
+$db = newAdoConnection('mysqli')
+$database = 'employees';
+$host     = 'my-corporation.mysql.database.azure.com';
+$user     = 'corpuser';
+$password = 'Qzrt6r55geRt!';
+$db->ssl_ca     = '/opt/azure-cert/DigiCertGlobalRootCA.crt.pem';
+/*
+* Open the connection
+*/
+$db->connect($host, $user, $password, $database);
+</code>
 {{tag>[MySQL windows unix supported tier1]}}
 {{htmlmetatags>metatag-keywords=(php, programming, database, mysql, percona, mariadb)}}