summaryrefslogtreecommitdiffstats
path: root/Website
diff options
context:
space:
mode:
authortt412011-07-29 01:35:42 +0200
committertt412011-07-29 01:35:42 +0200
commit59cdbe8fd166f8024ee18fdb7b75107c56d1cef1 (patch)
treeccbdf927c60cc82890e01d59e2664c73ca4bc9d8 /Website
parentdelete logging for controller and edit name log file for controller. (diff)
downloadgsm-selftest-59cdbe8fd166f8024ee18fdb7b75107c56d1cef1.tar.gz
gsm-selftest-59cdbe8fd166f8024ee18fdb7b75107c56d1cef1.tar.xz
gsm-selftest-59cdbe8fd166f8024ee18fdb7b75107c56d1cef1.zip
temporary result page. just for test
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);
+
+?>