<?php
  class Database
  { // BEGIN class Database
  	// variables
  	var $id_connection = 0;
  //	var $LastResult;

  
  	// constructor
  	function Database($addres,$user,$pass)  //default: $Database = new Database('localhost','root','');
  	{ // BEGIN constructor
  	 $this->id_connection = mysql_connect($addres,$user,$pass);
     if (!$this->id_connection) 
       die('Spojení s MySQL databází se nezdařilo.');
  	} // END constructor
  	
  	function SelectDatabase($NameDatabase)
   { // BEGIN function SelectDatabase
   	$return_selection = mysql_select_db($NameDatabase,$this->id_connection);
    if (!$return_selection)
      die('Databázi pokus se nám nepodařilo vybrat.');
   } // END function SelectDatabase
   
   function SQLCommand($Command)
   { // BEGIN function SQLCommand
    $ReturnCommand = mysql_query($Command,$this->id_connection);
    if (!$ReturnCommand) {
      die('Nepodařilo se aplikovat příkaz: <br />'.$Command);
    } else {
      return $ReturnCommand;
    }
   } // END function SQLCommand
   
   function ReadOneRowFromDatabase($SQL)    // "SELECT * FROM User"
   { // BEGIN function ReadFromDatabase
		$query=$SQL;
		$result = @mysql_query($query,$this->id_connection);
		$data = @mysql_fetch_array($result);
    if (mysql_num_rows($result)<>1) {
      return false;
    } else {
      return $data;
    }
   } // END function ReadFromDatabase
   
   function Disconnect()
   { // BEGIN function Disconnect
   	mysql_close($this->id_connection);
   } // END function Disconnect
  } // END class Database

?>
