Review my DB class

TlcAndres · 01-13-2008, 05:46 PM

I wrote a class to handle multiple databases (it currently handles mysql, mssql, sqlite) and I'd like your opinion on what can be done to improve it and such, it's very simplistic as far as database abstraction classes go.

Some examples of it's use

PHP Code:


			


<?



$db = new DB_handle('/home/users/www/scripts/','mysql','root','','test');



//returns a record class

$row = $db->Execute('select * from `table`');

echo $row->fields['name'];



//returns the very first result

echo $db->GetOne('select * from `table`');



//returns the very first row

$row = $db->GetRow('select * from `table`');

echo $row->fields['name'];

Note -- I also added a secure sql feature called ParseSql()

PHP Code:


			
 

$db = new DB_handle('/home/users/www/scripts/','mysql','root','','test');



$r = $db->ParseSql('select `email` where `id`=\'%b\'',$_GET['id']);



$email = $db->GetOne($r);