图片上传到mysql

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

<?php
$target_dir = "uploads/";
$imageFileType = strtolower(pathinfo($_FILES["fileToUpload"]["name"],PATHINFO_EXTENSION));

// 检查文件是否为图片
if(isset($_POST["submit"])) {
    $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
    if($check !== false) {
        echo "File is an image - " . $check["mime"] . ".";
        if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_dir . basename($_FILES["fileToUpload"]["name"]))) {
            echo "The file " . htmlspecialchars( basename( $_FILES["fileToUpload"]["name"])). " has been uploaded.";
            
            // 连接数据库
            $conn = new mysqli($servername, $username, $password, $dbname);
            if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
            }
            
            // 插入图片数据到数据库
            $sql = "INSERT INTO images (name, data) VALUES (?, ?)";
            $stmt = $conn->prepare($sql);
            $stmt->bind_param("s", basename($_FILES["fileToUpload"]["name"]));
            $stmt->bind_param("b", file_get_contents($_FILES["fileToUpload"]["tmp_name"]));
            $stmt->execute();
            
            $stmt->close();
            $conn->close();
        } else {
            echo "Sorry, there was an error uploading your file.";
        }
    } else {
        echo "File is not an image.";
    }
}
?>

<?php
// 连接数据库
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// 获取图片数据
$sql = "SELECT data FROM images WHERE id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $imageId);
$stmt->execute();
$stmt->bind_result($imageData);
$stmt->fetch();

header("Content-type: image/jpeg");
echo $imageData;

$stmt->close();
$conn->close();
?>