Home python Search using python tkinter mysql

Search using python tkinter mysql

1 min read
0
0
3,390

This tutorial will teach you how to search using python Gui application connect with mysql.

from tkinter import *
import mysql.connector

def Ok():
    global myresult
    studname = e1.get()
    coursename = e2.get()
    fee = e3.get()

    mysqldb=mysql.connector.connect(host="localhost",user="root",password="",database="smschool")
    mycursor=mysqldb.cursor()

    try:
        mycursor.execute("SELECT * FROM record where id = '" + studname + "'")
        myresult = mycursor.fetchall()

        for x in myresult:
            print(x)
        e2.delete(0, END)
        e2.insert(END, x[2])
        e3.delete(0, END)
        e3.insert(END, x[3])

    except Exception as e:
       print(e)
       mysqldb.rollback()
       mysqldb.close()

root = Tk()
root.title("Search Mysql")
root.geometry("300x200")

Label(root, text="Student ID").place(x=10, y=10)
Button(root, text="Search", command=Ok ,height = 1, width = 13).place(x=140, y=40)
Label(root, text="Course").place(x=10, y=80)
Label(root, text="Fee").place(x=10, y=120)

e1 = Entry(root)
e1.place(x=140, y=10)

e2 = Entry(root)
e2.place(x=140, y=80)

e3 = Entry(root)
e3.place(x=140, y=120)

root.mainloop()


i have attached the video link below. which will do this tutorials step by step.

  • Python Introduction

    Python is a world best programming language.in this tutorials we cover about the fundament…
  • ATM Pin No Validation using Python

    this is tutorial will explains how to do the ATM Pin No Validation using Python step by st…
  • Chicken Shop Inventory using Python

    The Inventory Management System is developed using Python. The project is built to manage …
Load More Related Articles
Load More By admin
Load More In python

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also

Laravel 11 CRUD Mastering RESTful API MVC with Repository Pattern

In this tutorial will teach Laravel 11 Api MVC with Repository Pattern Crud Application st…