<?php
/*
 * @ https://EasyToYou.eu - IonCube v11 Decoder Online
 * @ PHP 7.4
 * @ Decoder version: 1.0.2
 * @ Release: 10/08/2022
 */

// Decoded file for php version 74.
if(!defined("IN_SITE")) {
    exit("The Request Not Found");
}
include_once __DIR__ . "/../vendor/autoload.php";
$dotenv = Dotenv\Dotenv::createImmutable(__DIR__ . "/../");
$dotenv->load();
class DB
{
    private $ketnoi;
    public function connect()
    {
        if(!$this->ketnoi) {
            $this->ketnoi = mysqli_connect($_ENV["DB_HOST"], $_ENV["DB_USERNAME"], $_ENV["DB_PASSWORD"], $_ENV["DB_DATABASE"]) or exit("Error => DATABASE");
            mysqli_query($this->ketnoi, "set names 'utf8' ");
        }
    }
    public function dis_connect()
    {
        if($this->ketnoi) {
            mysqli_close($this->ketnoi);
        }
    }
    public function site($data)
    {
        $this->connect();
        $row = $this->ketnoi->query("SELECT * FROM `settings` WHERE `name` = '" . $data . "' ")->fetch_array();
        return $row["value"];
    }
    public function query($sql)
    {
        $this->connect();
        $row = $this->ketnoi->query($sql);
        return $row;
    }
    public function cong($table, $data, $sotien, $where)
    {
        $this->connect();
        $row = $this->ketnoi->query("UPDATE `" . $table . "` SET `" . $data . "` = `" . $data . "` + '" . $sotien . "' WHERE " . $where . " ");
        return $row;
    }
    public function tru($table, $data, $sotien, $where)
    {
        $this->connect();
        $row = $this->ketnoi->query("UPDATE `" . $table . "` SET `" . $data . "` = `" . $data . "` - '" . $sotien . "' WHERE " . $where . " ");
        return $row;
    }
    public function insert($table, $data)
    {
        $this->connect();
        $field_list = "";
        $value_list = "";
        foreach ($data as $key => $value) {
            $field_list .= "," . $key;
            $value_list .= ",'" . mysqli_real_escape_string($this->ketnoi, $value) . "'";
        }
        $sql = "INSERT INTO " . $table . "(" . trim($field_list, ",") . ") VALUES (" . trim($value_list, ",") . ")";
        return mysqli_query($this->ketnoi, $sql);
    }
    public function update($table, $data, $where)
    {
        $this->connect();
        $sql = "";
        foreach ($data as $key => $value) {
            $sql .= $key . " = '" . mysqli_real_escape_string($this->ketnoi, $value) . "',";
        }
        $sql = "UPDATE " . $table . " SET " . trim($sql, ",") . " WHERE " . $where;
        return mysqli_query($this->ketnoi, $sql);
    }
    public function update_value($table, $data, $where, $value1)
    {
        $this->connect();
        $sql = "";
        foreach ($data as $key => $value) {
            $sql .= $key . " = '" . mysqli_real_escape_string($this->ketnoi, $value) . "',";
        }
        $sql = "UPDATE " . $table . " SET " . trim($sql, ",") . " WHERE " . $where . " LIMIT " . $value1;
        return mysqli_query($this->ketnoi, $sql);
    }
    public function remove($table, $where)
    {
        $this->connect();
        $sql = "DELETE FROM " . $table . " WHERE " . $where;
        return mysqli_query($this->ketnoi, $sql);
    }
    public function get_list($sql)
    {
        $this->connect();
        $result = mysqli_query($this->ketnoi, $sql);
        if(!$result) {
            exit("Câu truy vấn bị sai");
        }
        $return = [];
        while ($row = mysqli_fetch_assoc($result)) {
            $return[] = $row;
        }
        mysqli_free_result($result);
        return $return;
    }
    public function get_row($sql)
    {
        $this->connect();
        $result = mysqli_query($this->ketnoi, $sql);
        if(!$result) {
            exit("Câu truy vấn bị sai");
        }
        $row = mysqli_fetch_assoc($result);
        mysqli_free_result($result);
        if($row) {
            return $row;
        }
        return false;
    }
    public function num_rows($sql)
    {
        $this->connect();
        $result = mysqli_query($this->ketnoi, $sql);
        if(!$result) {
            exit("Câu truy vấn bị sai");
        }
        $row = mysqli_num_rows($result);
        mysqli_free_result($result);
        if($row) {
            return $row;
        }
        return false;
    }
}

?>