<?php
class database {
    public function open() {}
    public function close() {}
    // these methods return result objects
    public function select() {}
    public function update() {}
}

class result {
    public function row() {}
    public function all() {}
    public function count() {}
    public function free() {}
}

// connection example
$masta = database::open('localhost', 'user', 'pass', 'masta');
$slave = database::open('localhost', 'user', 'pass', 'slave');

// select example
$res = $slave->select("SELECT * FROM users WHERE username=? AND email=? AND password=? LIMIT 1", $username, $email, $password);
if ($res->count()) {
    $user = $res->row();
    echo "Username = {$user['username']}";
}

// select with multiple results example
$res = $slave->select("SELECT * FROM users WHERE status='active' LIMIT 10", $username, $email, $password);
while ($row = $res->row()) {
    echo "Username = {$row['username']}";
}

// update examples
$res = $masta->update("UPDATE users SET password=? AND email=? WHERE username=?", $password, $email, $username);
if ($res->count()) {
    echo "Record updated!";
}
$res = $masta->update("DELETE FROM users WHERE username=? AND email=? LIMIT 1", $username, $email);
if ($res->count()) {
    echo "Record deleted!";
}

// cleanup
$res->free();
$masta->close();
$slave->close();
?>