Restaurant Management System V-2 ( Database Integration)

Tkinter Restaurant Management V-1 V-3 Installing Tables Report

Restaurant Management V-2 with MySQL database

Restaurant Management script using Tkinter with product table from MySQL database for backend

The Part -2 of the script should have these added features

  1. Connect to MySQL database and retrieve data based one of the selected category of products.
  2. The products which are available ( available column in table should have value =1 ) only , should be displayed.
  3. While displaying the product, the price of the product should be shown.
  4. Price has to be managed from database table.
  5. On selection of one of the category option ( by radio buttons ) the product ( menu items ) list should change to reflect the selected category.
  6. Based on the number of products returned by database table the rows and columns should adjust itself.
  7. Number of columns in rows should be easily managed at a central place.
from sqlalchemy import create_engine
my_conn = create_engine("mysql+mysqldb://root:pw@localhost/db_name")
MySQL Installing
MySQL Connecting string
MySQL connection using SQLAlchemy

To create product table plus2_products and to insert sample data, use this sql dump.

Restaurant Management V-1 Restaurant Management V-3
More Projects using Tkinter
Subscribe to our YouTube Channel here


* indicates required
Subscribe to plus2net

    Post your comments , suggestion , error , requirements etc here

    Python Video Tutorials
    Python SQLite Video Tutorials
    Python MySQL Video Tutorials
    Python Tkinter Video Tutorials
    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2024 All rights reserved worldwide Privacy Policy Disclaimer