třída pro MySQL

<?php
  
  
  class mysql_driver
  {
     private $conn;
   
    public function connect($server,$login,$password,$database,$charset = 'utf8')
    {
         $this->conn = mysql_connect($server,$login,$password) or die(mysql_error());
         $this->select_db($database);
         $this->set_charset($charset); 
    }  

    protected function select_db($database)
    {  
        mysql_select_db($this->$database,$this->conn) or die(mysql_error());        
    }

    protected function set_charset($charset)
    { 
        mysql_set_charset($charset,$this->conn) or die (mysql_error());        
    }
    
    public function truncate($table)
    {
        $this->query('TRUNCATE TABLE '.$table);
        
    }
    
    public function query($sql)
    {
        return mysql_query($sql,$this->conn);
    }
    
    public function order_by($column, $by = 'ASC')
    {
        $string = 'ORDER BY ';
        if(is_array($column))
        {
            foreach($column as $val)
            {
                $string .= $val.',';
            }
            $string = substr($string,0,-1);
        }
        
        return $string.' '.$by;
    }
    
    public function current_timestamp()
    {
        return ' CURRENT_TIMESTAMP() ';
    }
    
    public function current_date()
    {
        return ' CURRENT_DATE() ';
    }
    
    public function current_time()
    {
        return ' CURTIME() ';
    }
    

    public function last_inserted_id()
    {
        return mysql_insert_id($this->conn);        
    }
    
    private function protect_db($value)
    {
        if(is_int($value))
        {
            return $value;
        }
        return mysql_escape_string($value);       
    }
 
    public function close()
    {
        mysql_close($this->conn);
    }

    function __destruct()
    {
        $this->close();
    }
  }
?>