ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
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
Next revisionBoth sides next revision
v5:database:mysql [2020/01/15 03:38] – [mysqli driver] mnewnhamv5:database:mysql [2023/01/24 21:51] – [Connecting With SSL] mnewnham
Line 13: Line 13:
 == Alternatives == == Alternatives ==
 [[v5:database:pdo#pdo_mysql|PDO driver for MySQL]] [[v5:database:pdo#pdo_mysql|PDO driver for MySQL]]
 +== See Also ==
 +[[v5:reference:connection:setconnectionparameter#mysql|setConnectionParameter()]]
 </WRAP> </WRAP>
  
Line 65: Line 67:
 </code> </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_key    = null;
 +$db->ssl_cert   = null; 
 +$db->ssl_ca     = '/opt/azure-cert/DigiCertGlobalRootCA.crt.pem';
 +$db->ssl_capath = null; 
 +$db->ssl_cipher = null; 
 +/*
 +* Open the connection
 +*/
 +$db->connect($host, $user, $password, $database);
 +</code>
  
 {{tag>[MySQL windows unix supported tier1]}} {{tag>[MySQL windows unix supported tier1]}}
 {{htmlmetatags>metatag-keywords=(php, programming, database, mysql, percona, mariadb)}} {{htmlmetatags>metatag-keywords=(php, programming, database, mysql, percona, mariadb)}}
v5/database/mysql.txt · Last modified: 2023/05/10 09:41 by dregad