Gamebak Class DB

<?php
/*
db_class.php
Created by C. Alexandru for codebox.ro and coderi.ro

Usage:
$db->query("SQL");
$db->raw_query("SQL");
$db->secure_string($_GET['something']);
$db->secure_string($_POST['something']);

$db->close_connection();

Don't forget to close MySql connection
DB Setup
*/
defined('DB_SERVER')?NULL:define("DB_SERVER", "localhost");
defined('DB_USER')?NULL  :define("DB_USER", "root");
defined('DB_PASS')?NULL  :define("DB_PASS", "");
defined('DB_NAME')?NULL  :define("DB_NAME", "v2ge");


class MysqlDatabase{
        public $connection;
        function __construct(){$this->open_connection();}

        public function open_connection(){$this->connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS) or die("DB connection error");mysql_select_db(DB_NAME,$this->connection);}

        public function close_connection() {
                if(isset($this->connection)) {
                        mysql_close($this->connection);
                        unset ($this->connection);
                }
        }
        public function query($sql){
                return mysql_query($sql,$this->connection);
        }
        public function raw_query($sql){
            return mysql_unbuffered_query($sql,$this->connection);
        }
        public function secure_string($string){return htmlspecialchars(htmlentities(mysql_real_escape_string($string),ENT_QUOTES),ENT_QUOTES);}
}


$db = new MysqlDatabase();


?>