<?                                                                                                              # Author: MARGARYAN KAREN
# Class version : 1.3 / December 10 2012

namespace nalva;

if (!defined ("CLASS_CDATABASE"))
{

define ("CLASS_CDATABASE", "");

if ($_SERVER["SERVER_NAME"] == "localhost") {
    define ("DATABASE_USERNAME", "root");
    define ("DATABASE_PASSWORD", "123456");
    define ("DATABASE_NAME"  , "nalva");
    define ("DATABASE_HOSTNAME", "127.0.0.1");
}
else {
    define ("DATABASE_USERNAME", "nalva_db_user");
    define ("DATABASE_PASSWORD", "nalva_db_password");
    define ("DATABASE_NAME"  , "nalva");
    define ("DATABASE_HOSTNAME", "localhost");
}
//else {
//    define ("DATABASE_USERNAME", "ratadent");
//    define ("DATABASE_PASSWORD", "ratPassword123"); 
//    define ("DATABASE_NAME"  , "ratadent");
//    define ("DATABASE_HOSTNAME", "ratadent.db.9165615.hostedresource.com");
//}


$selected_database = ""; // ����� ��� ��-�� ���������� PHP (PHP4 �� ������� ����� ����������� �������� ������)

class CDATABASE
{
      var $dbname;
      var $hostname;
      var $username;
      var $password;

      var $connection_link = NULL;

      function __construct($dbname=DATABASE_NAME, $hostname=DATABASE_HOSTNAME, $username=DATABASE_USERNAME, $password=DATABASE_PASSWORD, $autoconnect=true, $use_pconnect=false)
      {
           $this->setDatabasename($dbname);
           $this->setHostname($hostname);
           $this->setUsername($username);
           $this->setPassword($password);

           if ($autoconnect)
               if ($use_pconnect)
                   CDATABASE::pconnect($dbName, $hostname, $username, $password);
               else
                   CDATABASE::connect($dbname, $hostname, $username, $password);
      }

      function getDatabasename()
      {
           return $this->dbname;
      }

      function getHostname()
      {
           return $this->hostname;
      }

      function getUsername()
      {
           return $this->username;
      }

      function getPassword()
      {
           return $this->password;
      }

      function setDatabasename($dbname)
      {
           $this->dbname = $dbname;
      }

      function setHostname($hostname)
      {
           $this->hostname = $hostname;
      }

      function setUsername($username)
      {
           $this->hostname = $username;
      }

      function setPassword($password)
      {
           $this->hostname = $password;
      }

      function connect($dbname=NULL, $hostname=NULL, $username=NULL, $password=NULL, $use_pconnect = false)
      {
           $dbname    = $dbname   == NULL ? CDATABASE::getDatabasename() : $dbname;
           $hostname  = $hostname == NULL ? CDATABASE::getHostname() : $hostname;
           $username  = $username == NULL ? CDATABASE::getUsername() : $username;
           $password  = $password === NULL ? CDATABASE::getPassword() : $password;

           if ($use_pconnect == true) {
               if ($this->connection_link = mysql_pconnect($hostname, $username, $password)) {
                   mysql_query("SET NAMES UTF8", $this->connection_link);
                   return CDATABASE::select_db($dbname, $this->connection_link);
               }
           } else {
               if ($this->connection_link = mysql_connect($hostname, $username, $password)) {
                   mysql_query("SET NAMES UTF8", $this->connection_link);
                   return CDATABASE::select_db($dbname, $this->connection_link);
               }
           }
      }

      function pconnect($dbname=NULL, $hostname=NULL, $username=NULL, $password=NULL)
      {
           return CDATABASE::connect($dbname, $hostname, $username, $password, true);
      }

      function select_db($dbname)
      {
           return mysql_select_db($dbname);
      }

      function close()
      {
           $result = mysql_close($this->connection_link);
           $this->connection_link = NULL;
           return $result;
      }

      function isConnected()
      {
           return $this->connection_link;
      }

      function query($sql)
      {
           if (!CDATABASE::isConnected())
                return false;
           mysql_query("SET NAMES UTF8", $this->connection_link);
           return mysql_query($sql, $this->connection_link);
      }

      function affected_row()
      {
           return mysql_affected_rows($this->connection_link);
      }

      function num_rows($qresult)
      {
           return mysql_affected_rows($this->connection_link);
      }

      function fetch_array($qresult, $result_type=MYSQL_ASSOC)
      {
          return mysql_fetch_array($qresult, $result_type);
      }

      function fetch_row($qresult)
      {
           return mysql_fetch_row($qresult);
      }

      function fetch_object($qresult)
      {
           return mysql_fetch_object($qresult);
      }

      function field_name($qresult, $field_index)
      {
           return mysql_field_name($qresult, $field_index);
      }

      function num_fields($qresult)
      {
           return mysql_num_fields($qresult);
      }

      function data_seek($qresult, $row_number)
      {
           return mysql_data_seek($qresult, $row_number);
      }

      function free_result($qresult)
      {
           return mysql_free_result($qresult);
      }

      function insert_id()
      {
           return mysql_insert_id($this->connection_link);
      }

      function error()
      {
           return mysql_error($this->connection_link);
      }

      function getFields($tableName, $qresult=NULL)
      {
           if ($qresult == NULL)
           {
               $query = "
                       SELECT *
                       FROM $tableName
                       WHERE 1=0
               ";
               $qresult = CDATABASE::query($query);
           }
           if ($qresult == FALSE)
               return false;

           setType($fieldsCount, "int");
           setType($fields, "array");

           $fieldsCount = CDATABASE::num_fields($qresult);
           for ($tempIndex=0; $tempIndex<$fieldsCount; ++$tempIndex)
                $fields[] = CDATABASE::field_name($qresult, $tempIndex);

           return $fields;

      }

      function getFieldsCount($tableName, $qresult=NULL)
      {
           if ($qresult)
               return CDATABASE::num_fields($qresult);
           else
               return count(CDATABASE::getFields($tableName));
      }

      function getFieldName($tableName, $field_num, $qresult=NULL)
      {
           if ($field_num<0)
               return false;

           $fields = CDATABASE::getFields($tableName, $qresult);
           if ($field_num>=count($fields))
               return false;
           return $fields[$field_num];
      }

      function queryToArray($query, $result_type=MYSQL_ASSOC)
      {
           if ($qresult = CDATABASE::query($query))
               return CDATABASE::resultToArray($qresult, $result_type);

      }

      function resultToArray($qresult, $result_type=MYSQL_ASSOC)
      {
           if ($qresult==false)
               return false;

           setType($tempArray, "array");
           setType($tempRow, "array");

           while ($tempRow = CDATABASE::fetch_array($qresult, $result_type))
                  $tempArray[] = $tempRow;

           return $tempArray;
      }

      function getFieldValues($tableName, $fieldName, $qresult=NULL)
      {
           if (!$qresult)
           {
                $query = "
                      SELECT  $fieldName
                      FROM    $tableName
                ";
                $qresult = CDATABASE::query($query);
           }

           if ($qresult==false)
               return false;

           $tempResult = CDATABASE::resultToArray($qresult, MYSQL_NUM);
           for ($tempIndex=0; $tempIndex<count($tempResult); $tempIndex++)
                $tempResult[$tempIndex] = $tempResult[$tempIndex][0];

           return $tempResult;
      }

      function showQueryResult($qresult, $message="")
      {
        ?>
        <table border=1>
        <caption><font color='red'> (