summaryrefslogblamecommitdiffstats
path: root/Website/Result.php
blob: d9eaa34f51612010f4a2dcc70996066d98965b85 (plain) (tree)









































                                                                                                                                                                                                                                                 
<?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);

?>