from tkinter import *
from tkinter.ttk import *
from tkinter import messagebox
from tkinter import scrolledtext

window = Tk()

window.title("Ambrozi's Control Panel")
lbl = Label(window, text="Ambrozi's Control Panel", font=("Arial Bold", 8, ))
lbl.grid(column=0, row=0)
window.geometry("1020x400")



import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(host='89.203.250.200',
                                         database='Ambrozi_Testing_Python',
                                         user='root',
                                         password='Pejsek123+')

    sql_select_Query = "select * from TeamMembers"
    cursor = connection.cursor()
    cursor.execute(sql_select_Query)
    records = cursor.fetchall()
    print("Totalní počet řádku v TeamMembers: ", cursor.rowcount)

    print("\nVýpis Memberu")
    for row in records:
        print("ID = ", row[0], )
        print("Nick = ", row[1])
        print("UUID  = ", row[2])
        print("Position  = ", row[3])
        print("IsOnline  = ", row[4])
        print("Password  = ", row[5], "\n")

except Error as e:
    print("Error reading data from MySQL table", e)
finally:
    if (connection.is_connected()):
        connection.close()
        cursor.close()
        print("MySQL connection is closed")

def clicked():
    res = "pejsek " + records.get()
btn = Button(window, text="Read", command=clicked)
btn.grid(column=3, row=3)

window.mainloop()