This is the README for the class.MySQL.php class that I no longer support as the mysql_* functions are deprecated.

This is a simple to use MySQL class that easily bolts on to any existing PHP application, streamlining your MySQL interactions.

I have refactored the entire class, and improved the code somewhat. This means that some things now work differently to the original version.

Simply include this class into your project like so:

include_once('/path/to/class.MySQL.php');

Then invoke the class in your project using the class constructor (which now sets the db credentials):

$oMySQL = new MySQL(MYSQL_NAME, MYSQL_USER, MYSQL_PASS, [MYSQL_HOST]);

MYSQL_NAME The name of your database

MYSQL_USER Your username for the server / database

MYSQL_PASS Your password for the server / database

MYSQL_HOST The hostname of the MySQL server (optional, defaults to 'localhost')

To use this class, you'd first init the object like so (using example credentials):

$oMySQL = new MySQL('my_database','username','password');

Provided you see no errors, you are now connected and can execute full MySQL queries using:

$oMySQL->ExecuteSQL($query);

ExecuteSQL() will return an array of results, or a true (if an UPDATE or DELETE).

There are other functions such as Insert(), Delete() and Select() which may or may not help with your queries to the database.

To show you how easy this class is to use, consider you have a table called admin, which contains the following:

To add a user, you'd simply use: