mysql读取图片php

CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    image_name VARCHAR(255),
    image_data LONGBLOB
);

<?php
// 连接到MySQL数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 获取图片ID
$image_id = 1;

// 查询图片数据
$sql = "SELECT image_data FROM images WHERE id = $image_id";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $image_data = $row["image_data"];

    // 设置正确的Content-Type
    header("Content-type: image/jpeg"); // 根据实际图片类型调整

    // 输出图片数据
    echo $image_data;
} else {
    echo "没有结果";
}

$conn->close();
?>