summaryrefslogtreecommitdiffstats
path: root/Website
diff options
context:
space:
mode:
authoraa1112011-07-29 20:37:34 +0200
committeraa1112011-07-29 20:37:34 +0200
commit4d3040ebae86f3e89c034757aa0bad7f2563ee6d (patch)
tree9ae85e2e3019efedb96b80a79795482cf9560b79 /Website
parentMerge branch 'master' of lab.ks.uni-freiburg.de:lsfks/projekte/gsm-selftest (diff)
parentMerge branch 'master' of lab.ks.uni-freiburg.de:lsfks/projekte/gsm-selftest (diff)
downloadgsm-selftest-4d3040ebae86f3e89c034757aa0bad7f2563ee6d.tar.gz
gsm-selftest-4d3040ebae86f3e89c034757aa0bad7f2563ee6d.tar.xz
gsm-selftest-4d3040ebae86f3e89c034757aa0bad7f2563ee6d.zip
Merge branch 'master' of lab.ks.uni-freiburg.de:lsfks/projekte/gsm-selftest
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);
+
+?>