document.write('');
document.write('
<?php');
document.write('
class SimpleDB_Connection
');
document.write('
{');
document.write('
var $conn;
');
document.write('
var $error =
\'No Error\';
');
document.write('
');
document.write('
function SimpleDB_Connection
($hostname =
\'localhost\',
$username =
null,
$password =
null)');
document.write('
{');
document.write('
$this->
conn = @
mysql_connect($hostname,
$username,
$password);
');
document.write('
if (!
$this->
conn) $this->
error =
\'Could not connect to database.\';
');
document.write('
return $this->
conn;
');
document.write('
}');
document.write('
');
document.write('
function query
($sql)');
document.write('
{');
document.write('
if (!
$this->
conn)');
document.write('
{');
document.write('
$this->
error =
\'Not connected to database.\';
');
document.write('
return false;
');
document.write('
}');
document.write('
');
document.write('
$res = @
mysql_query($sql,
$this->
conn);
');
document.write('
if (!
$res)');
document.write('
{');
document.write('
$this->
error =
mysql_error($this->
conn);
');
document.write('
return false;
');
document.write('
}');
document.write('
');
document.write('
return new SimpleDB_Result
($res,
$this->
conn);
');
document.write('
}');
document.write('
');
document.write('
function getError
()');
document.write('
{');
document.write('
return $this->
error;
');
document.write('
}');
document.write('
}');
document.write('
');
document.write('
class SimpleDB_Result
');
document.write('
{');
document.write('
var $conn;
');
document.write('
var $res;
');
document.write('
var $numRows;
');
document.write('
var $numAffected;
');
document.write('
');
document.write('
function SimpleDB_Result
(&
$res, &
$conn)');
document.write('
{');
document.write('
$this->
res =
$res;
');
document.write('
$this->
conn =
$conn;
');
document.write('
}');
document.write('
');
document.write('
function getNext
()');
document.write('
{');
document.write('
$res = @
mysql_fetch_assoc($this->
res);
');
document.write('
return $res;
');
document.write('
}');
document.write('
');
document.write('
function getNumRows
()');
document.write('
{');
document.write('
$res =
($this->
numRows ?
$this->
numRows : @
mysql_num_rows($this->
res));
');
document.write('
return $res;
');
document.write('
}');
document.write('
');
document.write('
function getNumAffected
()');
document.write('
{');
document.write('
$res =
($this->
numAffected ?
$this->
numAffected : @
mysql_affected_rows($this->
conn));
');
document.write('
return $res;
');
document.write('
}');
document.write('
}');
document.write('
');
document.write('
/**
');
document.write(' * EXAMPLES:
');
document.write(' */');
document.write('
');
document.write('
$db =
new SimpleDB_Connection
(\'localhost\',
\'username\',
\'password\');
');
document.write('
$sql =
\'SELECT *
');
document.write(' FROM `users`
');
document.write(' WHERE `userid` < 99\';
');
document.write('
$result =
$db->
query($sql);
');
document.write('
if (!
$result) die($db->
getError());
');
document.write('
if ($result->
getNumRows() ==
0) die(\'No Results\');
');
document.write('
while ($row =
$result->
getNext())');
document.write('
{');
document.write('
echo "{$row[\'username\']}<br />\n";
');
document.write('
}');
document.write('
?>');
document.write('
');