PHP Code:
<?php
class SpeedTest {
var $db; // Database resource
var $query; // Query resource
var $start; // Start time
function SpeedTest () {
$this->start=$this->getmicrotime();
$this->db=mysql_pconnect('localhost','user','pass'); // Enter correct values here
mysql_select_db('databasename',$this->db); // Enter correct dbname here
}
function getmicrotime(){
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}
function fetch() {
$this->query=mysql_query('SELECT * FROM products',$this->db); // Perform query here
}
function getTime() {
return ($this->getmicrotime()-$this->start);
}
function getRow () {
if ( $row=mysql_fetch_array($this->query,MYSQL_ASSOC) )
return $row;
else
return false;
}
}
$sTest=new SpeedTest;
?>
<html>
<head>
<title>PHP Speed Test</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>
body {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
}
td {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
}
th {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
}
form {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
}
input {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
}
textarea {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
}
select {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
}
ul {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
list-style-type: disc;
list-style-position: outside;
}
li {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
}
ol {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
list-style-type: upper-roman;
list-style-position: outside;
}
.small {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 9px;
}
.big {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 18px;
}
.bodystyle {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
}
.box1 {
padding: 3px;
border-width: thin;
border-style: solid;
border-color: #CCCCCC #666666 #666666 #CCCCCC;
}
.box2 {
border-width: 3px;
border-style: solid;
padding: 5px;
}
</style>
</head>
<body>
<?php
$sTest->fetch();
?>
<p><b>Query Took: <?php print ($sTest->getTime()); ?></b></p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="box1">
<td>productID</td>
<td>productName</td>
<td>supplierID</td>
<td>categoryID</td>
<td>quantityPerUnit</td>
<td>unitPrice</td>
<td>unitsInStock</td>
<td>unitsOnOrder</td>
<td>reorderLevel</td>
<td>discontinued</td>
</tr>
<?php
while ( $row=$sTest->getRow() ) {
?>
<tr>
<td><?php print ( $row['productID']); ?></td>
<td><?php print ( $row['productName']); ?></td>
<td><?php print ( $row['supplierID']); ?></td>
<td><?php print ( $row['categoryID']); ?></td>
<td><?php print ( $row['quantityPerUnit']); ?></td>
<td><?php print ( $row['unitPrice']); ?></td>
<td><?php print ( $row['unitsInStock']); ?></td>
<td><?php print ( $row['unitsOnOrder']); ?></td>
<td><?php print ( $row['reorderLevel']); ?></td>
<td><?php print ( $row['discontinued']); ?></td>
</tr>
<?php
}
?>
<p><b>Page Took: <?php print ( $sTest->getTime() ); ?></b></p>
</table>
</body>
</html>
Bookmarks