mysql数据库中怎样存图片

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

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

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

// 读取图片文件
$image_path = "path/to/image.jpg";
$image_data = file_get_contents($image_path);

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

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

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

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

// 从数据库读取图片数据
$result = $conn->query("SELECT image FROM images WHERE id = 1");
$row = $result->fetch_assoc();
$image_data = $row['image'];

// 将图片数据输出到浏览器
header("Content-type: image/jpeg");
echo $image_data;

$conn->close();
?>

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

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

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

// 图片文件路径
$image_path = "path/to/image.jpg";
$image_url = "http://example.com/images/image.jpg";

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

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

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

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

// 从数据库读取图片URL
$result = $conn->query("SELECT url FROM images WHERE id = 1");
$row = $result->fetch_assoc();
$image_url = $row['url'];

// 输出图片URL
echo "<img src='" . $image_url . "' />";

$conn->close();
?>