This PHP class provides an abstraction layer for MySQL. The main purpose is to encapsulate and simplify the details of connecting to a MySQL database and performing queries.

MySQL Database Abstraction is for MySQL only is designed for a single database; to use it, extend the class in your code, with the given database/user/password you will connect to.

Usage:
// Include the class definition file.
require_once('class.db.inc');

// Extend the class with your own database parameters
class DB_Mysql extends DB {
var $host = 'host.db.com';
var $database = 'dbname';
var $user = 'username';
var $password = 'password';
}

// Instantiate the class
$db =& new DB_Mysql;

// Run a SQL query
$db->query('SELECT * FROM table');

// Iterate through the result set (if any)
while ( $db->next_record() ) {
// Retrieve the value for a particular field in the current row
$field = $db->f('field');
// etc...
}

?>