Keskustelu: Koodit: PHP: Tietokannan hallinta, olio PHP5

<?php

class Db {

	// Declare variables
	private $connections = array();		// Current open connections
	private $connID = false;			// Current connection ID

	/**
	 * Init class
	 */
	 public function __construct() {

	}

	/**
	 * Close connections when closing class
	 */
	 public function __destruct() {
		if($this->connections):
			$max = count($this->connections);
			$counter = 1;
			reset($this->connections);

			while($counter <= $max):
				$key = key($this->connections);

				$this->closeConnection($this->connections[$key]['connID']);

				$counter ++;
			endwhile;
		endif;
	}

	/**
	 * Execute query
	 */
	 public function getResult($server, $username, $password, $db, $query) {
		// Open DB connection
		$this->openConnection($server, $username, $password);

		// Select DB
		$this->selectDb($db);

		// Execute query
		return mysql_query($query, $this->connID);
	}


	/**
	 * Open DB connection
	 *
	 * @param string $server
	 * @param string $server
	 * @param string $server
	 * @return resource
	 */
	 private function openConnection($server, $username, $password) {
		if($server && ctype_alnum($username)):
			if($this->connectionHandler($server, $username)):
				return $this->connID;
			else:
				$this->connID = mysql_connect($server, $username, $password, true);
			endif;
		endif;

		return false;
	}

	/**
	 * Select DB
	 *
	 * @param string $name
	 * @param resource $connID
	 * @return boolean
	 */
	 private function selectDb($name = false) {
		if($name && is_resource($this->connID)):
			return mysql_select_db($name, $this->connID);
		endif;

		return false;
	}

	/**
	 * Close connection
	 */
	 private function closeConnection($connID) {
		return mysql_close($connID);
	}

	/**
	 * Connection handler
	 *
	 * @param string $server
	 * @param string $username;
	 */
	 private function connectionHandler($server, $username) {
		if($this->connections):
			$max = count($this->connections);
			$counter = 1;
			reset($this->connections);

			while($counter <= $max):
				$key = key($this->connections);

				if($this->connections[$key]['server'] == $server && $this->connections[$key]['username'] == $username):
					$this->connID = $this->connections[$key]['connID'];
					return true;
				endif;

				$counter ++;
			endwhile;
		endif;

		return false;
	}

	/**
	 * Save new handler
	 */
	 private function saveHandler($server, $username, $connID) {
		$this->connections[] = array('server'=>$server, 'username'=>$username, 'connID'=>$connID);
	}
}

?>