<?php

class Database {
	private function __construct() {
		$this->dbhost = DB_HOST;
		$this->dbuser = DB_USER;
		$this->dbpass = DB_PASS;
		$this->dbname = DB_NAME;
	}

	public function singleton() {
		if (!isset($this->instance)) {
			$class = __CLASS__;
			$this->instance = new $class;
		}
		return $this->instance;
	}

	private function open() {
		if (!isset($this->connection)) {
			$this->connection = mysql_connect($this->dbhost,$this->dbuser,$this->dbpass);
			mysql_select_db($this->dbname,$this->connection);
		}
	}

	public function query($query) {
		$this->open();
		return mysql_query($query);
	}

	public function arrayFromResource($resource) {
		$rows = array();
		while (($row = mysql_fetch_assoc($resource)) !== false) {
			$rows[] = $row;
		}
		return $rows;
	}

	protected static $instance;
	private $dbhost;
	private $dbuser;
	private $dbpass;
	private $dbname;
	private $connection;
	const DBPREFIX = 'emailbot_';
}

?>