<?php
class SKDatabase {

    //internal info
    var $errno = 0;

    //number of rows affected by SQL query
    var $affected_rows = 0;

    var $connection = 0;

    private $error;

    var $query_id = 0;

    var $db = 'blog';
    var $host = 'localhost';
    var $user = 'root';
    var $pass = '';


    private static $SKDatabase = null;

    public function __construct(){
        $this->error = array();
        $this->connect();
    }

    public static function getInstance(){
        if (self::$SKDatabase == null) {
            self::$SKDatabase = new SKDatabase();
            return self::$SKDatabase;
        }
        return self::$SKDatabase;
    }

    public function __destruct(){ @mysql_close($this->connection); }

    public function connect(){
        $this->connection = @mysql_connect($this->host, $this->user, $this->pass) or die("Não foi possível conectar ao banco de dados, verifique os seus dados.");
        mysql_select_db($this->db, $this->connection) or die("O banco de dados informado não existe.");

    }

    public function disconnect(){
        @mysql_close($this->connection);
        $this->connection = null;
    }

    public function query($sql){
        $result = mysql_query($sql, $this->connection);
        if (!$result) {
            die('Invalid query: ' . mysql_error());
        }
        return $result;
    }

    public function find($sql){
        $rows = array();
        $result = $this->query($sql);
        while($r = mysql_fetch_assoc($result)) {
            $rows[] = $r;
        }
        mysql_free_result($result);
        return $rows;
    }

    public function save($table, $data) {
        $query = "INSERT INTO `".$table."` ";
        $values = ''; $columns = '';

        foreach ($data as $key => $val) {
            $columns .= "`$key`, ";
            if(strtolower($val)=='null') $values .= "NULL, ";
            elseif(strtolower($val)=='now()') $values .= "NOW(), ";
            else $values .= "'".$this->escape($val)."', ";
        }

        $query .= "(". rtrim($columns, ', ') .") VALUES (". rtrim($values, ', ') .");";

        if ($this->query($query)) {
            return mysql_insert_id();
        }
        return false;
    }

    function escape($string) {
        if(get_magic_quotes_runtime()) $string = stripslashes($string);
        return mysql_real_escape_string($string);
    }

}
?>