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
www.plus2net.c...
All parts of Restaurant Management is here
Part I is here
• Restaurant Management ...
Part II : database integration
• Restaurant Management ...
Part III : Generating Invoice
• Tkinter Storing produc...
Part IV Installation of product table
• Creating MySQL product...
Part V Installation of sale and bill tables
• Bills & sale table ins...
Part VI Generating date wise reports
• Reports from Bills and...
In part 3 of this we will add the report generation part
#restaurantManagement #DatabaseIntegration #MySQL #ProjectInPython #DatabaseInPython #plus2net #tkinter #python #ProjectUsingTkinter

[@maneeshreddy7088]

Requirement: If we choose one from the drop-down and for that element can we add particular frame and other elements in it like textbox?

[@plus2net1]

It is not clear but dynamically widgets can be added. What is going to be added can be decided from drop down. Check here how Spinbox is dynamically added. kzbin.info/www/bejne/nnWQnKtrdqqdr6s

[@maneeshreddy7088]

@@plus2net1 Ex: If there's a drop-down and in that there are two different elements. If you choose 1st element then two text boxes should appear and if we select 2nd element then 3 textboxes should appear....Is it possible?

[@plus2net1]

@@maneeshreddy7088 Yes, Read the drop-down selected value and using one if condition check add two text boxes and in elif block keep three text boxes.

[@plus2net1]

@@maneeshreddy7088 kzbin.info/www/bejne/qKutaZaKhrB9q7s Source code here www.plus2net.com/python/tkinter-text-combobox.php

[@hrmnde3p]

can we make editable tree view in tkinter ?

[@plus2net1]

Yes, Check here www.plus2net.com/python/tkinter-treeview.php