<?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 __construct($tHost, $tName, $tLogin, $tPass){
    $this->db_host = $tHost;
    $this->db_name = $tName;
    $this->db_login = $tLogin;
    $this->db_pass = $tPass;
 }

 function getLink() {
     return $this->db_link;
 }

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

 function escapeSting($sql) {
    return mysqli_real_escape_string($this->db_link, $sql);
 }

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

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

    $return_res = array();
    while ($row = mysqli_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 = mysqli_fetch_assoc($res);
        if (is_array($tmp)){
            $result = $tmp;
        }
    }else{
        return false;
    }
    return $result;
 }
 
 function query($tSql){
    $query_res = mysqli_query($this->db_link, $tSql);
    if(!$query_res) {
        $this->last_err = mysqli_error($this->db_link);
        
        if ($this->last_err){
            echo "<br>\nMySQL error: ". $tSql . $this->last_err;
        }
    }
    return $query_res;
 }

 function insert($tSql){
    $res = $this->query($tSql, $this->db_link);
    $last_insert_id = 0;
    if (mysqli_errno($this->db_link)==0){
        $last_insert_id = mysqli_insert_id($this->db_link);
    }
    return $last_insert_id;
 }

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