1 неделю назад
demo32
main import tkinter as tk from tkinter import ttk, messagebox, filedialog import pymysql import os from PIL import Image, ImageTk # --- КОНФИГУРАЦИЯ --- DB_CONFIG = { 'host': 'localhost', 'user': 'root', # ЗАМЕНИТЕ на вашего пользователя MySQL 'password': '12345',# ЗАМЕНИТЕ на ваш пароль MySQL 'database': 'shoe_store_db', 'cursorclass': pymysql.cursors.DictCursor, 'charset': 'utf8mb4' } DEFAULT_IMAGE_PATH = "picture.png" IMAGES_FOLDER = "images" class Database: def __init__(self): self.conn = None self.connect() def connect(self): try: self.conn = pymysql.connect(**DB_CONFIG) except pymysql...
1 неделю назад
ИРСА0000
main import tkinter as tk from tkinter import messagebox import mysql.connector # ---------------- DB ---------------- conn = mysql.connector.connect( host="localhost", user="root", password="12345", database="shop" ) cur = conn.cursor(dictionary=True) # ---------------- SQL ---------------- def login_user(login, password): cur.execute( "SELECT * FROM users WHERE login=%s AND password=%s", (login, password) ) return cur.fetchone() def get_products(): cur.execute("SELECT * FROM products") return cur.fetchall() def search_products(text): cur.execute(""" SELECT * FROM products WHERE name LIKE %s OR category LIKE %s OR supplier LIKE %s """, (f"%{text}%", f"%{text}%", f"%{text}%")) return cur...