PHP类中的数据库连接

Question

What is the quickest and easiest way to make a database connection available inside a class so all the public functions in the class can access it and how do I call it inside a function?

Answer 1

Save the connection handle as a class variable.

class Test
{
     public $dbh;

     public function connect($host,$username,$password,$dbname)
     {
          $this->dbh = mysql_connect($host,$username,$password); //Of course, you'd want to do some actual error checking.  Also, you can have a separate function for selecting the DB if you need to use multiple databases
          mysql_select_db($dbname,$this->dbh);  //You use $this->variable to refer to the connection handle
     }

     public function query($sql)
     {
         return mysql_query($sql,$this->dbh);
     }
}