<?php

/**
 * Database layer
 * Requirements
 * 1. Next constant must be defined:
 *          DB_HOST
 *          DB_NAME
 *           DB_PASS
 *           DB_LOGIN
 */

class DbMySQL{
 var $db_host;
 var $db_login;
 var $db_pass;
 var $db_name;
 var $db_link = null;
 var $error_report = false;
 var $last_err = 0;

 function DbMySQL($tHost, $tName, $tLogin, $tPass){
         $this->db_host = $tHost;
        $this->db_name = $tName;
         $this->db_login = $tLogin;
        $this->db_pass = $tPass;
 }

 function connect(){
 	
        $this->db_link = mysql_connect($this->db_host, $this->db_login, $this->db_pass,false);
        if ($this->db_link)
                if(mysql_select_db($this->db_name, $this->db_link))
                return true;
        return false;
 }

 function select($tSql){
    $query_res = mysql_query ($tSql, $this->db_link);

    if(!$query_res) {
        $this->last_err = mysql_error($this->db_link);
        if ($this->last_err)
            echo "<br>\nMySQL error: " . $this->last_err."\nQuery was [$tSql]";
            return false;
    }

    $return_res = array();
    while ($row = mysql_fetch_assoc($query_res))
        $return_res[] = $row;

    return $return_res;
 }
 function select_row($tSql){
        $result = array();
        $res = $this->query($tSql, $this->db_link);
        if ($res){
            $tmp = mysql_fetch_assoc($res);
            if (is_array($tmp)){
                $result = $tmp;
            }
        }else{
            return false;
        }
        return $result;
 }
 
 function query($tSql){
    $query_res = mysql_query($tSql, $this->db_link);
    if(!$query_res) {
        $this->last_err = mysql_error($this->db_link);
        
        if ($this->last_err){
            echo "<br>\nMySQL error: " . $this->last_err;
        }
    }
    return $query_res;
 }
 function insert($tSql){
    $res = $this->query($tSql, $this->db_link);
    $last_insert_id = 0;
    if (mysql_errno($this->db_link)==0){
        $last_insert_id = mysql_insert_id($this->db_link);
    }
    return $last_insert_id;
 }

 function close(){
         return mysql_close($this->db_link);
 }
}
?>