Publisher review:This PHP class provides an abstraction layer for MySQL. 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 parametersclass 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...}
?>
MySQL Database Abstraction 2.0 is a PHP script for PHP Classes scripts design by Jon Abernathy.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
Operating system:Windows / Linux / Mac OS / BSD / Solaris