mysql存储图片数据表

CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    image_data LONGBLOB NOT NULL,
    upload_date DATETIME DEFAULT CURRENT_TIMESTAMP
);

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

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

// 读取图片文件
$image_path = 'example.jpg';
$image_data = file_get_contents($image_path);

// 插入图片数据到数据库
$sql = "INSERT INTO images (name, image_data) VALUES (?, ?)";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $image_name);
$stmt->bind_param("s", $image_data);
$image_name = 'example.jpg';
$stmt->execute();

echo "图片上传成功";

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

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

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

// 从数据库中读取图片数据
$sql = "SELECT image_data FROM images WHERE id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $image_id);
$image_id = 1; // 假设我们要读取id为1的图片
$stmt->execute();
$stmt->bind_result($image_data);
$stmt->fetch();

// 设置HTTP头信息
header("Content-type: image/jpeg");

// 输出图片数据
echo $image_data;

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