source: trunk/www/db_po/get_values.php@ 11353

Last change on this file since 11353 was 11353, checked in by Daniela Dorner, 13 years ago
added script to display and edit entries of the configuration database (ProgramOptions) and scripts which are called by this script
  • Property svn:executable set to *
File size: 2.8 KB
Line 
1<?php
2{
3 ini_set("display_errors", "On");
4 ini_set("mysql.trace_mode", "On");
5
6 if (empty($_GET["fKey"]))
7 {
8 echo "Please select a key.<br>";
9 return;
10 }
11 if (empty($_GET["fProgram"]))
12 {
13 echo "Please select a program.<br>";
14 return;
15 }
16
17
18 include("db.php");
19 $db_id = mysql_pconnect($host, $user, $pw);
20 if ($db_id==FALSE)
21 {
22 printf("mysql_connect returned the following error: %s\n", mysql_error());
23 die("");
24 }
25 mysql_select_db($db);
26
27 $query1 = "SELECT Max(fCounter) FROM History";
28 $result1=mysql_query($query1, $db_id);
29 $row1 = mysql_fetch_row($result1);
30 $maxcount=$row1[0];
31 //echo $maxcount;
32
33 $query0 ="SELECT fIndex, fProgram, fKey, fValue, fDescription, fCounter FROM ProgramOption ";
34 $query0.="WHERE fKey='".$_GET["fKey"]."'";
35 if ($_GET["fProgram"]!="all")
36 $query0.="AND fProgram='".$_GET["fProgram"]."' ";
37
38 $result0=mysql_query($query0, $db_id);
39
40 printf("<td valign='top'>Please edit:</td>\n");
41 printf("<td>\n");
42 printf("<button onClick='ShowCurrent();' id='showcurrent' style='display:none'>Show Current</button>\n");
43 printf("<button onClick='ShowAll();' id='showall' style='display:inline'>Show All</button>\n");
44 printf("<button onClick='addRow(\"%s\",\"%s\");' id='addrow' style='display:inline'>Add Row</button>\n", $_GET["fProgram"], $_GET["fKey"]);
45 printf("<table border='1' width='100px' height='100px'><tbody id='valtable'>\n");
46 printf("<tr><th>Index / Counter</th><th>Program</th><th>Key</th><th>Value</th><th>Description</th>");
47 printf("<th>Action</th></tr>\n");
48 while ($row0 = mysql_fetch_row($result0))
49 {
50 if ($row0[5]==$maxcount)
51 printf("<tr id='new%s' style='display:'>\n", $row0[0]);
52 else
53 printf("<tr id='old%s' style='display:none'>\n", $row0[0]);
54 printf("<td> %s / %s</td>\n", $row0[0], $row0[5]);
55 printf("<td id='prog%s'>%s</td>\n", $row0[0], $row0[1]);
56 printf("<td id='key%s'>%s</td>\n", $row0[0], $row0[2]);
57 printf("<td align='right' id='val%s'>%s</td>\n", $row0[0], $row0[3]);
58 printf("<td id='descr%s'>%s</td>\n", $row0[0], $row0[4]);
59 if ($row0[5]==$maxcount)
60 printf("<td id='action%s'><input type='button' value='Edit' onclick='EditRow(\"%s\")'></td>\n</tr>\n", $row0[0], $row0[0]);
61 else
62 printf("<td id='action%s'></td>\n</tr>\n", $row0[0]);
63 $maxindex=$row0[0];
64 }
65 printf("<div id='addline'></div>");
66 printf("</tbody></table>\n<br>\n");
67 printf("<div id='maxindex' style='display:none'>%s</div>\n", $maxindex);
68 printf("</td>\n");
69
70 mysql_free_result($result0);
71
72 mysql_close($db_id);
73
74 ini_set("display_errors", "Off");
75 ini_set("mysql.trace_mode", "Off");
76}
77?>
Note: See TracBrowser for help on using the repository browser.