mysql查看存储的图片

SELECT image_data FROM images WHERE id = 1;

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='your_database')
cursor = conn.cursor()

# 查询图片数据
cursor.execute("SELECT image_data FROM images WHERE id = 1")
result = cursor.fetchone()

if result:
    image_data = result[0]
    
    # 保存图片到本地
    with open('image.jpg', 'wb') as f:
        f.write(image_data)

# 关闭连接
cursor.close()
conn.close()

<?php
// 连接数据库
$conn = new mysqli("localhost", "username", "password", "database");

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

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

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    header("Content-type: image/jpeg");
    echo $row["image_data"];
} else {
    echo "没有结果";
}

$conn->close();
?>