<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');
/**
 * DBBase.php
 * Tietokantakäsittelyn perusluokka. Sisältää perusfunktiot (select, insert, update, delete)
 *
 * @author onik
 *
 */

class DBBase {

    // Määritellään perusmuuttujat tietokantayhteyttä varten

    public $server = "localhost";
    public $database = "fivezone3";
    public $username = "fivezone";
    public $password = "JuT5ehUn";
    public $sql;
    public $result;

    /**
     * Lataa tarvittavat luokat automaattisesti
     *
     * @param $classname    luokan nimi
     * @return void
     */

    function __autoload($classname) {
        require_once $classname . '.php';
    }


    /**
     * Suorittaa kyselyn tietokantaan (geneerinen query)
     *
     * @param $query    kysely SQL-kielellä
     *
     * @return kyselyn tulos / error
     */

    function doQuery($q) {
        $sql = new mysqli($this->server, $this->username, $this->password, $this->database);
        $result = $sql->query($q);
        if($result == false) {
            return false;
        }
        $sql->close();
        return $result;
    }

    /**
     * Select: Suorittaa select kyselyn, palauttaa tulokset
     *
     * @param $what SELECT ?
     * @param $from FROM ?
     * @param $where    WHERE ?
     * @param $sort ORDER BY ?
     * @param $limit    LIMIT ?
     * @return kyselyn tulos / error
     */

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


        if($what == "" || $from == "") {
            return false;
        }

        $tmp = "SELECT " . $what . " FROM " . $from;
        if($where != "") {
            $tmp .= " WHERE " . $where;
        }
        if($sort != "") {
            $tmp .= " ORDER BY " . $sort;
        }
        if($limit != "") {
            $tmp .= " LIMIT " . $limit;
        }
        print_r($tmp);
        if(!$result = $this->doQuery($tmp)) {
            return false;
        } else {
            return $result;
        }
    }

    /**
     * Suorittaa insert kyselyn, palauttaa tuloksen
     *
     * @param $table    INSERT INTO ?
     * @param $fields   (?) array
     * @param $values   VALUES (?) array
     * @return kyselyn tulos / error
     */

    function insert($table, $fields, $values) {

        if ($table == "") {
            return false;
        }

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

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

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


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

        $tmp = "INSERT INTO " . $table . " (";

        for ($i=0;$i<count($fields)-1;$i++) {
            $tmp .= $fields[$i] . ", ";
        }
        $tmp .= $fields[count($fields)-1];

        $tmp .= ") VALUES " . "(";

        for ($i=0;$i<count($values)-1;$i++) {
            $tmp .= $values[$i] . ", ";
        }
        $tmp .= $values[count($values)-1];

        $tmp .= ")";

        if(!$result = $this->doQuery($tmp)) {
            return "ERROR";
        } else {
            return true;
        }
    }

    /**
     * Suorittaa update kyselyn, palauttaa tuloksen
     *
     * @param $table    UPDATE ?
     * @param $fields   ?= array
     * @param $values   ? array
     * @param $where    WHERE ?
     * @param $sort     ORDER BY ?
     * @param $limit    LIMIT ?
     * @return kyselyn tulos / error
     */

    function update($table, $fields, $values, $where = "", $sort = "", $limit = "") {

        if ($table == "") {
            return false;
        }

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

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

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

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

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

        $tmp = "UPDATE " . $table . " SET ";

        for ($i=0;$i<count($fields)-1;$i++) {
            $tmp .= $fields[$i] . "=" . $values[$i] . ", ";
        }
        $tmp .= $fields[$i] . "=" . $values[$i];

        if($where != "") {
            $tmp .= " WHERE " . $where;
        }
        if($sort != "") {
            $tmp .= " ORDER BY " . $sort;
        }
        if($limit != "") {
            $tmp .= " LIMIT " . $limit;
        }
        echo($tmp);
        if(!$result = $this->doQuery($tmp)) {
            return "error";
        } else {
            return $result;
        }

    }

    /**
     * Poistaa kyselyn mukaiset tiedot
     *
     * @param $from DELETE FROM ?
     * @param $where    WHERE ?
     * @param $limit    LIMIT ?
     * @return kyselyn tulos / error
     */

    function delete($from, $where, $limit = "") {

        if($from == "") {
            return false;
        }

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

        if(!$result = $this->doQuery($tmp)) {
            return "ERROR";
        } else {
            return $result;
        }

    }
}

?>