1 | <?php
|
---|
2 | {
|
---|
3 | ini_set("display_errors", "On");
|
---|
4 | ini_set("mysql.trace_mode", "On");
|
---|
5 |
|
---|
6 | echo (file_get_contents("index-header.html"));
|
---|
7 |
|
---|
8 | include("db.php");
|
---|
9 | $db_id = mysql_pconnect($host, $user, $pw);
|
---|
10 | if ($db_id==FALSE)
|
---|
11 | {
|
---|
12 | printf("mysql_connect returned the following error: %s\n", mysql_error());
|
---|
13 | die("");
|
---|
14 | }
|
---|
15 | mysql_select_db($db);
|
---|
16 | echo "Hi, this is a test interface for the DB <b>" . $db . "</b>.<br><br>";
|
---|
17 |
|
---|
18 | $query0="SELECT fProgram from ProgramOption GROUP BY fProgram";
|
---|
19 |
|
---|
20 | $result0=mysql_query($query0, $db_id);
|
---|
21 |
|
---|
22 | printf("<table border='0'><tbody>\n");
|
---|
23 | printf("<tr>\n<td>Please select a program:</td>\n");
|
---|
24 | printf("<td>\n<select name='prog' size='1' onchange=\"get_keys(this.value)\"class='Width'>\n");
|
---|
25 | printf("<option value='empty'> ---select program--- </option>\n");
|
---|
26 | printf("<option value='all'> all programs </option>\n");
|
---|
27 | while ($row0 = mysql_fetch_row($result0))
|
---|
28 | printf("<option value='%s'>%s </option>\n", $row0[0], $row0[0]);
|
---|
29 | printf("</select>\n</td>\n</tr>\n");
|
---|
30 | mysql_free_result($result0);
|
---|
31 |
|
---|
32 | echo "<tr id='keyfield'></tr>";
|
---|
33 | echo "<tr id='valuefield'></tr>";
|
---|
34 | printf("</tbody></table>\n");
|
---|
35 |
|
---|
36 | mysql_close($db_id);
|
---|
37 |
|
---|
38 |
|
---|
39 |
|
---|
40 |
|
---|
41 | echo (file_get_contents("index-footer.html"));
|
---|
42 |
|
---|
43 | ini_set("display_errors", "Off");
|
---|
44 | ini_set("mysql.trace_mode", "Off");
|
---|
45 | }
|
---|
46 | ?>
|
---|