用PHP在MySQL数据库中存储多幅图像

CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    image LONGBLOB
);

<?php
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $imageCount = count($_FILES['images']['name']);
    
    for ($i = 0; $i < $imageCount; $i++) {
        $imageName = $_FILES['images']['name'][$i];
        $imageTmpName = $_FILES['images']['tmp_name'][$i];
        
        $imageData = file_get_contents($imageTmpName);
        $imageData = mysqli_real_escape_string($conn, $imageData);
        
        $query = "INSERT INTO images (name, image) VALUES ('$imageName', '$imageData')";
        mysqli_query($conn, $query);
    }
    
    echo "Images uploaded successfully.";
}
?>

<?php
$query = "SELECT * FROM images";
$result = mysqli_query($conn, $query);

while ($row = mysqli_fetch_assoc($result)) {
    $imageName = $row['name'];
    $imageData = $row['image'];
    
    echo "<img src='data:image/jpeg;base64," . base64_encode($imageData) . "' alt='$imageName'>";
}
?>