<?php
require_once("config.php");

//echo DB_SERVER . "<br />" . DB_USER . "<br />" . DB_PASS . "<br />" . DB_NAME . "<br />";

class MySQLDatabase {

    private $connection;

    function __construct() {
        $this->open_connection();
    }

    // create connection to database and select it
    public function open_connection() {
        $this->connection = mysqli_connect(DB_SERVER, DB_USER, DB_PASS, DB_NAME);
        if(!$this->connection) {
            die("Database connection failed: " . mysqli_error());
        }   else{
                $db_selected = mysqli_select_db($this->connection, DB_NAME);
                if (!$db_selected) {
                    die("Database selection failed: " . mysqli_error());
                }
            }
    }

    // close database connection
    public function close_connection() {
        if(isset($this->connection)){
            mysqli_close($this->connection);
            unset($this->connection);
        }
    }


    // perform query
    public function query($sql){
        $result = mysqli_query($this->connection, $sql);
        $this->confirm_query($result);
        return $result;
    }


    // prep data for submission to mysql
    public function mysql_prep( $value ) {
        $magic_quotes_active = get_magic_quotes_gpc();
        $new_enough_php = function_exists( "mysqli_real_escape_string" ); // i.e. PHP >= v4.3.0
        if( $new_enough_php ) { // PHP v4.3.0 or higher
            // undo any magic quote effects so mysql_real_escape_string can do the work
            if( $magic_quotes_active ) { $value = stripslashes( $value ); }
            $value = mysqli_real_escape_string( $value );
        } else { // before PHP v4.3.0
            // if magic quotes aren't already on then add slashes manually
            if( !$magic_quotes_active ) { $value = addslashes( $value ); }
            // if magic quotes are active, then the slashes already exist
        }
        return $value;
        }


    // confirm query success
    private function confirm_query($result) {
        if (!$result) {
            die("Database query failed: " . mysqli_error());
        }
    }


}

$database = new MySQLDatabase();