CLASSE POUR MYSQL

<?PHP 

class database { 

        // ******************************** 
        var $HOST =     "localhost"; 
        var $USER =      ""; 
        var $PASS =      ""; 
        var $BDD  =      ""; 
        // ******************************** 

        var $id_connect; 
        var $select_db; 
        var $result; 
        var $error; 

     
    function connect () 
    { 
    
        $this->id_connect = mysql_connect($this->HOST, $this->USER, $this->PASS); 

        if(!$this->id_connect) { 
            $this->error_mysql("Impossible de se connecter à la base de données"); 
            return 0; 
        } 

        $this->select_db = @mysql_select_db($this->BDD, $this->id_connect);     

        if(!$this->select_db) { 
            $this->error_mysql("Impossible d'acceder à la base de données"); 
            return 0; 
        } 
    } 

     
    function query($QUERY) 
    { 
        $this->result = mysql_query($QUERY, $this->id_connect); 

        if(!$this->result) { 
            $this->error_mysql("Problème de requète"); 
            return 0; 
        } 
    } 


    function close_mysql() 
    { 
        mysql_close($this->id_connect); 
    } 

   
    function error_mysql($MSG) 
    { 
        $this->error = @mysql_error($this->id_connect); 
         
        echo "<B>Erreur :</B><BR><I>". $msg ."<BR> ". $this->error ."</I><BR>"; 
    } 


    function fetch_array() 
    { 
        return @mysql_fetch_array($this->result); 
    } 


    function num_rows() 
    { 
        return @mysql_num_rows($this->result); 
    } 

} 
?>