Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
112 lines (86 sloc) 2.16 KB

To utilize this class, first import Mysqldbi.php into your project, and require it.


require_once('Mysqlidb.php');

After that, create a new instance of the class.


$db = new Mysqlidb('host', 'username', 'password', 'databaseName');

Next, prepare your data, and call the necessary methods.

Insert Query


$insertData = array( 'title' => 'Inserted title', 'body' => 'Inserted body' );

if ( $db->insert('posts', $insertData) ) echo 'success!';

Select Query


$results = $db->get('tableName', 'numberOfRows-optional');
print_r($results); // contains array of returned rows

Update Query


$updateData = array(
	'fieldOne' => 'fieldValue',
	'fieldTwo' => 'fieldValue'
);
$db->where('id', int);
$results = $db->update('tableName', $updateData);

Delete Query


$db->where('id', int);
if ( $db->delete('posts') ) echo 'successfully deleted'; 

Generic Query Method


$results = $db->query('SELECT * from posts');
print_r($results); // contains array of returned rows

Raw Query Method


$params = array(3, 'My Title');
$resutls = $db->rawQuery("SELECT id, title, body FROM posts WHERE id = ? AND tile = ?", $params);
print_r($results); // contains array of returned rows

// will handle any SQL query

$params = array(10, 1, 10, 11, 2, 10);
$resutls = $db->rawQuery("
(SELECT a FROM t1 WHERE a = ? AND B = ? ORDER BY a LIMIT ?)
UNION
(SELECT a FROM t2 WHERE a = ? AND B = ? ORDER BY a LIMIT ?)
", $params);
print_r($results); // contains array of returned rows

Where Method

This method allows you to specify the parameters of the query.


$db->where('id', int);
$db->where('title', string);
$results = $db->get('tableName');
print_r($results); // contains array of returned rows

Optionally you can use method chaining to call where multiple times without referancing your object over an over: $results = $db ->where('id', 1) ->where('title', 'MyTitle') ->get('tableName');