function DAO()
{
- if (!isset($this->db))
+ if (!isset(DAO::$db))
{
- $this->db = @mysql_connect(DB_HOST . ':' . DB_PORT, DB_USER, DB_PASSWORD);
- if (!$this->db) {
+ DAO::$db = @mysql_connect(DB_HOST . ':' . DB_PORT, DB_USER, DB_PASSWORD);
+ if (!DAO::$db) {
die('Unable to connect to db.');
}
- if (!@mysql_select_db(DB_NAME, $this->db)) {
+ if (!@mysql_select_db(DB_NAME, DAO::$db)) {
die('DB connection established, but database "'.DB_NAME.'" cannot be selected.');
}
}
function execute($sql)
{
$sql = trim($sql);
- $result = mysql_query($sql, $this->db) or die($sql . "<br />". mysql_error());
+ $result = mysql_query($sql, DAO::$db) or die($sql . "<br />". mysql_error());
// for 'select' SQL, return retrieved rows
if (strtolower(substr($sql, 0, 6)) == 'select')
}
}
-?>
\ No newline at end of file
+?>