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.

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.

// Include the class definition file.

// Extend the class with your own database parameters
class DB_Mysql extends DB {
var $host = '';
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...


License type: GPL - GNU Public License
Date added: 7 years, 12 months 2 days ago | Last updated: 7 years, 12 months 2 days ago

More popular Database Tool

This is actually one of the most advanced image hosting script. The imagetize key features: SEO, Ads Ready, Admin

Listing Files

Hot Scripts