MySQL OOP Database Script

May 28, 2008 | 2 comments | 3 Pages | Developed by David Rosthorn

Introduction

Monday, June 30, 2008 : UPDATED TO VERSION 1.05 Stable - from VERSION 1.02

This MySQL OOP Database connection class was submitted by David Rosthorn and it makes MySQL queries more manageable by breaking down the key functions and features of the MySQL module found in all standard PHP installations and creates an environment that is a little faster to work with.

Notes from David Rosthorn regarding the Monday, June 30, 2008 Update to version 1.05:

rather than just setting a blank string as "nothing" in the DB, it literally sets it as NULL like it should. The only catch is that you HAVE to make sure you set up the tables to allow nulls in the appropriate fields where nulls might occur so you can do a proper SQL query:
SELECT * FROM table WHERE field IS NULL AND field2 IS NOT NULL

Usage Examples

Note: As of version 1.05 you may now initiate multiple database instances with seperate database crudentials. For example if you needed to connect to 2 completley different databases from your script you would do so by initiating multiple instances of the class, you would then use the new function "setup_db()" to load the new crudentials.

To initiate the class with new values for database connection add the following above all possible MySQL queries.

include("mysql_db.php"); $dbobject = new MySQL_DB; $dbobject->setup_db('host','user','password','database');

To initiate the class with the default values located in the script it self add the following above all possible MySQL queries.

include ("mysql_db.php"); $dbobject = new MySQL_DB;

To initiate more than one database connection you would do something like the example below, of course tailored to your needs.

include("mysql_db.php"); // Connection 1 $dbobject1 = new MySQL_DB; $dbobject1->setup_db('newhost','newuser','newpassword','newdb'); // Connection 2 - Default connection values $dbobject2 = new MySQL_DB; // Connection 3 $dbobject3 = new MySQL_DB; $dbobject3->setup_db('newhost','newuser','newpassword','newdb');

SELECT() example

the select function allows you to make a SELECT * FROM query from your database.

$sql = "SELECT * FROM table"; foreach ($dbobject->select($sql) AS $row) { // do stuff }

INSERT() example

The insert function allows you to make an INSERT INTO query on your database.

$data = array ('fieldname' => $value, 'fieldname2' => $value2); $result = dbobject->insert('tablename',$data); // $result does the mysql_insert_id() thing basically

UPDATE() example

The update function allows you to make an UPDATE `table` query on your database.

$data = array ('fieldname' => $value, 'fieldname2' => $value2); $conditions = "WHERE id=5"; $dbobject->update('tablename',$data,$conditions);

DELETE() example

The delete function lets your make a DELETE FROM query on your database.

$conditions = "id=5"; $dbobject->delete('tablename',$conditions);

COUNT() example

The count function works like the mysql_num_rows() function but its method is shortened down a bit.

$sql = "SELECT * FROM tablename"); $num_rows = $dbobject->count($sql);

· Credit: Developed by David Rosthorn - Click here to visit the website.

· Keywords: mysql, oop, database, tutorial

2 Comments have been made on this post: