python - 连接到本地主机数据库的 python 中的搜索框

Question

大家好我正在为我的学校开发一个项目，在同一个项目中我需要一个 python 搜索框，我已经或多或少地知道它是如何开发的，但它给出了一些错误。抱歉我的英语不好，但这不是我的母语。我在这里留下我的代码。

import mysql.connector
from tkinter import *
con = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="",
    database="testing"
)
top = Tk()
top.title('Search form')
top.geometry("200x200")
cursor = con.cursor()
name_box = Entry()
name_box.pack(side = RIGHT, expand = True)


def search(tup):
    try:
        person_name = name_box.get()
        cursor.execute("SELECT * FROM `admin` WHERE `email`=%s",name.box.get())
        return (cursor.fetchone())
    


        self.button = Button(self.frame, text="Display text", command=search)

Answer 1

您的代码缺少一个重要部分，请参阅末尾的最后一个命令，以便您可以输入任意数量的搜索

你走在正确的轨道上，但如你所见，mysql 需要更多行

import mysql.connector
import datetime
from mysql.connector.cursor import MySQLCursorPrepared
from tkinter import *

mydb = mysql.connector.connect(
     host="localhost",
     user="root",
     passwd="password",
     database="testdb"
)
mycursor = mydb.cursor(cursor_class=MySQLCursorPrepared)
top = Tk()
top.title('Search form')
top.geometry("200x200")
name_box = Entry()
name_box.pack(side = RIGHT, expand = True)

def get_name():
    global person_name
    person_name = name_box.get()
    try:
        sql1="SELECT `mytable`.`Name` FROM `testdb`.`mytable` WHERE Name = %s;"
        mycursor.execute(sql1,(person_name,))
        records = mycursor.fetchall()
        for x in records:
            print(x)
    except mysql.connector.Error as err:
        print("Something went wrong: {}".format(err))

person_name = ""
button = Button(top, text="Display text", command=get_name)
button.pack()


mainloop()