Re: Pear DB Tutorial
| From: | Sebastian Bergmann | Date: | Mon, 16 Apr 2001 14:29:39 +0000 |
| Subject: | Re: Pear DB Tutorial | ||
| References: | 1 2 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-236@lists.php.net to get a copy of this message | ||
Andrei Zmievski wrote:
> Has anyone written a simple wrapper around PEAR DB stuff? I don't want
> to do DB::isError() after every method call, pretty much. Having it
> simplified would be nice.
In phpOpenTracker we use the following "wrapper"
function query_db($query) {
static $queries;
// modify query, if needed
if(MYSQL_TUNING) {
if(!(strpos($query, "insert") === false)) {
$query = str_replace("insert", "insert delayed", $query);
} elseif(!(strpos($query, "update") === false)) {
$query = str_replace("update", "update low_priority", $query);
}
}
// output query in debug mode
if(POT_DEBUG) {
print "<b>" . ++$queries . ".</b> " . $query . "<br
/>";
}
// perform query
$result = $this->db->query($query);
// check result
if (DB::isError($result)) {
$this->_pot_halt("query failed: " . DB::errorMessage($result));
} else {
return $result;
}
}
--
sebastian bergmann sb@sebastian-bergmann.de
http://www.sebastian-bergmann.de
bonn.phpug.de | www.php.net | www.phpOpenTracker.de | www.titanchat.de