如何在php中上传目录和数据库中的图片

<form action="upload.php" method="post" enctype="multipart/form-data">
  <input type="file" name="image">
  <input type="submit" value="上传">
</form>

<?php
$targetDir = "uploads/"; // 指定目录
$targetFile = $targetDir . basename($_FILES["image"]["name"]); // 获取上传文件的路径

// 检查文件类型
$imageFileType = strtolower(pathinfo($targetFile, PATHINFO_EXTENSION));
if ($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" && $imageFileType != "gif") {
  echo "只允许上传 JPG, JPEG, PNG 或 GIF 格式的图片.";
  exit;
}

// 将文件移动到目标目录
if (move_uploaded_file($_FILES["image"]["tmp_name"], $targetFile)) {
  echo "文件上传成功.";
} else {
  echo "文件上传失败.";
}

// 将文件路径保存到数据库中
$databaseHost = "localhost";
$databaseName = "your_database";
$databaseUsername = "your_username";
$databasePassword = "your_password";

$conn = new mysqli($databaseHost, $databaseUsername, $databasePassword, $databaseName);
if ($conn->connect_error) {
  die("数据库连接失败: " . $conn->connect_error);
}

$imagePath = $targetFile; // 图片路径
$sql = "INSERT INTO images (path) VALUES ('$imagePath')";
if ($conn->query($sql) === TRUE) {
  echo "图片路径保存到数据库成功.";
} else {
  echo "图片路径保存到数据库失败: " . $conn->error;
}

$conn->close();
?>

<?php
$databaseHost = "localhost";
$databaseName = "your_database";
$databaseUsername = "your_username";
$databasePassword = "your_password";

$conn = new mysqli($databaseHost, $databaseUsername, $databasePassword, $databaseName);
if ($conn->connect_error) {
  die("数据库连接失败: " . $conn->connect_error);
}

$sql = "SELECT * FROM images";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
  while ($row = $result->fetch_assoc()) {
    echo "<img src='" . $row["path"] . "' alt='图片'>";
  }
} else {
  echo "没有上传的图片.";
}

$conn->close();
?>