<?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);

    }


}

?>