error_reporting(E_ALL);
$DOC_ROOT = $_SERVER['DOCUMENT_ROOT'];
$USER_DIR = '/martin';
$PROJECT_NAME = '/hem';
$APP_ROOT = $DOC_ROOT . $USER_DIR . $PROJECT_NAME;
$PEAR_DIR = $APP_ROOT . '/pear';
$APP_FRAMEWORK_DIR = $APP_ROOT . '/framework';
$APP_FRAMEWORK_CLASSES_DIR = $APP_FRAMEWORK_DIR . '/classes';
$PATH = $PEAR_DIR . $APP_FRAMEWORK_DIR . $APP_FRAMEWORK_CLASSES_DIR;
ini_set(' include_path', ':' . $PATH . ':' . ini_get('include_path'));
require_once 'DB.php';
require_once 'class.DBI.php';
$DB_URL = 'mysql://*****:*****@localhost/test';
$dbi = new DBI($DB_URL);
echo "DBI Version " . $dbi->apiVersion() . " loaded <br/>";
if (!$dbi->isConnected()) {
echo "Connection failed for {$DB_URL}: " . $dbi->getError() . "<br/>";
exit;
}
$statement = "SELECT ID, text FROM test";
$result = $dbi->query($statement);
if ($result == NULL) {
echo "Database error: " . $dbi->getError() . "<br/>";
} else {
if (!$result->numRows()) {
echo "Database error: No rows found<br/>";
} else {
echo "<pre>ID\text<br/>";
while ($row = $result->fetchRow()) {
echo $row->ID . "\t" . $row->text . "<br/>";
}
