How to use MySQLi?

MySQLi is an improved driver to connect to MySQL databases. Unfortunately, not many software solutions out there take advantage it But we at Yclas do.

The MySQLi extension provides various benefits with respect to its predecessor, the most prominent of which (according to the PHP website), are:

• An object-oriented interface
• Support for prepared statements
• Support for multiple statements
• Support for transactions
• Enhanced debugging support
• Embedded server support
• Powerful Functionality

If you installed with Yclas Self Hosted 2.1.4 or higher you are already using MySQLi. There is nothing to do here - you are already using it.

If you updated at least to 2.1.4 you can start using this new driver. It’s recommended since the old driver is deprecated and soon (I hope) will be removed.

How To Switch to MySQLi?

1. Be sure you use at least 2.1.4.
2. Open the file /oc/config/database.php with your favorite editor.
3. Search for the word ‘ mysql ‘.
4. Replace it for ‘ mysqli ‘.
5. Save the file.

As you can see it’s pretty simple and absolutely transparent to all of you.

This guide is only for Yclas Self-hosted

PS: Thanks to it Kohana module was done easily.