<?
    class database{
        var $db;
        var $rs;
        var $debug=false;
        
        public function __construct($host,$user,$pass,$database){
            $this->db=mysqli_connect($host,$user,$pass) or die(mysqli_error($this->db));            
            mysqli_select_db($this->db,$database) or die(mysqli_error($this->db));
        }
        
        public function sanitise($str){
            return mysqli_real_escape_string($this->db,$str);
        }    
        
        public function query($sql){
            $this->log_query($sql);
            $rs =mysqli_query($this->db,$sql) or die(mysqli_error($this->db) . "<br>Query: $sql");
            return $rs;
        }
        public function query_single($sql){
            $this->log_query($sql);
            $rs = mysqli_query($this->db,$sql) or die(mysqli_error($this->db) . "<br>Query Single: $sql");
            $r = mysqli_fetch_array($rs);
            return $r;
        }
        public function query_forget($sql){
            $this->log_query($sql);
            mysqli_query($this->db,$sql) or die(mysqli_error($this->db) . "<br>Query Forget: $sql");
        }
        
        public function lastid(){
            $id=mysqli_insert_id($this->db) or die(mysqli_error($this->db) . "<br>Lastid: $sql");
            return $id;
        }
        
        public function fetch_array($rs){
            return mysqli_fetch_array($rs);
        }
        public function num_rows($rs){
            return mysqli_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);
                }
            }
        }
        
?>