Untitled

<html>
<head>
<title>Student Assignment Grade</title>
<head>
<body>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "mysql";


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

$sql = "SELECT Name, ID, Assignment, Grade FROM Assignments";
$result = $con->query($sql);
  echo '<table border=1 cellpadding=1 width ="90%">';

			echo "<td style='border:1px solid black;Font-size:18;Font-Weight:bold;text-align:center'>";
            echo "Name";
            echo "</td>";
            echo "<td style='border:1px solid black;Font-size:18;Font-Weight:bold;text-align:center'>";
            echo "ID";
            echo "</td>";
            echo "<td style='border:1px solid black;Font-size:18;Font-Weight:bold;text-align:center'>";
            echo "Assignments";
            echo "</td>";
            echo "<td style='border:1px solid black;Font-size:18;Font-Weight:bold;text-align:center'>";
            echo "Average Grade";
            echo "</td>";

 if($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
		echo '<tr class = "t_row">';
		echo '<td>' .$row['Name']. '</td>';
		echo '<td>' .$row['ID']. '</td>';
		echo '<td>' .$row['Assignment']. '</td>';
		echo '<td>' .$row['Grade']. '</td>';
	}

		echo '</table>';

 }else {
    echo "0 results";
}
$con->close();
?>
</body>
</html>