用PHP在HTML表中链接MySQL查询结果

<table>
  <tr>
    <th>ID</th>
    <th>Name</th>
    <th>Email</th>
  </tr>
  
  <?php
    // 连接到MySQL数据库
    $conn = mysqli_connect("localhost", "username", "password", "database_name");
    
    // 检查连接是否成功
    if (!$conn) {
      die("连接失败：" . mysqli_connect_error());
    }
    
    // 执行MySQL查询
    $sql = "SELECT id, name, email FROM table_name";
    $result = mysqli_query($conn, $sql);
    
    // 检查查询结果是否为空
    if (mysqli_num_rows($result) > 0) {
      // 输出数据到表格中
      while ($row = mysqli_fetch_assoc($result)) {
        echo "<tr>";
        echo "<td>" . $row["id"] . "</td>";
        echo "<td>" . $row["name"] . "</td>";
        echo "<td>" . $row["email"] . "</td>";
        echo "</tr>";
      }
    } else {
      echo "没有找到匹配的结果";
    }
    
    // 关闭数据库连接
    mysqli_close($conn);
  ?>
  
</table>