<?php
require_once('DB.php');
$username = "john";
$password = "foobar";
$host = "localhost";
$db_name = "mydb";
$dsn = "mysql://$user:$pass@$host/$db_name";
$db = DB::Connect($dsn);
if(DB::isError($db)) {
die($db->getMessage());
}
$result = $db->query("SELECT * FROM clients");
if(DB::isError($result)) {
die($db->getMessage());
}
/* Fetch as an indexed array... */
$row = $res->fetchRow(DB_FETCHMODE_ORDERED);
/* Fetch as an associative array... */
$row = $res->fetchRow(DB_FETCHMODE_ASSOC);
/* Fetch as an object... */
$row = $res->fetchRow(DB_FETCHMODE_OBJECT);
$result->free();
$db->disconnect();
?>
