<?php

class DBBase {
    private $server = "localhost";
    private $database = "fivezone3";
    private $username = "fivezone";
    private $password = "JuT5ehUn";
    private $sql;
    private $result;

    function __construct() {
        $sql = new $mysqli($this->$server, $this->$username, $this->$password, $this->$database);
        if (mysqli_connect_errno()) {
            printf("Connect failed: %s\n", mysqli_connect_error());
            exit();
        }
    }

    function __destruct() {
        $sql->close();
    }

    function query($query) {
        $result = $sql->query($query);
        return $result;
    }

    function select($what, $from, $where, $sort, $limit) {
        $what = mysql_real_escape_string($what);
        $from = mysql_real_escape_string($from);
        $where = mysql_real_escape_string($where);
        $sort = mysql_real_escape_string($sort);
        $limit = mysql_real_escape_string($limit);

        $tmp = "SELECT " . $what . " FROM " . $from;
        if($where != "") {
            $tmp .= " WHERE " . $where;
        }
        if($sort != "") {
            $tmp .= " ORDER BY " . $sort;
        }
        if($limit != "" {
            $tmp .= " LIMIT " . $limit;
        }

        return $sql->query($tmp);

    }

    function insert($table, $fields, $values) {
        $table = mysql_real_escape_string($table);

        if (count($fields) != count($values)){
            return false;
            }

        for ($i=0;$i<count($fields);$i++) {
            $fields[$i] = mysql_real_escape_string($fields[$i]);
        }

        for ($j=0;$j<count($values);$j++) {
            $values[$j] = mysql_real_escape_string($values[$j]);
        }

        $tmp = "INSERT INTO " . $table . "(" . $fields .") VALUES " . "(" . $values . ")";

        return $sql->query($tmp);

}

    function delete($from, $where, $limit) {
        $from = mysql_real_escape_string($from);
        $where = mysql_real_escape_string($where);
        $limit = mysql_real_escape_string($limit);

        $tmp = "DELETE FROM " . $from;
        if($where != "") {
            $tmp .= " WHERE " . $where;
        }
        if($limit != "" {
            $tmp .= " LIMIT " . $limit;
        }

        return $sql->query($tmp);

    }

}

?>