<?PHP
//Henry Garle
//2010
class DatabaseConnection {
    var $DatabaseName;
    var $DatabaseUser;
    var $DatabasePassword;
    var $DatabaseHost;
    var $Connection;

        public function __construct($Name="ece70123", $User="ece70123", $Pass="avcq1841", $Host="mysql.ee.port.ac.uk") {
   //public function __construct($Name="boback_battle", $User="boback_battle", $Pass="battle", $Host="localhost") {
        $this->DatabaseName = $Name;
        $this->DatabaseUser = $User;
        $this->DatabasePassword = $Pass;
        $this->DatabaseHost = $Host;
    }

    public function Connect() {
        $this->Connection = mysql_connect($this->DatabaseHost,$this->DatabaseUser,$this->DatabasePassword);
        mysql_select_db($this->DatabaseName, $this->Connection) || die("Couldn't open db: $db_name. Error if any was: ".mysql_error() );
    }

    public function Query($Query)
    {
        $this->Connect();
        $Result = mysql_query($Query) or die("($Query) " . mysql_error());
        mysql_close($this->Connection);
        return $Result;
    }

        public function Insert($Query)
    {
        $this->Connect();
        $Result = mysql_query($Query) or die("($Query) " . mysql_error());
                //echo "The last inserted ID was :" . mysql_insert_id();
                $InsertID = mysql_insert_id();
        mysql_close($this->Connection);
        return $InsertID;
    }
}



?>