<?php
//mysql.php

//yhendus serveriga
//andmebaasi valimine
//p2ringute saatmine
//andmete lugemine

class MySQL
{
	var $connect = false;
	var $host = false;
	var $user = false;
	var $pass = false;
	var $dbname = false;

	//konstruktor
	function MySQL($h, $u, $p, $dbn)
	{
		$this->host = $h;
		$this->user = $u;
		$this->pass = $p;
		$this->dbname = $dbn;
		$this->conn();
		$this->selectDB();
	}

	//yhendus
	function conn()
	{
		$this->connect = mysql_connect($this->host,
		$this->user, $this->pass);

		if(!is_resource($this->connect))
		{
			echo 'Probleem andmebaasi yhendusega<br />';
			exit;
		}
	}
	//andmebaasi valik
	function selectDB()
	{
		$result = mysql_select_db($this->dbname);
		if($result == false)
		{
			echo 'Probleem andmebaasi valikuga<br />';
			exit;
		}
	}
	//p2ringu ssaatmine
	function query($sql)
	{
		$result = mysql_query($sql, $this->connect);
		if($result == false)
		{
			echo 'Probleem p2ringuga: <b>'.$sql.'</b><br />';
			echo mysql_error();
			exit;
		}
		return $result;
	}


	//andmete salvestamine
	function getArray($sql)
	{
		$result = $this->query($sql);
		$data = array();
		while($res = mysql_fetch_array($result, MYSQL_ASSOC))
		{
			$data[] = $res;
		}
		if(count($data) == 0)
		{
			return false;
		}
		else return $data;

	}






}



?>