Python : How To Search And Filter Data In Tkinter TreeView Using Python And MySQL

Python How To Filter Data In Tkinter Treeview Using Python And MySQL Database

In this Python Tutorial we will see How To Use Search Data In Tkinter Table (Treeview)  Using MySQL Database And Python .

In This Tutorial We Will Use:

- Python Programming Language.

- Tkinter Graphical User Interface.
- VsCode IDE .
- XAMPP .
- PhpMyAdmin .


 

Python Source Code:

import tkinter as tk

from tkinter import *

from tkinter import ttk

import mysql.connector

root = Tk()

root.title("Search")

bckg = 'grey'

connection = mysql.connector.connect(host='localhost', user='root', password='',

port='3306', database='test_py')

c = connection.cursor()

frame = tk.Frame(root, bg=bckg)

label_search = tk.Label(frame, text = "Search By First or Last Name:", bg=bckg,

fg='gold', font=('verdana',12))

entry_search = tk.Entry(frame, font=('verdana',12))

button_search = tk.Button(frame, text='Search', font=('verdana',12), bg='#0984e3',

fg="#ffffff")

trv = ttk.Treeview(frame, columns=(1,2,3,4,5), height=15, show="headings")

trv.column(1, anchor=CENTER, stretch=NO, width=100)

trv.column(2, anchor=CENTER, stretch=NO, width=100)

trv.column(3, anchor=CENTER, stretch=NO, width=100)

trv.column(4, anchor=CENTER, stretch=NO, width=100)

trv.column(5, anchor=CENTER, stretch=NO, width=100)

trv.heading(1, text='ID')

trv.heading(2, text='First Name')

trv.heading(3, text='Last Name')

trv.heading(4, text='Email')

trv.heading(5, text='Age')

def find():

# clear treeview

for item in trv.get_children():

trv.delete(item)

val = entry_search.get()

c.execute("SELECT * FROM `users_2` WHERE `firstname` LIKE %s or `lastname`

like %s",("%"+val+"%","%"+val+"%"))

users = c.fetchall()

for row in users:

trv.insert('',END, values=row)

button_search['command'] = find

find()

label_search.grid(row=0, column=0, padx=10, pady=10)

entry_search.grid(row=0, column=1, padx=10, pady=10)

button_search.grid(row=0, column=2, padx=10, pady=10)

trv.grid(row=1, column=0, columnspan=3)

frame.grid(row=0, column=0, sticky="nswe")

root.mainloop()

///////////////OUTPUT: 

                     

---

Download Projects Source Code

▶ Get Python Projects

▶ Get C# Projects

▶ Get Java Projects

▶ Get Java + C# + VB.Net + Python Projects

PYTHON And MySQL - How To Search And Display Data In MySQL Database Using Python Tkinter

PYTHON Code - How To Search Record In MySQL Database And Show The Results Python Tkinter

In this Python Tutorial we will learn How To Find Data In MySQL Database With A Specific 
Value From TextField And Display The Result In a Texboxes In Python .

we will use the Tkinter library to create the GUI that incorporates a textbox (Entry) components.

Project Source Code:
import tkinter as tk
from tkinter import *
from tkinter import ttk
import mysql.connector
root = Tk()
root.title("Search Data By ID")
connection = mysql.connector.connect(host='localhost', user='root', password='',
                                     port='3306', database='test_py')
c = connection.cursor()
bkg = "#dddddd"

frame = tk.Frame(root, bg=bkg)
label_id = tk.Label(frame, text="ID: ", font=('verdana',12), bg=bkg)
entry_id = tk.Entry(frame, font=('verdana',12))
label_firstname = tk.Label(frame, text="First Name: ", font=('verdana',12), bg=bkg)
entry_firstname = tk.Entry(frame, font=('verdana',12))
label_lastname = tk.Label(frame, text="Last Name: ", font=('verdana',12), bg=bkg)
entry_lastname = tk.Entry(frame, font=('verdana',12))
label_email = tk.Label(frame, text="Email: ", font=('verdana',12), bg=bkg)
entry_email = tk.Entry(frame, font=('verdana',12))
label_age = tk.Label(frame, text="Age: ", font=('verdana',12), bg=bkg)
entry_age = tk.Entry(frame, font=('verdana',12))

def searchData():
    # clear fields
    entry_firstname.delete(0,END)
    entry_lastname.delete(0,END)
    entry_email.delete(0,END)
    entry_age.delete(0,END)
    # search
    user_id = entry_id.get()
    search_query = "SELECT * FROM `users_2` WHERE `id` = "+user_id
    c.execute(search_query)
    userdata = c.fetchone()
    entry_firstname.insert(0,userdata[1])
    entry_lastname.insert(0,userdata[2])
    entry_email.insert(0,userdata[3])
    entry_age.insert(0,userdata[4])


button_search = tk.Button(frame, text="Search", font=('verdana',14),fg='#ffffff',
                          bg='orange', command = searchData)
label_id.grid(row=0, column=0, sticky='e')
entry_id.grid(row=0, column=1, pady=10, padx=10)
label_firstname.grid(row=1, column=0)
entry_firstname.grid(row=1, column=1, pady=10, padx=10)
label_lastname.grid(row=2, column=0)
entry_lastname.grid(row=2, column=1, pady=10, padx=10)
label_email.grid(row=3, column=0, sticky='e')
entry_email.grid(row=3, column=1, pady=10, padx=10)
label_age.grid(row=4, column=0, sticky='e')
entry_age.grid(row=4, column=1, pady=10, padx=10)
button_search.grid(row=5,column=0, columnspan=2, pady=10, padx=10, sticky='nsew')
frame.grid(row=0, column=0)

root.mainloop()

// OUTPUT:

---

▶ Download Python Projects Source Code