$qs[$x[0]] = $x[1];
}
-function prettify($s) {
+function prettify($s,$name) {
if (preg_match("/^[0-9]{12}$/",$s)) {
$year = substr($s,0,4);
$month = substr($s,4,2);
$hour = substr($s,8,2);
$minute = substr($s,10,2);
return $day . "/" . $month . "/" . $year . " " . $hour . ":" . $minute;
+ } else if ($name == "sum_time" || $name == "sum_timeuser"){
+ $min = floor($s / 6000);
+ $sec = floor(($s - $min * 6000) / 100);
+ $cents = $s % 100;
+ return $min . "m" . $sec . "." . $cents . "s";
} else
return $s;
}
function printer($q){
static $i = 0;
+ echo "<tr>";
if ( $i == 0) {
- echo "<tr>";
foreach( $q as $name => $txt) {
echo "<th>$name</th>";
- }
- echo "</tr>\n";
- } else {
- $i=0;
- foreach ($q as $k => $v) {
- $i = $i + 1;
- if ( $i%2 == 0)
- echo "<tr class=\"even\">";
- else
- echo "<tr class=\"odd\">";
- foreach( $v as $name => $txt) {
- echo "<td>" . prettify($txt) . "</td>";
- }
- echo "</tr>\n";
}
}
+ echo "</tr>\n";
+ if ( $i%2 == 0)
+ echo "<tr class=\"even\">";
+ else
+ echo "<tr class=\"odd\">";
+ foreach( $q as $name => $txt) {
+ echo "<td>" . prettify($txt,$name) . "</td>";
+ }
+ echo "</tr>\n";
$i++;
}
<tt><? print $q; ?></tt>
</p>
<table border=1>
- <? query($q,&$printer); ?>
+ <? query($q,"printer"); ?>
</table>
<? } ?>
<p><a href="bench.php">BACK to the query page</a></p>