Changeset 11505 for trunk/www/db_po/edit_po.php

Timestamp:

07/21/11 11:24:15 (13 years ago)

Author:

Daniela Dorner

Message:

added plenty of new features to view and edit the configuration database

File:

• trunk/www/db_po/edit_po.php (modified) (1 diff)

trunk/www/db_po/edit_po.php

@@ -6 +6 @@
     echo (file_get_contents("index-header.html"));
 
+    //call get_progs() at startup
+    printf("<script type=\"text/javascript\" >\n");
+    printf("window.onload = function () { get_progs(\"\",\"10\",\"edit\"); }\n");
+    printf("</script>\n");
+
     include("db.php");
-    $db_id = mysql_pconnect($host, $user, $pw);
-    if ($db_id==FALSE)
-    {
-        printf("mysql_connect returned the following error: %s\n", mysql_error());
-        die("");
-    }
-    mysql_select_db($db);
-    echo "Hi, this is a test interface for the DB <b>" . $db . "</b>.<br><br>";
-
-    $query0="SELECT fProgram from ProgramOption GROUP BY fProgram";
-
-    $result0=mysql_query($query0, $db_id);
-
+    printf("With this page, you can <u>edit</u> the DB <b>%s</b>.\n", $db);
+    printf("For view, please go <a href='view_po.php'>here</a>.<br><br>\n");
     printf("<table border='0'><tbody>\n");
-    printf("<tr>\n<td>Please select a program:</td>\n");
-    printf("<td>\n<select name='prog' size='1' onchange=\"get_keys(this.value)\"class='Width'>\n");
-    printf("<option value='empty'> ---select program--- </option>\n");
-    printf("<option value='all'> all programs </option>\n");
-    while ($row0 = mysql_fetch_row($result0))
-        printf("<option value='%s'>%s </option>\n", $row0[0], $row0[0]);
-    printf("</select>\n</td>\n</tr>\n");
-    mysql_free_result($result0);
-
-    echo "<tr id='keyfield'></tr>";
-    echo "<tr id='valuefield'></tr>";
-    printf("</tbody></table>\n");
-
-    mysql_close($db_id);
-
-
-
+    printf("<tr>\n");
+    printf("<td valign='top' id='progfield'></td>\n");
+    printf("<td valign='top' id='keyfield'></td>\n");
+    printf("<td valign='top' id='valuefield1'></td>\n");
+    printf("</tr>\n</tbody></table>\n");
 
     echo (file_get_contents("index-footer.html"));