<?
    class database{
        var $db;
        var $rs;
        var $debug=false;
        
        public function __construct($host,$user,$pass,$database){
            $this->db=mysql_connect($host,$user,$pass) or die(mysql_error());            
            mysql_select_db($database,$this->db) or die(mysql_error());
        }
        
        public function query($sql){
            $this->log_query($sql);
            $rs =mysql_query($sql,$this->db) or die(mysql_error() . "<br>$sql");
            return $rs;
        }
        public function query_single($sql){
            $this->log_query($sql);
            $rs = mysql_query($sql,$this->db) or die(mysql_error() . "<br>$sql");
            $r = mysql_fetch_array($rs);
            return $r;
        }
        public function query_forget($sql){
            $this->log_query($sql);
            mysql_query($sql,$this->db) or die(mysql_error() . "<br>$sql");
        }
        
        public function lastid(){
            $id=mysql_insert_id($this->db) or die(mysql_error() . "<br>$sql");
            return $id;
        }
        
        public function fetch_array($rs){
            return mysql_fetch_array($rs);
        }
        public function num_rows($rs){
            return mysql_num_rows($rs);
        }
        
        public function log_query($sql){
            if($this->debug)
            {    
                
                if($fs=fopen(getcwd()."/sql_log.txt","a"))
                {
                    fwrite($fs,$sql."\r\n");
                    fclose($fs);
                }
            }
        }
        
?>