I am playing with different ways to do database interaction in PHP, and one of the ideas I have been playing with is connecting to the DB in the constructor and disconnecting in the destructor. This is the code from my Database class.function __construct(){  $this->link = mysql_connect($this->server.':'.$this->port, $this->username);  if(!$this->link)    die('Could not connect: '.mysql_error());  if(!mysql_select_db($this->database, $this->link))    die('Could not select database: '.mysql_error());}    function __destruct(){  if(mysql_close($this->link))    $this->link = null; }This works well, my only reservation is that if I need to connect several to hit the database several times it will do multiple connections and disconnects. If I do that a lot I can see, maybe, potential problems. Is this a concern or is there a better way to do this? And is my code even up to snuff in general?
Database connection in constructor and destructor
php;mysql;constructor
From your question I infer that you're thinking of having several instances of the DB class.  If so I'd suggest abstracting the connection out to another class and holding a reference to the same connection in each DB instance.You could then set your connection up as a singleton and thus only connect & disconnect once.Apologies in advance if I've missed anything here - my PHP is far from fluent.