Student Registration System with Database Using Python | GUI Tkinter Project - Part 2
HTML-код
- Опубликовано: 16 сен 2024
- In this tutorial, you will learn to create a student registration system with an excel database using python. it is a completely GUI Tkinter project.
It is Part 2 of the Student management system , part 1 link is given below .
This tool is mainly created for a data-saving purpose in python because if we save any registration data in text form it is hard to manage. Even we have to waste too much time, for finding data on a particular person.
So I thought to design this Student registration system/ form using python, it is a completely gui project so easy to handle. And even you can find any data in very basic steps.
Let's See How it went work!
So it is a Student Registration form / Student Database created in python. we will use it to register details of students who come for registration in school or college. It is an advanced registration system using python in which you can save data with a profile image of the student, and even there is the option to search and Update data, which makes it super cool 😎 .
If I talk about databases we have used excel to save our data, so that it is easy to manage and we can easily show it to someone.
There is a few more advanced system that you will absorb in the video.
Main Features!
* Data Saving
* Image Uploading System
* Search System
* Update System
Requirement:
1. Download images:drive.google.c...
-------------------------------------------------------------
Instant Image Approval Link 🤖🤖🤖
Download Images: rzp.io/l/stude...
Notice🚫
It's only for those who need it urgently and I am not available to approve it on google drive. Otherwise, you will 100% get approval for the image within 7-12 hours of approval request for free through the google drive link.
After Completing payment, wait for 5-6 sec folder will automatically download to your system .
---------------------------------------------------------------
2. Modules:
pip install pathlib
pip install openpyxl
pip install xlrd
pip install pillow
🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥
Part1 : • Student Registration S...
🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥
Part3 : • Student Registration S...
🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥
👇👇👇👇👇👇👇👇👇👇👇👇👇👇👇👇👇👇👇👇
You can also visit Database login form using python
Part 1:
How To Create Login Form for Apps Using Python | Tkinter Project
• How To Create Login Fo...
Part 2:
How to Create Signup/ Registration Form with Database Using Python | Tkinter Project #Database
• How to Create Signup/ ...
Part 3:
How to create Login System in python tkinter | GUI Python Project with #database
• How to create Login Sy...
So enjoy, make and share with your friends.🙏🙏🙏🙏🙏
#pythonproject #login #tkinter #pythonprojects #app #excel #tkinterexcel
#pythonexcelsheet #openpyxl #xlrd #datascience
#python #tkinterproject #tkinterpython #signin #dataentry #student #database #project #databasemanagementsystem #studentmanagementsystem
Join this channel to get access to perks:
/ @parvatcomputertechnology
Search Related to:
* How to Create an Excel Data Entry Form Using Python tkinter
* Student Registration System using python | python project
* How to create Registration form using python Tkinter
* how to create excel openpyxl ,xlrd project in python | tkinter project
* Create gui data entry registration form using python tkinter | #guitkinter
* How to save data in excel sheet using python | #parvatcomputertechnology
* How to create data entry registration form using openpyxl ,xlrd | Python tkinter project
* Tkinter Data entry system | Tkinter python project
* How to create gui registration form using python | python tkinter
* Student Management System using python | Tkinter python project
* Image uploading system using python tkinter
* Update data in excel with python tkinter
if you like this tutorial then please show you love by like, share and subscribe.
For always getting such unique projects please support me.
~Parvat Computer Technology
Thank you very much!!! Your videos are awesome! I don't know where you get this cool project ideas but they are soooooooooooooooooooo good.
This has been very educative, thanks so much, I am looking forward to part 3
Glad to see your review 🙂, part 3 will also upload soon .
Bro,in fact i don't know how much to thank you, you are so so and so good.keep it up
finally got to this project , keep learning yall and thanks for sharing
everyone having facing errors , i feel so proud that my code works , so far i was able to solve errors alone
Hi, firstly thanks for your beautiful explanation,secondly,why don't we use classes for this project?
Bro, its verry nice 🤯, i need part 3
Thanks glad to see your comment❤ , 90% chances to upload part -3 on Tuesday😇😇 .
😍😍😍
Thanks
most welcome
While click on save button, after entering all textbox and image also, it is still showing "Profile Piture is not available!!!!!" ERROR.
code :
def Save():
R1 = Registration.get()
N1 = Name.get()
C1 = Class.get()
try:
G1 = gender
except:
messagebox.showerror("error", "Select Gender!")
D2 = DOB.get()
D1 = Date.get()
Re1 = Religion.get()
S1 = Skill.get()
fathername = F_Name.get()
mothername = M_Name.get()
F1 = Father_Occupation.get()
M1 = Mother_Occupation.get()
if N1=="" or C1=="" or D2=="" or Re1=="" or S1=="" or fathername=="" or mothername=="" or F1=="" or M1=="":
messagebox.showerror("Error", "Few Data is missing!")
else:
file=openpyxl.load_workbook('Student_data.xlsx')
sheet = file.active
sheet.cell(column=1, row=sheet.max_row+1, value=R1)
sheet.cell(column=2, row=sheet.max_row, value=N1)
sheet.cell(column=3, row=sheet.max_row, value=C1)
sheet.cell(column=4, row=sheet.max_row, value=G1)
sheet.cell(column=5, row=sheet.max_row, value=D2)
sheet.cell(column=6, row=sheet.max_row, value=D1)
sheet.cell(column=7, row=sheet.max_row, value=Re1)
sheet.cell(column=8, row=sheet.max_row, value=S1)
sheet.cell(column=9, row=sheet.max_row, value=fathername)
sheet.cell(column=10, row=sheet.max_row, value=mothername)
sheet.cell(column=11, row=sheet.max_row, value=F1)
sheet.cell(column=12, row=sheet.max_row, value=M1)
file.save(r'Student_data.xlsx')
try:
img.save("Student Images/"+str(R1)+".png")
except:
messagebox.showinfo("info", "Profile Piture is not available!!!!!")
messagebox.showinfo("info", "Sucessfully data entered!!!!!")
Clear() #clear entry box and image section
registration_no() #it will recheck registration no. and reissue new no.
share your code at my mail i will check
@@parvatcomputertechnology Sorted, Thanks
te coding i entered is correct. but not saving excel please reply
any error !
Sir, the code is running, but it is not connecting to the backend when we enter the data and save it.
any error !
I have error : 'NoneType' object has no attribute 'config'
just because you tried to save one line
No sir
@@daddycool2470 ok send me your code at my mail , i will check
Dear sir, (find the below error)
registration_no()
NameError: name 'registration_no' is not defined
Before you proceed, please check if you have defined the registration number in your code. If not, I would need to check your code because I cannot pinpoint the exact line without looking at it.
Sir please can you solve this error
'module' object is not callable
How to connect it with mysql and store the data
Are you familiar with MySQL?
@@parvatcomputertechnology yes I am
Please where are these data coming from? F_Name M_Name etc for the Clear ... Please I don't understand
these all are coming from entry box
Getting a run time in the function def showimage()
can you send me screenshot of the error
Bro in this program i can’t reset error show name error openpyxl is not defined
install openpyxl
@@parvatcomputertechnology i install it
Reset ho rha h abb magar save nahi ho rha excel ki file se connect nahi kar pa rha wo
@@aatifansari8685 send me your code , at my mail id
@@parvatcomputertechnology bhej fiya
Sir please can I get the source code and do some comparison
you have to create by own .
do u have Github account
yes
Bro give me link of source code 🙏😭
very sorry, you have to create. because the source code is paid.
just try to create , if you face any problem during creation i am here to help
@@parvatcomputertechnology how to use scrollbar mouse scrollbar and physical scrollbar in this form ??
def Clear():
Name.set("")
DOB.set("")
Religion.set("")
Skills.set("")
F_Name.set("")
M_Name.set("")
Father_Occupation.set("")
Mother_Occupation.set("")
Class.set("Select Class")
registration_no()
saveButton.config(state = "normal")
img1=PhotoImage(file="C:\\Users\\hp\\Downloads\\upload photo.png")
lbl.config(image=img1)
lbl.image=img1
img=""
reset button showing error please help me out
what is the problem
I have some error in show image for ex : AttributeError: type object 'Image' has no attribute 'open'
check import and call
@@parvatcomputertechnology yes the problem in the import
@@bluebraintech4168 glad to know it is fixed