<?php
interface Connection_Interface
{
  public function __construct($hostname, $username, $pass, $database, $table, $connector);
  public function openConnect();
  public function pingServer();
  public function closeConnect();
  public function startQuery($runQuery);
  public function getResults();
}

class databaseConnectMySql extends databaseConfig implements Connection_Interface
{
    /**
     * declareren van alle functies
     */
    public $hostname;
    public $username;
    public $pass;
    public $database;
    public $table;
    public $connector;

    public function __construct($hostname, $username, $pass, $database, $table, $connector)
    {

    }

    public function __destruct()
    {
        #destroy function
    }

    // open connectie
    public function openConnect()
    {
        try
        {
                $this->openConnect = mysql_connect($this->hostname, $this->username, $this->pass);
                $this->databaseConnect = mysql_select_db($this->database);
        }
        catch (Exception $e)
        {
            return $e;
        }

    }

    #run een query
    public function startQuery($runQuery)
    {
        try
        {
            if(empty($this->openConnect))
            {
                $this->openConnect();

                    $this->startQuery = mysql_query($query);

                $this->closeConnect();
                return $this->startQuery;
            }
            else
            {

                    $this->startQuery = mysql_query($query);

                return $this->startQuery;
            }
        }
        catch (Exception $e)
        {
            return $e;
        }
    }

    #sluit connectie
    public function closeConnect()
    {
        try {
                mysql_close($this->openConnect);
        }
        catch (Exception $e)
        {
            return $e;
        }
    }

    /*
    * ping server om te zien of deze open verbinding heeft.
    */
    public function pingServer()
    {
        # code...
        try
        {

                if(!mysql_ping($this->openConnect))
                {
                    return false;
                }
                else
                {
                    return true;
                }

        }
        catch (Exception $e)
        {
            return $e;
        }
    }

    public function getResults()
    {
        try
        {
                return mysql_fetch_assoc($result);
        }
        catch (Exception $e)
        {
            return $e;
        }
    }
}

abstract class databaseConfig
{
    private $hostname;
    private $username;
    private $pass;
    private $database;
    private $table;
    private $connector;

    function __construct($hostname = NULL, $username = NULL, $pass = NULL, $database = NULL, $prefix = NULL, $connector = NULL)
    {
        $this->hostname = !empty($hostname) ? $hostname : "";
        $this->username = !empty($username) ? $username : "";
        $this->pass = !empty($pass) ? $pass : "";
        $this->database = !empty($database) ? $database : "";
        $this->table = !empty($table) ? $table : "";
        $this->connector = !empty($connector) ? $connector : "";  //mysql of mysqli waarde opgeven (database)
    }

    function __destruct()
    {
        #destruction!
    }
}
?>