Home python View records table using Python tkinter mysql

View records table using Python tkinter mysql

1 min read

This tutorial will teach you how to View records using python mysql to the table.

import tkinter as tk
from tkinter import ttk
import mysql.connector

def show():
        mysqldb = mysql.connector.connect(host="localhost", user="root", password="", database="smschool")
        mycursor = mysqldb.cursor()
        mycursor.execute("SELECT id,stname,course,fee FROM record")
        records = mycursor.fetchall()

        for i, (id,stname, course,fee) in enumerate(records, start=1):
            listBox.insert("", "end", values=(id, stname, course, fee))

root = tk.Tk()
root.title("Student Records")
label = tk.Label(root, text="Student Records", font=("Arial",30)).grid(row=0, columnspan=3)

cols = ('id', 'stname', 'course','fee')
listBox = ttk.Treeview(root, columns=cols, show='headings')

for col in cols:
    listBox.heading(col, text=col)    
    listBox.grid(row=1, column=0, columnspan=2)
closeButton = tk.Button(root, text="Close", width=15, command=exit).grid(row=4, column=1)

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


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

Mastering Object-Oriented Programming Project in Java

In this tutorial, I will teach Java programming projects along with Object-Oriented Progra…