source: trunk/includes/databaseconection.php@ 285

<?php
  
class Database
{
  var $id_connection = 0;
  
  function Database($address = 'localhost', $user = 'root', $pass = '')
  {
        $this->id_connection = mysql_connect($address, $user, $pass);
    if(!$this->id_connection) 
      die('Spojení s MySQL databází se nezdařilo.');
  }
        
  function SelectDatabase($NameDatabase)
  {
        $return_selection = mysql_select_db($NameDatabase, $this->id_connection);
    if(!$return_selection)
      die('Databázi '.$NameDatabase.' se nám nepodařilo vybrat.');
  }
   
  function SQLCommand($Command)
  {
          global $Config;
        
          if($Config['Web']['ShowSQLQuery'] == true) 
            echo('<div style="border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: silver; padding-bottom: 2px; padding-top: 2px; font-size: 12px; font-family: Arial;">'.$Command.'</div>');
    $ReturnCommand = mysql_query($Command, $this->id_connection);
          if((mysql_error() != '') and ($Config['Web']['ShowSQLError'] == true)) 
            echo('<div>'.mysql_error().'<br>'.$Command.'</div>');
    return($ReturnCommand);
  }
   
  function ReadFromDatabase($SQL)
  {
    $return_result = mysql_query($sql, $id_spojeni);
    if (!$return_result) die('Nepodařilo se nám načíst řádky z databáze.');
      else return $return_result;
  }
   
  function Disconnect()
  {
        mysql_close($this->id_connection);
  }
}

?>