PHP を使用してオンライン フォト アルバムと写真管理機能を実装する方法

CREATE TABLE `photos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `filename` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

<form action="upload.php" method="post" enctype="multipart/form-data">
  <label for="title">标题：</label>
  <input type="text" name="title" id="title" required>
  <br>
  <label for="description">描述：</label>
  <textarea name="description" id="description" required></textarea>
  <br>
  <label for="photo">照片：</label>
  <input type="file" name="photo" id="photo" required accept="image/*">
  <br>
  <input type="submit" value="上传">
</form>

<?php
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
  $title = $_POST['title'];
  $description = $_POST['description'];
  $filename = $_FILES['photo']['name'];
  $tempFileName = $_FILES['photo']['tmp_name'];
  $uploadPath = 'photos/' . $filename;

  if (move_uploaded_file($tempFileName, $uploadPath)) {
    // 文件上传成功，将文件信息保存到数据库中
    $conn = new mysqli('localhost', 'username', 'password', 'database');
    $stmt = $conn->prepare('INSERT INTO photos (title, description, filename) VALUES (?, ?, ?)');
    $stmt->bind_param('sss', $title, $description, $filename);
    $stmt->execute();

    echo '文件上传成功！';
  } else {
    echo '文件上传失败！';
  }
}
?>

<?php
$conn = new mysqli('localhost', 'username', 'password', 'database');
$result = $conn->query('SELECT * FROM photos');

while ($row = $result->fetch_assoc()) {
  echo '<img src="photos/' . $row['filename'] . '" alt="' . $row['title'] . '">';
  echo '<h3>' . $row['title'] . '</h3>';
  echo '<p>' . $row['description'] . '</p>';
}
?>