如何将图片标题转换为slug并保存到数据库？拉威尔

import re
import mysql.connector

# 获取图片标题
image_title = "How to Convert Image Title to Slug and Save to Database?"

# 转换为slug
slug = re.sub(r'\W+', '-', image_title.lower())

# 保存到数据库
try:
    # 连接数据库
    conn = mysql.connector.connect(
        host="localhost",
        user="your_username",
        password="your_password",
        database="your_database"
    )
    
    # 创建游标对象
    cursor = conn.cursor()
    
    # 执行插入操作
    sql = "INSERT INTO images (title, slug) VALUES (%s, %s)"
    values = (image_title, slug)
    cursor.execute(sql, values)
    
    # 提交事务
    conn.commit()
    
    # 关闭游标和连接
    cursor.close()
    conn.close()
    
    print("Image slug saved to database successfully!")
except mysql.connector.Error as error:
    print("Error while connecting to MySQL database:", error)