[wp-trac] [WordPress Trac] #21663: Use PDO for MySQL queries when PDO is available

[WordPress Trac]

#21663: Use PDO for MySQL queries when PDO is available
-------------------------------------------------+-------------------------
 Reporter:  scottconnerly                        |       Owner:
     Type:  task (blessed)                       |      Status:  new
 Priority:  normal                               |   Milestone:  Future
Component:  Database                             |  Release
 Severity:  normal                               |     Version:  3.5
 Keywords:  dev-feedback has-patch needs-        |  Resolution:
  testing                                        |
-------------------------------------------------+-------------------------

Comment (by hypertextranch):

 Looks like PHP const `MYSQLI_OPT_SSL_VERIFY_SERVER_CERT` for mysqli will
 set the MySQL option `MYSQL_OPT_SSL_VERIFY_SERVER_CERT`
 (http://docs.oracle.com/cd/E17952_01/refman-5.5-en/mysql-options.html)
 which turns on SSL cert verification. However it appears that the PHP
 constant is only defined if mysqli is compiled with mysql client 5.1.10+
 or with mysqlnd (https://github.com/php/php-
 src/blob/master/ext/mysqli/mysqli.c#L699).

 I guess the question is do we turn SSL cert verification on if available
 across the board or do we make it configurable? (If we make it
 configurable I'm guessing we should make it on by default?) In either case
 we should wrap that set options in a if defined block so mysqli compiled
 without verify support does not throw PHP notices.

--
Ticket URL: <http://core.trac.wordpress.org/ticket/21663#comment:99>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software