<?php
include_once('MySQL.Config.php');

class ConnectionFactory
{

    //attributes LOCAL
    public static $server;
    public static $database;
    public static $user;
    public static $pass;
    public static $connection;

    public static $environment = 'HTML';

    public function CreateConnection()
    {
        try
        {
            $config = new Config();
            $config->Set(self::$environment);

            self::$server = $config->server;
            self::$user = $config->user;
            self::$pass = $config->pass;
            self::$database = $config->database;
            self::$connection = mysql_connect(self::$server, self::$user,self::$pass);
            self::SetDataBase(self::$connection);
            self::ExecuteSelect("SET NAMES 'utf8' COLLATE 'utf8_bin'");
        }
        catch(Exception $err)
        {
            echo("Connection error: " . mysql_error());
            return null;
        }

    }

    public function SetDataBase($connection)
    {
        mysql_select_db(self::$database, $connection);
    }

    public function traceQuery($var){
        global $debugarQuery;
        if ($debugarQuery){
            echo "<pre>";
            print_r("
--------------------------------------------------
".$var."
--------------------------------------------------
");
        echo "</pre>";
        }
    }

    public function ExecuteSelect($query)
    {
        self::CreateConnection();
        self::traceQuery($query);
        $result = mysql_query($query);
        self::DisposeConnection();
        return $result;
    }

    public function ExecuteInsert($query)
    {
        self::CreateConnection();
        self::traceQuery($query);
        mysql_query($query);
        $result = mysql_insert_id(self::$connection);
        self::DisposeConnection();
        return $result;
    }

    public function ExecuteAffected($query)
    {
        self::CreateConnection();
        self::traceQuery($query);
        mysql_query($query);
        $result = mysql_affected_rows(self::$connection);
        self::DisposeConnection();
        return $result;
    }

    public function DisposeConnection()
    {
        mysql_close(self::$connection);
    }
}