<?php
class DB {
    public $fields = array();
    private $username = 'promoGuy';
    private $hostname = 'localhost';
    private $password = 'Qk0AN581Ll';
    private $database = 'register_shell';

    private $link = null;

    public function __construct() {
        if (!$this->getLink()) {
            $this->connect();
        }
    }

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

    public function connect() {
        $this->link = mysqli_connect($this->hostname, $this->username, $this->password);
        if ($this->link) {
            mysqli_select_db($this->link, $this->database);
            mysqli_query($this->link, 'SET NAMES utf8');
            mysqli_set_charset($this->link, 'utf8');
            return $this->database;
        } else {
            print "MySQL Error connecting"; exit;
        }

    }

    public function insert($columns = array(), $variables = array()) {
        $query = $this->prepareQuery();
        $result = $this->executeQuery($query, 'insert');
    }

    public function delete($columns = array(), $variables = array(), $where) {
        $query = $this->prepareQuery();
        $result = $this->executeQuery($query, 'delete');
    }

    public function update($columns = array(), $variables = array(), $where) {
        $query = $this->prepareQuery();
        $result = $this->executeQuery($query, 'update');
    }

    public function select($what, $where) {

    }

    private function prepareQuery($queryType, $columns = array(), $variables = array(), $where = null) {

    }

    public function sanitizeVariables($variables = array()) {
        // mysql_real_escape_string()
        $sanitized = array();
        foreach($variables as $key => $value) {
            $sanitized[$key] = urldecode(mysqli_real_escape_string($value));
        }

        return $sanitized;
    }

    private function executeQuery($query, $type) {

        // mysql_affected_rows();
        // mysql_insert_id();
        $error = '';
        mysqli_query($query) or $error = mysqli_error();
        if ($error != '') {
            return $error;
        }

        if ($type == 'insert') {
            return mysqli_insert_id();
        } else {
            return mysqli_affected_rows();
        }
    }
}

?>