summaryrefslogtreecommitdiffstats
path: root/Website
diff options
context:
space:
mode:
authorMac-Linux2011-07-29 14:53:15 +0200
committerMac-Linux2011-07-29 14:53:15 +0200
commitb17a2cd20a47251fa0d38838b5068e2ddab396c0 (patch)
treeacfad3f9ee80a33fd8e1bfadfd5300696f626d64 /Website
parentedit timeout for gsm (diff)
parentError code data. (diff)
downloadgsm-selftest-b17a2cd20a47251fa0d38838b5068e2ddab396c0.tar.gz
gsm-selftest-b17a2cd20a47251fa0d38838b5068e2ddab396c0.tar.xz
gsm-selftest-b17a2cd20a47251fa0d38838b5068e2ddab396c0.zip
Merge branch 'master' of lab.ks.uni-freiburg.de:lsfks/projekte/gsm-selftest
Conflicts: For Weekly Test/30-07-2011/GSMHandler.py For Weekly Test/30-07-2011/classController.log
Diffstat (limited to 'Website')
-rw-r--r--Website/Result.php42
1 files changed, 42 insertions, 0 deletions
diff --git a/Website/Result.php b/Website/Result.php
new file mode 100644
index 0000000..d9eaa34
--- /dev/null
+++ b/Website/Result.php
@@ -0,0 +1,42 @@
+<?php
+$dbuser = "root"; //username for the db
+$dbpass = "randompasswordSQL"; //password for the above db user
+
+$dbname = "gsmselftesting"; //name of the db on mysql server
+$server = "localhost"; //address of the mysql server
+
+$db_handle = mysql_connect($server, $dbuser, $dbpass);
+
+$db_found = mysql_select_db($dbname, $db_handle);
+
+if ($db_found==1) {
+
+ $SQL = "SELECT TaskTable.taskID, `from`, `to` , ResultTable.result , ErrorCodeTable.description FROM TaskTable, ResultTable, ErrorCodeTable where TaskTable.taskID = ResultTable.taskID and ErrorCodeTable.errorcode=ResultTable.result";
+ $result = mysql_query($SQL);
+
+ echo "<table>";
+ echo "<tbody align = 'center'>";
+ echo " <tr align='center'>";
+ echo " <td align='center' width='100'>Task ID</td>";
+ echo " <td align='center' width='100'>From</td>";
+ echo " <td align='center' width='100'>To</td>";
+ echo " <td align='center' width='100'>Result</td>";
+ echo " <td align='center' width='100'>Description</td>";
+ echo " </tr>";
+
+
+ while($row = mysql_fetch_row($result))
+ {
+ print "<tr>";
+ foreach ( $row as $field )
+ {
+ print "<td align='center' width='100'>".stripslashes($field)."</td>";
+
+ }
+ print "</tr>";
+ }
+
+ }
+ mysql_close($db_handle);
+
+?>