1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
|
from tkinter import *
import tkinter as tk
from tkinter import tix, ttk
import mysql.connector
#creation window
window = tk.Tk()
#format window
window.title("Database OpenFoodFact")
window.geometry("950x400")
lst = ["1", "2"]
def __inti__(self):
second_window()
def second_window():
second_window = tk.Toplevel(window, bg = "#FAFAFA")
second_window.geometry("920x400")
labelCategory = tk.Label(second_window, text = "Catégories : ", bg = "#FAFAFA").grid(row=0, column=1)
MYSQL_USER = '***'
MYSQL_HOST = '***'
MYSQL_PWD = '***'
MYSQL_DATABASE = '****'
connexion_data_base = mysql.connector.connect(user=MYSQL_USER, password=MYSQL_PWD, host=MYSQL_HOST, database=MYSQL_DATABASE)
cursor = connexion_data_base.cursor()
cursor.execute(" SELECT category FROM Category")
data = str(cursor.fetchall())
comboExample = ttk.Combobox(second_window, values=data, width=30).grid(row=1, column=1, padx=50, pady=10)
cursor.execute(" SELECT food FROM Food")
food = str(cursor.fetchall())
listbox = Listbox(second_window).grid(row=2, column=2)
for i in range(11):
listbox.insert(food)
cursor.close()
#labelDescription = tk.Label(second_window, text = "Description")
second_window.mainloop()
#creation title
label_title = Label(window, text="Bienvenue dans la base de donnée OpenFoodFacts", font=("Helvetica", 40), fg="#41B77F").pack()
#creation image
width = 300
height = 300
image = PhotoImage(file="/Users/macbookair/Documents/Projet_5/PureBeurre/openfoodfacts-logo-fr-178x150.png")
canvas = Canvas(window, width=width, height=height)
canvas.create_image(width/2, height/2, image=image)
canvas.pack()
#creation button
button_connect = tk.Button(window, text="Trouver un aliment à remplacer", command=second_window).pack(side=LEFT, padx = 100)
button_connect2 = tk.Button(window, text="Retrouver mes aliments substitués").pack(side=RIGHT, padx = 100)
# print window
window.mainloop() |
Partager