MySQL Database Abstraction 2.0

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.

This class 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...
}

?>