Student Database project with frontend PAGE and backend MySQL | How to connect to DB in python

In this tutorial, I will show you how to develop a sample student database project with front end made in pycharm using PAGE GUI builder and back end MySQL.
#python #page #mysql #studentdatabase
Its a simple project that will help you to make database connectivity in python.

Please subscribe to my youtube channel for such tutorials

Please watch the split a file by line number here:

Split utility in Linux/Unix : to break huge file into small pieces

How to keep sessions alive in terminal/putty infinitely in linux/unix : Useful tips

Random value generator and shuffling in python

Intro to class in python

Lists, tuples, dictionary in python

Python basic tutorial for beginners

Python basics tutorial for beginners part 2 -variables in python

Vi editor basic to advance part 1

Vi editor basic to advance part 2

Keyboard remapping in linux, switching keys as per your own choice

How to install/open an on sceen keyboard in Linux/Unix system

Python IDE for windows , linux and mac OS

How to record screen or sessions in Linux/Unix

How to download and install PAGE GUI builder for python

Create a basic Login page in python using GUI builder PAGE

Working with RadioButton in python in PAGE builder

Basic program on Multithreading in python using thread module

[doseofreality]

This is perfect, ticks all the boxes needed for me to get an A* in my computer science coursework - thanks!

[SJoe]

I needed to make some adaptations in order to use dbConnect.dbConnect.DBConnect because db_connect don't seem to exist anymore. Also for using python 3.7 but... success! Thanks a lot for your hard work and great contribution!!
As you asked:
def modifyStudent(self):
name = self.txtName.get('1.0', 'end-1c')
roll = self.txtRoll.get('1.0', 'end-1c')
marks = self.txtMarks.get('1.0', 'end-1c')
age = self.spinAge.get()
sex = self.sex
comando = "UPDATE student SET stud_name='" + name + "', marks=" + marks + ", age=" + age + ", sex='" + sex + "' WHERE roll=" + roll
# tkinter.messagebox.showinfo('String:', comando) #uncomment the start of this line to see the command string (debug)
try:

self.conexao.commit()
except Exception:
tkinter.messagebox.showerror('Erro', 'Erro ao atualizar objeto.')
# Error updating object.
exit(66)
tkinter.messagebox.showinfo('Sucesso', 'Sucesso ao atualizar objeto de roll#: ' + roll)
# Success updating object of roll# roll
self.showdetails()

[TechnicalLabIT]

hi all, those who are facing problem in importing module name, please use dbConnect. module name may differ depending on python versions.

[sharada]

Rightly speaking, i still didn't get the output but now I have learnt basics of tkinter and what I wanted was the function to use behind the queries update and delete so this video is still very useful in that U have explained it well thanks😊😊😊

[guitarec]

you used "dbresponse" from db_connect module to store the details of 'select * from...' query.
I am using mysql.connector module in substitution for db_connect, in this case what should I substitute in place of dbresponse.
I cannot see the output in the list box of my gui as it did in your part at 29:33

[FahadAkash]

i am using frame when i store the variabl from entry it's error me :-( variable not found help me

[muhammadammar]

I had an error.
When i click on 'generate support module' and save it and when i click on run button it shows me a message 'No python command has been specified'.
What is this error and how to solve it.

[traeht]

Thank you for in depth explanation! Very useful instruction.

[techieguy]

when i click on generate python gui, it shows an error message(invalid command name:try), plz help me out?

[AncientWizard]

Where do i enter the pip install db_connect commandson a windows system

[aarzoo]

Sir am not getting output...plzz help. Its giving error as can't read "vTcl(gui_output_window)": no such elem

[melwinsam]

Sir I want to do mini project on frontend html css backend MySQL python

[yashirajput]

I am getting an error can't read "vTcl(py_initfunc)": no such element in
Kindly help me in this.

[vishaltanawade]

When I run generate python gui it shows No output...

as you did in video at 13:40

[killerinstinct]

Sir i am running Python 3.7, i am not able to use db_connect, what can be the alternative and whats the code for the importing of mysql as i am not able to find the right connector.
Thank You

[SJoe]

Also works with psycopg2 in python 3.7.2

[MuhammadBilal-svhs]

I am using vs code instead of pycharm, can you please tell me how can i create path of vs code in PAGE GUI generator
i.e what is the location i add at IDE command

i add the path of VS code but it is showing error as couldn't execute "C:\Users\project\Desktop\
i saw many videos could not find the solution
Please tell me brother....

[shubhamkakkar]

Sir can you please tell how to connect MySQL and where to connect. db_connect is not working for me. Kindly help me with this problem

[francheskafarr]

can I just use a plain text insted of pycharm and page gui builder?

[scott]

When you deleted 4563 student it didn't clear out primary key field after. It left 4563 in the Roll No. entry field. You should have another commnd clear out values after delete call, yes ?