把照片存进mysql数据库

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

import mysql.connector

def store_image(image_path):
    conn = mysql.connector.connect(
        host="localhost",
        user="your_username",
        password="your_password",
        database="your_database"
    )
    cursor = conn.cursor()

    with open(image_path, 'rb') as file:
        binary_data = file.read()

    query = "INSERT INTO images (name, image) VALUES (%s, %s)"
    values = (image_path.split('/')[-1], binary_data)
    cursor.execute(query, values)

    conn.commit()
    cursor.close()
    conn.close()

# 使用示例
store_image("path_to_your_image.jpg")

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

import os
import mysql.connector

def store_image(image_path):
    conn = mysql.connector.connect(
        host="localhost",
        user="your_username",
        password="your_password",
        database="your_database"
    )
    cursor = conn.cursor()

    # 保存图片到文件系统
    file_name = image_path.split('/')[-1]
    new_path = f"/path/to/your/images/{file_name}"
    os.rename(image_path, new_path)

    query = "INSERT INTO images (name, path) VALUES (%s, %s)"
    values = (file_name, new_path)
    cursor.execute(query, values)

    conn.commit()
    cursor.close()
    conn.close()

# 使用示例
store_image("path_to_your_image.jpg")