12-03-2007, 04:43 PM
|
#1 (permalink)
|
|
The Frequenter
Join Date: Nov 2007
Location: Netherlands
Posts: 460
Thanks: 49
|
Rookietime : mySQL Query class
Hey guys!
Today I sat down for a nice day of PHP'n and this is what first spiked my attention. The mySQL Query function inside a class. Since I use PHP 4.4.7 (still need to upgrade host lol), I am NOT using objects (to my knowledge).
So, if this post is not good enough for advanced PHP programming, you are allowed to move it. Therefor, don't hate me for my mistakes IF I made them. :P
PHP Code:
class MySQLdb {
function Query($Query){
$this->loadstart[] = microtime();
$Query = mysql_query($Query) or die( $this->Error( mysql_error() ) );
$this->loadend[] = microtime();
return $Query;
}
function Debug($DebugType){
if ($DebugType == 'TimeQ') {
for ($i = 0; $i < count($this->loadstart); $i++){
$starttime = $this->loadstart[$i] + $starttime;
}
for ($i = 0; $i < count($this->loadend); $i++){
$endtime = $this->loadend[$i] + $endtime;
}
$querytime = round(($endtime - $starttime), 7);
return $querytime;
}
}
Which exports to my page (there is more lines of code but they don't matter as much);
"1 queries made in 0.000324 seconds :: Page loaded in 0.0004311 seconds"
What do you guys think? Is it good, can it be done better? Easier? |
|
|
Join the friendly bunch on IRC...
Threaded Mode
