Complete GUI Window Application USING Python Tkinter and MySQL – PDF/EPUB Version Downloadable

Complete GUI Window Application Using Python Tkinter and MySQL

We believe that the best way to learn a programming subject is through building a complete real-life application. This is how the idea of this book came out to life. This book is very useful for those who are enthusiastic to develop any business-related project no matter if they are a beginner or knowledgeable in python Tkinter programming. You can use this book also as a reference whenever you develop your own application since our codes cover a wide range of your needs. Most all your needs to develop a real-world GUI (Graphical User Interface) application are presented in this book.

A Public Library Application is used as an example of complete project development. The approach used to code our project is to apply and use whatever necessary Tkinter widgets, their needed methods, and properties as well as using Python to access and manage our MySQL database engine.

We tried our best to write the code in very simple and easy-to-understand commands. We used every possible means to make the programming codes self-explanatory, you will find yourself comfortable going through each piece of code of the application. We employed few data inputs to simplify the code, but you can expand your data using similar codes that are presented in the project.

To achieve our task of creating this GUI application, we will cover in a simple and direct approach the following:

• How to Import the Tkinter built-in libraries and your own work.
• Creating the main GUI and top-level windows and show you how to navigate them
• All windows will contain their own widget classes such as:
  • Label widget to display informative text or images
  • Entry widget, its main purpose is to allow users to type one line data inputs.
  • Users can select one of many choices via the Tkinter Radio button widget.
  • Command Buttons are used to add functionality to the system
  • Labelframe is used as a container to place the related groups of widgets, for example, Radio buttons or groups of labels, buttons, or entry widgets.
  • Combobox displays a list of items from which the user can select one or more multiple item
  • Canvas is introduced to hold graphical objects.
  • OptionMenu is used to create a drop-down menu
  • Display tables using either group of labels and command buttons
  • TreeView widget to display tabulated data.
  • We will show you how to use a handheld scanner to input and retrieve data.

• Inform users about what is being done or executed via importing messagebox module
• Open files using filedialog.
• Using python to access and manage MySQL database engine. This includes:
  
  • Creating database schema.
  • Create database tables.
  • Insert data into tables
  • Update data in tables.
  • Search/query data.
  • How to join tables.

• Finally, we will show you, how to handle reports:
  
  • Using tabulation to direct the reports to IDLE’s Shell.
  • Direct and print the reports from Python to MS Word.
  • Display reports in the web browser.

By the end of going deeply through this book, you will be able to practically create the most real-life GUI applications. It is worth mentioning that, adding more data to your own application does not require adding new ideas but you still can repeat codes and ideas given in this book.