Merge pull request #1 from gcsolaroli/master

First version of the restructured repository

1 files changed, 79 insertions, 0 deletions

diff --git a/backend/php/src/objects/class.database.php b/backend/php/src/objects/class.database.php
new file mode 100644
index 0000000..e8a13f7
--- a/dev/null
+++ b/backend/php/src/objects/class.database.php
@@ -0,0 +1,79 @@
+<?php
+/**
+* <b>Database Connection</b> class.
+* @author Php Object Generator
+* @version 3.0d / PHP5.1
+* @see http://www.phpobjectgenerator.com/
+* @copyright Free for personal & commercial use. (Offered under the BSD license)
+*/
+ Class Database
+{
+	public $connection;
+
+	private function Database()
+	{
+		$databaseName = $GLOBALS['configuration']['db'];
+		$serverName = $GLOBALS['configuration']['host'];
+		$databaseUser = $GLOBALS['configuration']['user'];
+		$databasePassword = $GLOBALS['configuration']['pass'];
+		$databasePort = $GLOBALS['configuration']['port'];
+		$this->connection = mysql_connect ($serverName.":".$databasePort, $databaseUser, $databasePassword);
+		if ($this->connection)
+		{
+			if (!mysql_select_db ($databaseName))
+			{
+				throw new Exception('I cannot find the specified database "'.$databaseName.'". Please edit configuration.php.');
+			}
+		}
+		else
+		{
+			throw new Exception('I cannot connect to the database. Please edit configuration.php with your database configuration.');
+		}
+	}
+
+	public static function Connect()
+	{
+		static $database = null;
+		if (!isset($database))
+		{
+			$database = new Database();
+		}
+		return $database->connection;
+	}
+
+	public static function Reader($query, $connection)
+	{
+		$cursor = mysql_query($query, $connection);
+		return $cursor;
+	}
+
+	public static function Read($cursor)
+	{
+		return mysql_fetch_assoc($cursor);
+	}
+
+	public static function NonQuery($query, $connection)
+	{
+		mysql_query($query, $connection);
+		$result = mysql_affected_rows($connection);
+		if ($result == -1)
+		{
+			return false;
+		}
+		return $result;
+
+	}
+
+	public static function Query($query, $connection)
+	{
+		$result = mysql_query($query, $connection);
+		return mysql_num_rows($result);
+	}
+
+	public static function InsertOrUpdate($query, $connection)
+	{
+		$result = mysql_query($query, $connection);
+		return intval(mysql_insert_id($connection));
+	}
+}
+?>