This project is made using two parts.
First : coding for making tables in mysql server.
Second : coding for using project interface.
Software Requirements
Mysql server : mysql server must be installed in computer. It will be used for accessing data of project. Tables will be made in server in which data will be stored.
Python idle : python idle must be installed in computer. It will be used for executing python scripts.
Mysql.connector : it will connect python idle with mysql server. To install it open cmd and write pip install mysql.connector
MySQL
In user and passwd, put your mysql server username and password.
import mysql.connector as a
con = a.connect(host="localhost",
user="root",
passwd="")
c = con.cursor()
sql1 = "create database school1"
c.execute(sql1)
sql2 = "use school1"
c.execute(sql2)
sql3 = "create table cattendance (date varchar(10),class varchar(5), absent varchar(500))"
c.execute(sql3)
sql4 = "create table fees (name varchar(50),class varchar(5), roll varchar(5), month varchar(10) , fees varchar(10) , date varchar(10))"
c.execute(sql4)
sql5 = "create table salary (name varchar(50), month varchar(10), paid varchar(5))"
c.execute(sql5)
sql6 = "create table student (name varchar(50), class varchar(5), roll varchar(5), address varchar(50), ph varchar(10))"
c.execute(sql6)
sql7 = "create table tattendance (date varchar(10), absent varchar(500))"
c.execute(sql7)
sql8 = "create table teacher (name varchar(50), class varchar(5), roll varchar(5), address varchar(50), ph varchar(10), acno varchar(20))"
c.execute(sql8)
con.commit()
Python
After executing the python script the password for opening the interface is ilovepy.
import mysql.connector as a
con = a.connect(host="localhost",user="root",passwd="",database="school1")
def ast():
n = input("Student Name : ")
c = input("Class Name : ")
r = input("Roll No : ")
a = input("Address : ")
p = input("Phone : ")
data = (n,c,r,a,p)
sql = 'insert into student values(%s,%s,%s,%s,%s)'
c = con.cursor()
c.execute(sql,data)
con.commit()
print("Data Entered Successfully")
print(">--------------------------------------------------------------------------------------------------------<")
main()
def rst():
c = input("Class Name : ")
r = input("Roll No : ")
data = (c,r)
sql = 'delete from student where CLASS = %s and ROLL = %s'
c = con.cursor()
c.execute(sql,data)
con.commit()
print("Data Updated")
print(">--------------------------------------------------------------------------------------------------------<")
main()
def addt():
n = input("Teacher : ")
p = input("Post : ")
s = input("Salary : ")
a = input("Address : ")
ph = input("Phone : ")
ac = input("Account : ")
data = (n,p,s,a,ph,ac)
sql = 'insert into teacher values(%s,%s,%s,%s,%s,%s)'
c = con.cursor()
c.execute(sql,data)
con.commit()
print("Data Entered Successfully")
print(">--------------------------------------------------------------------------------------------------------<")
main()
def remt():
n = input("Teacher Name : ")
ac = input("Account No : ")
data = (n,ac)
sql = 'delete from teacher where name = %s and acno = %s'
c = con.cursor()
c.execute(sql,data)
con.commit()
print("Data Updated")
print(">--------------------------------------------------------------------------------------------------------<")
main()
def abclass():
d = input("Date : ")
cl = input("Class : ")
ab = input("Names of Absent Students : ")
data = (d,cl,ab)
sql = "insert into cattendance values(%s,%s,%s)"
c = con.cursor()
c.execute(sql,data)
con.commit()
print("Data Updated")
print(">--------------------------------------------------------------------------------------------------------<")
main()
def abteacher():
d = input("Date : ")
ab = input("Names of Absent Teacher : ")
data = (d,ab)
sql = "insert into tattendance values(%s,%s)"
c = con.cursor()
c.execute(sql,data)
con.commit()
print("Data Updated")
print(">--------------------------------------------------------------------------------------------------------<")
main()
def submitf():
n = input("Student Name : ")
c = input("Class Name : ")
r = input("Roll No : ")
m = input("Month and Year : ")
f = input("Fees : ")
d = input("Date : ")
data = (n,c,r,m,f,d)
sql = 'insert into fees values(%s,%s,%s,%s,%s,%s)'
c = con.cursor()
c.execute(sql,data)
con.commit()
print("Data Entered Successfully")
print(">--------------------------------------------------------------------------------------------------------<")
main()
def pays():
n = input("Teacher Name : ")
m = input("Month : ")
p = input("Yes / No : ")
data = (n,m,p)
sql = 'insert into salary values(%s,%s,%s)'
c = con.cursor()
c.execute(sql,data)
con.commit()
print("Data Entered Successfully")
print(">--------------------------------------------------------------------------------------------------------<")
main()
def dclass():
cl = input("Class : ")
data = (cl,)
sql = "select * from student where class = %s"
c = con.cursor()
c.execute(sql,data)
d = c.fetchall() # [(6,6,5,6,8),(6,5,6,5,1),(5,4,7,6)]
for i in d:
print("NAME : ",i[0])
print("CLASS : ",i[1])
print("ROLL : ",i[2])
print("ADDRESS : ",i[3])
print("PHONE : ",i[4])
print(">--------------------------------------<")
print(">--------------------------------------------------------------------------------------------------------<")
main()
def dteacher():
sql = "select * from teacher"
c = con.cursor()
c.execute(sql)
d = c.fetchall()
for i in d:
print("NAME : ",i[0])
print("POST : ",i[1])
print("SALARY : ",i[2])
print("ADDRESS : ",i[3])
print("PHONE : ",i[4])
print("ACNO : ",i[5])
print(">--------------------------------------<")
print(">--------------------------------------------------------------------------------------------------------<")
main()
def main():
print(""" GIRRAJ INTERNATIONAL SCHOOL
1. ADD STUDENT 2. REMOVE STUDENT
3. ADD TEACHER 4. REMOVE TEACHER
5. CLASS ATTENDANCE 6. TEACHER ATTENDANCE
7. SUBMIT FEES 8. PAY SALARY
9. DISPLAY CLASS 10. TEACHERS LIST
""")
choice = input("Enter Task No : ")
print(">--------------------------------------<")
if (choice == '1'):
ast()
elif (choice=='2'):
rst()
elif (choice=='3'):
addt()
elif (choice=='4'):
remt()
elif (choice=='5'):
abclass()
elif (choice == '6'):
abteacher()
elif (choice=='7'):
submitf()
elif (choice == '8'):
pays()
elif (choice == '9'):
dclass()
elif (choice == '10'):
dteacher()
else:
print(" Wrong choice..........")
main()
def pswd():
p = input("Password : ")
if p == "ilovepy":
main()
else:
print("Wrong Password ")
pswd()
pswd()
Educational Use Notice
This project is provided strictly for educational and learning purposes. Students are encouraged to study the code, understand the concepts, and use it as a reference for building their own original projects. Users are expected to modify, improve, and create their own implementations based on their understanding. By accessing this project, you agree to use it ethically and in accordance with your institution’s academic integrity policies.
