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

This is part two of the total script. In part 3 we will work on the report generation to display data in various forms.
All product with its attributes like price , item name etc are taken from the MySQL table by using query and Label is displayed inside a grid. Spinboxes are added dynamically to select number of items for billing. Here we keep one dictionary to store the product id and the spinbox values . Only when we click the generate bill the final amount is calculated by adding tax and total amount is show.
On click of the Reset button the system will return to normal state where next bill can be generated.

Restaurant management with database integration using Tkinter Version -2
The Part -2 of the script should have these features
Connect to MySQL database and retrieve data based one of the selected category of products.
The products which are available ( available column in table should have value =1 ) only , should be displayed.
While displaying the product, the price of the product should be shown.
Price has to be managed from database table.
On selection of one of the category option ( by radio buttons ) the product ( menu items ) list should change to reflect the selected category.
Based on the number of products returned by database table the rows and columns should adjust itself.
Number of columns in rows should be easily managed at a central place.

Download the source code for all parts from here
https://www.plus2net.com/python/tkinter-restaurant-v-2.php

All parts of Restaurant Management is here

Part I is here
https://youtu.be/fjxhaQ0pm04

Part II : database integration
https://youtu.be/DdJcxqyQ6qQ

Part III : Generating Invoice
https://youtu.be/a3tY3WXj4Ms

Part IV Installation of product table
https://youtu.be/dl13ObWxC9Q

Part V Installation of sale and bill tables
https://youtu.be/sHyyj2nTHC4

Part VI Generating date wise reports
https://youtu.be/nujhZ4MM41Q
In part 3 of this we will add the report generation part
#restaurantManagement #DatabaseIntegration #MySQL #ProjectInPython #DatabaseInPython #plus2net #tkinter #python #ProjectUsingTkinter

Видео Restaurant Management script using Tkinter with product table from MySQL database for backend канала plus2net