?> // CSIRO Manufacturing Science and Technology, Preston Lab // list page (hymod_bddb / boards) require("defs.php"); $serno=isset($_REQUEST['serno'])?$_REQUEST['serno']:''; $verbose=isset($_REQUEST['verbose'])?intval($_REQUEST['verbose']):0; pg_head("$bddb_label - Browse database" . ($verbose?" (verbose)":"")); ?>

$limit){ $preoffset=max(0,$offset-$limit); $postoffset=$offset+$limit; echo "\n\n"; printf("\n", $offset>0?"":"no", $PHP_SELF, $preoffset, $verbose); printf("\n", $postoffset<$lrow['n']?"":"no", $PHP_SELF, $postoffset, $offset); echo "\n
<%sa href=\"%s?submit=Browse&offset=%d&verbose=%d\">\"<\"<%sa href=\"%s?submit=Browse&offset=%d&verbose=%d\">\">\"
\n"; } mysql_free_result($lr); } ?> comments\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } ?> =$m[1] and serno<=$m[2])"; } else die("illegal serial number ($s)"); $pre = " or "; } } $query .= " order by serno"; if ($serno == '') $query .= " limit $offset,$limit"; $r = mysql_query($query); function print_cell($str) { if ($str == '') $str = ' '; echo "\t\n"; } while($row=mysql_fetch_array($r)){ foreach ($columns as $key) { if (!key_in_array($key, $row)) $row[$key] = ''; } echo "\n"; print_cell("Log"); print_cell("$row[serno]"); print_cell($row['ethaddr']); print_cell($row['date']); print_cell($row['batch']); print_cell($row['type']); print_cell($row['rev']); print_cell($row['location']); if ($verbose) { print_cell("
\n" . urldecode($row['comments']) .
				"\n\t
"); print_cell(gather_enum_multi_print("sdram", 4, $row)); print_cell(gather_enum_multi_print("flash", 4, $row)); print_cell(gather_enum_multi_print("zbt", 16, $row)); print_cell(gather_enum_multi_print("xlxtyp", 4, $row)); print_cell(gather_enum_multi_print("xlxspd", 4, $row)); print_cell(gather_enum_multi_print("xlxtmp", 4, $row)); print_cell(gather_enum_multi_print("xlxgrd", 4, $row)); print_cell($row['cputyp']); print_cell($row['cpuspd']); print_cell($row['cpmspd']); print_cell($row['busspd']); print_cell($row['hstype']); print_cell($row['hschin']); print_cell($row['hschout']); } echo "\n"; } ?>
serno / edit ethaddr date batch type rev location sdramflashzbtxlxtypxlxspdxlxtmpxlxgrdcputypcpuspdcpmspdbusspdhstypehschinhschout
$str

%s Listing\n", $PHP_SELF, $offset, $verbose?0:1, $serno!=''?"&serno=$serno":'', $verbose?"Terse":"Verbose"); ?> Back to Start