Includere connessione al DB in una classe PHP

[Grino]

Una cosa fatta per fare...

<?php
   
   class cDBMySQL{
       private static $conn=null;
       public function  __construct($dbname,$server,$username,$password) {
           if(is_null(self::$conn))
               self::$conn=  mysql_connect($server, $username, $password);
           mysql_select_db($dbname);
       }
       
       public function Query($sql) {
           return mysql_query($sql, self::$conn);
       }
   }
   
   class strana{
       private $db;
       public function  __construct() {
           $this->db=new cDBMySQL("nomedb", "serverDB", "userdb", "passworddb");
           $this->db->Query("altra query in classe");
       }
   }
   
   class strana2{
       private $db;
       public function  __construct($db) {
           $this->db=$db;
           $db->Query("altra query");
       }
   }
   
   $conn1=new cDBMySQL($dbname,$server, $username, $password);
   $res1=$conn1->Query("select * from tabella1");
   $conn2=new cDBMySQL($dbname,$server, $username, $password);
   $res2=$conn2->Query("select * from tabella2");
   $st2=new strana2($conn1);
   ?>