listbox displaying tables from database in tkinter

Question

Is there a way to display data taken from my database in terms of table and that i can actually copy the individual contents of? using listbox and scrollbar currently i defined a function logs and gave looped thru it like this :

def logs():
    log = Toplevel(root)
    log.title('View all customers')
    con = mysql.connect(host='localhost', user='root',
                            password='*****', database='BOOK')
    c = con.cursor()

    c.execute("SELECT * FROM library")
    result = c.fetchall()

    for index, x in enumerate(result):
        num = 0
        for y in x:
            lookup_label = Label(log, text=y)
            lookup_label.grid(row=index+1, column=num)
            num +=1
    l1 = Label(log,text='ID',font=font_text)
    l2 = Label(log,text='S_ID',font=font_text)
    l3 = Label(log,text='S_NAME',font=font_text)
    l4 = Label(log,text='B_NAME',font=font_text)
    l5 = Label(log,text='Date Taken',font=font_text)
    l6 = Label(log,text='Date_Returned',font=font_text)
    l7 = Label(log,text='Status',font=font_text)
    btn_ext = Button(log,text='Exit',font=font_text,command=log.destroy,borderwidth=2,fg='#eb4d4b')
    l1.grid(row=0,column=0,padx=20)
    l2.grid(row=0,column=1,padx=20)
    l3.grid(row=0,column=2,padx=20)
    l4.grid(row=0,column=3,padx=20)
    l5.grid(row=0,column=4,padx=20)
    l6.grid(row=0,column=5,padx=20)
    l7.grid(row=0,column=6,padx=20)
    btn_ext.grid(row=index+2,columnspan=7,ipadx=540)

is there any alternatives to this if not listbox? to make tables? Thanks in advance :)

You can use ttk.Treeview.

acw1668
– acw1668

2020-05-12 04:31:42 +00:00
Commented May 12, 2020 at 4:31 — acw1668
– acw1668, Commented May 12, 2020 at 4:31
how do i pack my data from db into it?

Delrius Euphoria
– Delrius Euphoria

2020-05-12 04:52:25 +00:00
Commented May 12, 2020 at 4:52 — Delrius Euphoria
– Delrius Euphoria, Commented May 12, 2020 at 4:52
Use insert().

acw1668
– acw1668

2020-05-12 04:56:06 +00:00
Commented May 12, 2020 at 4:56 — acw1668
– acw1668, Commented May 12, 2020 at 4:56

acw1668 · Accepted Answer · 2020-05-12 05:53:24Z

2

You can use ttk.Treeview to show data from database:

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

def logs():
    log = tk.Toplevel(root)
    log.transient(root)
    log.title('View all customers')

    # setup treeview
    columns = ('ID', 'S_ID', 'S_NAME', 'B_NAME', 'Date_Taken', 'Date_Returned', 'Status')
    tree = ttk.Treeview(log, height=20, columns=columns, show='headings')
    tree.grid(row=0, column=0, sticky='news')

    # setup columns attributes
    for col in columns:
        tree.heading(col, text=col)
        tree.column(col, width=100, anchor=tk.CENTER)

    # fetch data
    con = mysql.connect(host='localhost', user='root', password='******', database='BOOK')
    c = con.cursor()
    c.execute('SELECT * FROM library')

    # populate data to treeview
    for rec in c:
        tree.insert('', 'end', value=rec)

    # scrollbar
    sb = tk.Scrollbar(log, orient=tk.VERTICAL, command=tree.yview)
    sb.grid(row=0, column=1, sticky='ns')
    tree.config(yscrollcommand=sb.set)

    btn = tk.Button(log, text='Exit', command=log.destroy, width=20, bd=2, fg='#eb4d4b')
    btn.grid(row=1, column=0, columnspan=2)

edited May 12, 2020 at 5:53

answered May 12, 2020 at 5:33

acw1668

48k5 gold badges30 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Delrius Euphoria Over a year ago

AttributeError: module 'tkinter.ttk' has no attribute 'BOTH' im getting dis error here, any idea?

acw1668 Over a year ago

Updated answer using import tkinter as tk instead of from tkinter import *.

Delrius Euphoria Over a year ago

works like a charm thanks :) is there a way to copy wahts inside this rows? add a scrollbar?

acw1668 Over a year ago

Updated answer with scrollbar. You can get the values of selected item by using tree.item(tree.focus())['values'].

acw1668 Over a year ago

tree.item(..) returns a dictionary of information for the current selected item. values is the key to get the item values from the dictionary. Detail information can refer to ttk.Treeview.

|

Collectives™ on Stack Overflow

listbox displaying tables from database in tkinter

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related