<?php
class Database
{
    private $db_server = "localhost";
    private $db_user = "root";
    private $db_pass = "root";
    private $db_name = "vuurwerk";
    private $aResult = array();

    public function connect()
    {
        if(mysql_connect($this->db_server, $this->db_user, $this->db_pass))
        {
            if(mysql_select_db($this->db_name))
            {
                echo "Connected";
            }
        }
        else
        {
            echo "Couldn't connect";
        }
    }

    public function select($query)
    {
        $result = mysql_query($query);
        if($result)
        {
            for($i = 0; $i < mysql_num_rows($result); $i++)
            {
                $row = mysql_fetch_assoc($result);
                $aResult[$i] = $row;
            }
            echo "Query executed";
            return $aResult;
        }
        else
        {
            echo "Couldn't execute query";
        }
    }

    public function disconnect()
    {
        if(mysql_close())
        {
            echo "Disconnected";
        }
        else
        {
            echo "Couldn't disconnect";
        }
    }
}