Re: How can a script tell if there's a MySQL problem?
| From: | Nathan Rixham | Date: | Fri, 09 Jan 2009 17:02:28 +0000 |
| Subject: | Re: How can a script tell if there's a MySQL problem? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-285856@lists.php.net to get a copy of this message | ||
Bastien Koert wrote:
1. Make sure you are freeing up all resources as soon as you can -> mysql_close();little thing I've done for some time that's stuck with; (php5+ only) on all of my database connection classes, I have the db close function in the destructor just to make sure <?php class MysqlConnection { protected $dbHandle; //holds the connection resource public function __destruct() {
if(is_resource($this->dbHandle)) {
mysql_close($this->dbHandle);
}
}
}
?>
just 'cos it's one less thing to worry about.