<?php
$servername = "10.1.64.173";
$username = "jake";
$password = "abc123";
$dbname = "chess club";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM results";
$result = $conn->query($sql);

print "<style> table, td, th{
	border: 1px solid black;
	text-align: left;
	font-weight: normal;
	font-family: 'Courier New';
	font-size: 100%;
}
img {
	width: 100px;
	height: auto;
}
</style>";

print "<table>";
print "<tr>";
echo "<td>" . "<h3>Game ID</h3>" 			. "</td>";
echo "<td>" . "<h3>Date</h3>" 				. "</td>";
echo "<td>" . "<h3>Time</h3>" 				. "</td>";
echo "<td>" . "<h3>Location</h3>" 			. "</td>";
echo "<td>" . "<h3>Player (White)</h3>" 	. "</td>";
echo "<td>" . "<h3>Player (Black)</h3>" 	. "</td>";
echo "<td>" . "<h3>Results</h3>" 			. "</td>";
echo "<td>" . "<h3>Additional Information</h3>" . "</td>";
echo "<td>" . "<h3>Image</h3>" 				. "</td>";
print "</tr><tr>";

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {

        echo "<td>" . $row["GameID"] . 	"</td>";
		echo "<td>" . $row["Date"] . 		"</td>";
		echo "<td>" . $row["Time"] . 		"</td>";
		echo "<td>" . $row["Location"] . 	"</td>";
		echo "<td>" . $row["Player (White)"] . "</td>";
		echo "<td>" . $row["Player (Black)"] . "</td>";
		echo "<td>" . $row["Results"] . 	"</td>";
		echo "<td>" . $row["Additional Information"] . "</td>";
		echo "<td>" . $row["Image"] . 		"</td>";

		print "</tr>";
    }
	print "</table>";

} else {
    echo "0 results";
}
$conn->close();
?>