mysql网页留言板

import mysql.connector

try:
    conn = mysql.connector.connect(
        host="localhost",
        user="your_username",
        password="your_password",
        database="your_database"
    )
    print("Connected to MySQL database")
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    if conn.is_connected():
        conn.close()

import mysql.connector

conn = mysql.connector.connect(host="localhost", user="user", password="pass", database="db")
cursor = conn.cursor()

query = "SELECT * FROM messages WHERE id = %s"
cursor.execute(query, (user_input,))
result = cursor.fetchall()

CREATE INDEX idx_message_id ON messages(id);

try:
    conn.start_transaction()
    cursor.execute("INSERT INTO messages (content) VALUES (%s)", (message,))
    conn.commit()
except mysql.connector.Error as err:
    conn.rollback()
    print(f"Transaction failed: {err}")