Database Class : connecting to an SSL MySQL server

[eluser]Christophe Sautot[/eluser]
I was also looking to see if CodeIgniter supports connecting to a MySQL database with SSL, and at the moment it seems that it doesn't.

Thank you for posting your code example for the mysqli driver class.

It would be nice if they also modified the database/drivers/mysql/mysql_driver.php class around line 66, to allow for client_flags values such as to be passed in.

For use of client flags with the mysql_connect() PHP function:

http://us2.php.net/manual/en/function.mysql-connect.php

http://www.w3schools.com/PHP/func_mysql_connect.asp

Update:

From what I am reading it seems that SSL support with PHP's mysql_connect() function is really weak. If you can, you are better off using mysqli with either mysqli->ssl_set() or previous post's mysqli_ssl_set().