Python Pyqt5 Database Programming with MySql in Qt Designer

About Python Pyqt5 Database Programming with MySql in Qt Designer

Hello students,

Thank you very much

for showing interest in this course

Python Pyqt5 Database Programming with MySql in Qt Designer

. This course is going to be very useful for the students

who want to create to develop a complete software application using python pyqt5 and mysql server

as back end. Python pyqt5 is a moden

GUI development library

. We can develop a lot of GUI Applications using python pyqt5. If we want to develop GUI based application software, we require a database to store our datas.

Mysql server is one of the most used database server in the world

. It is very important to store our customer and companies data in a secured way. So using mysql server to store our data is very important in software development. In this course you are going learn the following concepts

Software installation

1. How to

install python latest version

2.

Install Pyqt5

through pip 3.

Install Pyqt5 Tools

through pip 4.

Configure Qt Designer

5. Install

Xampp server

for

Mysql

6. Install

mysql connector

7. Install

Python program Editor

Mysql Database creation through Python PyQt5 using Qt Designer

We will

design a form in Qt Designer that contains a Line edit and a Push Button

. After enter the database name we want to create in the line edit, If we click the push button, the

database will be created in the mysql server

. We can check the mysql server by opening the in the web browser. Initially we have to start the mysql server and apache server from the xampp control panel.

Mysql Database deletion through Python PyQt5 using Qt Designer

We will

design a form in Qt Designer that contains a Line edit and a Push Button

. After enter the database name we want to delete in the line edit, If we click the push button,

the database will be deleted or dropped in the mysql server

. We can check the mysql server by opening the in the web browser. Initially we have to start the mysql server and apache server from the xampp control panel.

Insert into mysql database table through Python PyQt5 using Qt Designer

We will

design a form in Qt Designer that contains input for name, address, phone and email

. After fill all the details in the Pyqt5 Gui form, If we click the push button, the

the entered details will be inserted in the mysql server database table.

We can check the mysql server by opening the in the web browser.

Update the data in mysql database table through Python PyQt5 using Qt Designer

We will

design a form in Qt Designer that contains combobox filled with all email id in the mysql database table

. We use email id as unique field because each persons email id will be unique.

When we select a email id from the combo box, the name, address, phone number will be filled in the corresponding input controls

. After we made the required changes,

if we click the push button, the modified details will be updated in the mysql database table

for the selected email id. We can chech the updates in the mysql server database.

Delete the data in mysql database table through Python PyQt5 using Qt Designer

We will

design a form in Qt Designer that contains combobox filled with all email id in the mysql database table

. We use email id as unique field because each persons email id will be unique. When we select a email id from the combo box and

if we click the push button, the details in the complete row will be deleted in the mysql database table

for the selected email id. We can chech the deleted in the mysql server database.

Display the data from mysql database table in the Python PyQt5 using Qt Designer Table widget

We will

design a form in Qt Designer that contains QTable Widget filled with all data in the mysql database table

. The program will collect all the data from the mysql database table and save it in to an array. Then the data will be added to qtable widget in rows and columns. This

course will be very useful for the students who want to learn how to develop a GUI application using python

pyqt5 GUI development library using mysql database.

I welcome you

all to join this course and

get a strong knowledge in the mysql database programming

using python pyqt5 library

Thank you very much

.. I will see you in the course.....