class MySQL_naama {
		var $host_name = '';
		var $user_name = '';
		var $password = '';
		var $db_name = '';
		var $conn_id = 0; //Not actually a variable but an object or something
		var $errstr = '';
		var $halt_on_error = 1;
		var $query_pieces = array();
		var $result_id = 0;
		var $num_rows = 0;
		var $row = array();
		function connect() {
			$this->errno  = 0; #Tyhjää virhemuuttuja
			$this->errstr = '';
			if ( $this->conn_id == 0 ) // Yhdistä tietokantaan, jollei ole jo yhteydessä
			{
				try {
                    $this->conn_id = new PDO( 
                        "mysql:host=" . $this->host_name . 
                        ";dbname=" . $this->db_name . 
                        ";charset=utf8" .
                        "", $this->user_name, 
                        $this->password );
					//Persistent connections for faster db application 
				}
				catch ( PDOException $e ) {
					$this->error( $e->getMessage() );
				}
				return ( $this->conn_id );
			}
		}
		function disconnect() {
			if ( $this->conn_id != 0 ) {
				$this->conn_id = null;
			}
		}
		function error( $msg ) {
			if ( !$this->halt_on_error )
				return;
			$msg .= "\n";
			$this->errstr = $msg;
			echo "X1: VIRHE!" . $this->errstr . "</br>";
			// die (nl2br (htmlspecialchars ($msg)) );
			die();
		}
    }


	class Testi extends MySQL_naama {
		var $host_name = '';
		var $user_name = '';
		var $password = '';
		var $db_name = '';
		function __construct( $pwd ) {
			// Rakentaja. 
			$this->set_database( $pwd );
		}
		function set_database( $pwd ) {
			// Haetaan kone/ leinolamsa.org vai localhost
			$url = "http://" . $_SERVER[ 'HTTP_HOST' ] . $_SERVER[ 'REQUEST_URI' ];
			//echo $url;
			if ( strlen( strstr( $url, "luntti" ) ) > 0 )
			{
				$this->host_name = 'mysql.address.';
				$this->user_name = 'userName';
				$this->password  = $pwd; 
				$this->db_name   = 'dbName';
			}
			elseif ( strlen( strstr( $url, "localhost" ) ) > 0 )
			{
				$this->host_name = 'localhost';
				$this->user_name = 'potato';
				$this->password  = 'potato'; //$pwd;
                                $this->db_name   = 'potato';
				//echo "LOCALHOST"; 
			}
		}
        





    function getData(){
            if (empty($this->conn_id))
                $this->connect();
            try {
                $sql = $this->conn_id->prepare("
                    SELECT * FROM data ORDER BY time DESC LIMIT 100");

                $sql->setFetchMode(PDO::FETCH_INTO, new data);
                $sql->execute(); 
                if ($sql -> rowCount() < 2){
                    $result = $sql -> fetchAll();
                } else{
                    while ($object = $sql->fetch()) {
                        $result[] = clone $object;
                   }  
                }
                }
                catch (PDOException $e) {
                    $this->error($e->getMessage());
                }
                return $result;

            }
            
            
  function getImages(){
            if (empty($this->conn_id))
                $this->connect();
            try {
                $sql = $this->conn_id->prepare("
                    SELECT * FROM image ORDER BY time DESC LIMIT 3");

                $sql->setFetchMode(PDO::FETCH_INTO, new image);
                $sql->execute(); 
                if ($sql -> rowCount() < 2){
                    $result = $sql -> fetchAll();
                } else{
                    while ($object = $sql->fetch()) {
                        $result[] = clone $object;
                   }  
                }
                }
                catch (PDOException $e) {
                    $this->error($e->getMessage());
                }
                return $result;

            }            
            
	}

class data{}
class image{}