01-13-2008, 05:46 PM
|
#1 (permalink)
|
|
The Addict
Join Date: Nov 2007
Posts: 264
Thanks: 2
|
Review my DB class
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);
Last edited by TlcAndres : 01-13-2008 at 07:14 PM.
|
|
|
|