图片上传 mysql数据库

import mysql.connector

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 插入图片信息
try:
    sql = "INSERT INTO images (filename, path) VALUES (%s, %s)"
    val = ("example.jpg", "/path/to/example.jpg")
    cursor.execute(sql, val)
    db.commit()
except mysql.connector.Error as err:
    print("Something went wrong: {}".format(err))
finally:
    cursor.close()
    db.close()

import os

# 保存图片文件
file_path = "/path/to/save/example.jpg"
with open(file_path, "wb") as f:
    f.write(request.files['file'].read())

# 检查文件是否存在
if os.path.exists(file_path):
    print("File saved successfully")
else:
    print("Failed to save file")