如何使用php和mysql在html页面中显示数据库中的图像

CREATE TABLE images (
  id INT AUTO_INCREMENT PRIMARY KEY,
  filename VARCHAR(255) NOT NULL,
  path VARCHAR(255) NOT NULL
);

<?php
if(isset($_POST['submit'])){
  $filename = $_FILES['image']['name'];
  $tempname = $_FILES['image']['tmp_name'];
  $folder = "uploads/".$filename;
  move_uploaded_file($tempname, $folder);
  
  // 将图像信息插入到数据库中
  $conn = mysqli_connect("localhost", "username", "password", "database");
  $sql = "INSERT INTO images (filename, path) VALUES ('$filename', '$folder')";
  mysqli_query($conn, $sql);
  mysqli_close($conn);
}
?>

<form action="" method="POST" enctype="multipart/form-data">
  <input type="file" name="image">
  <input type="submit" name="submit" value="Upload">
</form>

<?php
$conn = mysqli_connect("localhost", "username", "password", "database");
$sql = "SELECT * FROM images";
$result = mysqli_query($conn, $sql);

while($row = mysqli_fetch_assoc($result)){
  $filename = $row['filename'];
  $path = $row['path'];
  echo "<img src='$path' alt='$filename'>";
}

mysqli_close($conn);
?>