Below is a description on how to use the classes in the below script
include 'zdb.php';
//setup db variables
define("DB_HOST", "127.8.221.129");
define("DB_USER", "danferth");
define("DB_PASS", "");
define("DB_NAME", "c9");
$database = new db();
$database->query('INSERT INTO test (name, age, description) VALUES(:name, :age, :description)');
$database->bind(':name', 'Melissa');
$database->bind(':age', '39');
$database->bind(':description', 'the real boss');
$database->execute();
$database->beginTransaction();
$database->query('INSERT INTO test (name, age, description) VALUES (:name, :age, :description)');
$database->bind(':name','Sam');
$database->bind(':age','34');
$database->bind(':description','The Boss');
$database->execute();
$database->bind(':name','Karen');
$database->bind(':age','48');
$database->bind(':description','Administration');
$database->execute();
$database->endTransaction();
$database->query("SELECT name, age, description FROM test WHERE name = :name");
$database->bind(':name','dan');
$row = $database->single();
echo '<pre>';
print_r($row);
echo '</pre>';
$database->query('SELECT * FROM test');
$row = $database->resultset();
echo '<pre>';
print_r($row);
echo '</pre>';
echo $database->rowCount();
change