8
print $q->start_html(-title=>"Nightly Tester DB");
10
unless($q->param('pwd'))
12
print $q->startform();
13
print $q->password_field(-name=>"pwd", -size=>20, -maxlength=>20);
19
# database information
23
$passwd=$q->param('pwd');
24
$connectionInfo="dbi:mysql:$db;$host";
26
# make connection to database
27
$dbh = DBI->connect($connectionInfo,$userid,$passwd) or die DBI->errstr;
28
$query = "Select DISTINCT(NAME) from Tests";
29
my $sth = $dbh->prepare($query) || die "Can't prepare statement: $DBI::errstr";
30
my $rc = $sth->execute or die DBI->errstr;
31
while (($n) = $sth->fetchrow_array)
36
$query = "Select DISTINCT(TEST) from Tests";
37
my $sth = $dbh->prepare($query) || die "Can't prepare statement: $DBI::errstr";
38
my $rc = $sth->execute or die DBI->errstr;
39
while (($n) = $sth->fetchrow_array)
45
# print join "<BR>", @names;
47
print $q->startform();
48
print $q->scrolling_list(-name=>"test", -values=>\@tests, -multiple=>'true');
50
print $q->scrolling_list(-name=>"name", -values=>\@names, -multiple=>'true');
53
print $q->hidden("pwd", $q->param('pwd'));
56
# disconnect from database
59
#now generate the urls to the chart
60
if ($q->param('test') && $q->param('name'))
62
my @names = $q->param('name');
63
my @tests = $q->param('test');
65
print join "<BR>", @names;
67
print join "<BR>", @tests;
69
$str = "pwd=" . $q->param('pwd');
75
$str = "$str&t$count=$t&n$count=$n";
79
print "<img src=\"cgiplotNLT.pl?$str\">";