SQL データベース データを PHP/HTML テーブルに表示するにはどうすればよいですか?

<code class="php"><?php
// Connect to the MySQL database
$connection = mysql_connect('localhost', 'root', ''); // Replace 'root' with your database username and leave password blank if none exists
mysql_select_db('hrmwaitrose'); // Replace 'hrmwaitrose' with your database name

// Execute the query to retrieve data from the 'employee' table
$query = "SELECT * FROM employee"; // Remove the semicolon (;) from the SQL query
$result = mysql_query($query);

// Create a new HTML table
echo "<table>";

// Retrieve each row of data from the query result
while ($row = mysql_fetch_array($result)) {
    // Create a new table row for each employee record
    echo "<tr><td>" . htmlspecialchars($row['name']) . "</td><td>" . htmlspecialchars($row['age']) . "</td></tr>";
}

// Close the HTML table
echo "</table>";

// Close the MySQL connection
mysql_close();
?></code>