Hey, i have some problems with my tkinter formular maybe someone can help me with that.
from tkinter import *
import mysql.connector
providerlist = ["FIVE","BLAU","KLAR","BASE"]
mydb = mysql.connector.connect(
host="localhost",
user="root",
passwd="",
database="db",
)
#print(mydb)
def load():
print(provider)
mycursor = mydb.cursor()
sql = "INSERT INTO tbl_prepaid(handynummer, provider, euro) VALUES ( "' + str(handynummer.get()) + '","' + providerlist[provider.get()] + '", "' + str(euro.get()) + '" ) "
print(sql)
mycursor.execute(sql)
mydb.commit()
root = Tk()
Label(root, text="Nummer").grid(row=0)
Label(root, text="Wiederholen").grid(row=1)
e1 = Entry(root)
e2 = Entry(root)
e1.grid(row=0, column=1)
e2.grid(row=1, column=1)
v = IntVar()
w = IntVar()
Label(root,
text="""Wählen sie einen Provider:""",
justify = LEFT,
padx = 20).grid(row=2)
Radiobutton(root,
text="FIVE",
variable=v,
value=1).grid(row=3)
Radiobutton(root,
text="BLAU",
padx = 20,
variable=v,
value=2).grid(row=4)
Radiobutton(root,
text="KLAR",
variable=v,
value=3).grid(row=5)
Radiobutton(root,
text="BASE",
variable=v,
value=4).grid(row=6)
Radiobutton(root,
text="5",
variable=w,
value=5).grid(row=3, column=2)
Radiobutton(root,
text="10",
variable=w,
value=6).grid(row=4, column=2)
Radiobutton(root,
text="15",
variable=w,
value=7).grid(row=5, column=2)
Button(root, text="Abschicken", command=load ).grid(row=6, column=2)
mainloop()
this is how far i came
thank you for trying to help!