Hospital Management System

Python Project

Software requirements
Operating system : windows 10

Python 3 : for execution of program

Mysql : for storing data in the database

Python – mysql connector : for database connectivity

##hospital management software @cbsepython.in

##PRINTING WELCOME NOTE
while(True):
print("""
================================
WELCOME TO MYHOSPITAL
================================
""")
##creating database connectivity
import mysql.connector
passwd=str(input("ENTER THE DATABASE PASSWORD;"))

mysql=mysql.connector.connect(host="localhost",user="root",passwd="admin")
mycursor=mysql.cursor()
#creating database
mycursor.execute("create database if not exists my_hospitals")
mycursor.execute("use my_hospitals")
#creating the tables we need
 mycursor.execute("create table if not exists patient_details(puid int(10) primary
key,name varchar(30) not null,age int(3),address varchar(50),doctor_recommended
varchar(30))")
mycursor.execute("create table if not exists doctor_details(name varchar(30) primary
key,specialisation varchar(40),age int(2),address varchar(30),contact varchar(15),fees
int(10),monthly_salary int(10))")
mycursor.execute("create table if not exists nurse_details(name varchar(30) primary
key,age int(2),address varchar(30),contact varchar(15),monthly_salary int(10))")
mycursor.execute("create table if not exists other_workers_details(name varchar(30)
primary key,age int(2),address varchar(30),contact varchar(15),monthly_salary int(10))")
#login or signup option
#creating table for storing the username and password of the user
mycursor.execute("create table if not exists user_data(username varchar(30) primary
key,password varchar(30) default'000')")
#printing option
while(True):
print("""
1. SIGN IN (LOGIN)
2. SIGN UP (REGISTER)
""")

r=int(input("enter your choice:"))

#IF USER WANTS TO REGISTER

if r==2:
print("""
=======================================
!!!!!!!PLEASE REGISTER YOURSELF!!!!!!!!
=======================================
""")
u=input("ENTER YOUR PREFERRED USERNAME!!:")
 p=input("ENTER YOUR PREFERRED PASSWORD (PASSWORD SHOULD BE
STRONG!!!:")
#ENTERING THE ENTERED VALUE TO THE USER_DATA TABLE
mycursor.execute("insert into user_data values('"+u+"','"+p+"')")
mysql.commit()

print("""
=======================================
!!!!!!!!REGISTERED SUCCESSFULLY!!!!!!!!
=======================================
""")
x=input("enter any key to continue:")
#IF USER WANTS TO LOGIN
elif r==1:

#PRINTING THE SINGIN OPTION AGAIN TO THE USER AFTER REGISTRATION

print("""
==================================
!!!!!!!! {{SIGN IN }} !!!!!!!!!!
==================================
""")
un=input("ENTER THE USERNAME!!:")
ps=input("ENTER THE PASSWORD!!:")

mycursor.execute("select password from user_data where username='"+un+"'")

row=mycursor.fetchall()
for i in row:
a=list(i)
if a[0]==str(ps):
while(True):
##displaying the task you can perform
print("""
1.ADMINISTRATION
 2.PATIENT (ADMISSION NAD DISCHARGE PROCESS)
3.SIGN OUT

""")

##asking for the task from user

a=int(input("ENTER YOUR CHOICE:"))
#if user wants to enter administration option
if a==1:
print("""
1. SHOW DETAILS
2. ADD NEW MEMBER
3. DELETE EXISTING ONE
4. EXIT
""")
b=int(input("ENTER YOUR CHOICE:"))
#showing the existing details
if b==1:
print("""
1. DOCTOR DETAILS
2. NURSE DETAILS
3. OTHER WORKERS
""")

#ASKING USER'S CHOICE

c=int(input("ENTER YOUR CHOICE:"))
#if user wants to see the details of doctors
if c==1:
mycursor.execute("select * from doctor_details")
row=mycursor.fetchall()
for i in row:
b=0
v=list(i)
k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","FEES","MONTHLY_SALARY"
]
d=dict(zip(k,v))
print(d)
#if user wants to see the details of nurses
elif c==2:
mycursor.execute("select * from nurse_details")
row=mycursor.fetchall()
for i in row:
v=list(i)

k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","MONTHLY_SALARY"]
d=dict(zip(k,v))
print(d)
#if user wants to see the details of other_workers
elif c==3:
mycursor.execute("select * from other_workers_details")
row=mycursor.fetchall()
for i in row:
v=list(i)

k=["NAME","SPECIALISATION","AGE","ADDRESS","CONTACT","MONTHLY_SALARY"]
d=dict(zip(k,v))
print(d)
#IF USER WANTS TO ENTER DETAILS
elif b==2:
print("""
1. DOCTOR DETAILS
2. NURSE DETAILS
3. OTHER WORKERS
""")
c=int(input("ENTER YOUR CHOICE:"))
#FOR ENTERING DETAILS OF DOCTORS
 if c==1:
#ASKING THE DETAILS
name=input("ENTER DR. NAME:")
spe=input("ENTER SPECIALISATION:")
age=input("ENTER AGE:")
add=input("ENTER ADDRESS:")
cont=input("ENTER CONTACT NO.:")
fees=input("ENTER FEES:")
ms=input("ENTER MONTHLY_SALARY:")
#INSERTING VALUES ENTERED INTO THE DOCTORS_TABLE
mycursor.execute("insert into doctor_details
values('"+name+"','"+spe+"','"+age+"','"+add+"','"+cont+"','"+fees+"','"+ms+"')")
mysql.commit()
print("SUCCESSFULLY ADDED")
#for entering nurse details
elif c==2:
#ASKING THE DETAILS
name=input("ENTER NURSE NAME:")
age=input("ENTER AGE:")
add=input("ENTER ADDRESS:")
cont=input("ENTER CONTACT NO.:")
ms=int(input("ENTER MONTHLY_SALARY:"))
#INSERTING VALUES ENTERED TO THE TABLE
mycursor.execute("insert into nurse_details
values('"+name+"','"+age+"','"+add+"','"+cont+"','"+str(ms)+"')")
mysql.commit()
print("SUCCESSFULLY ADDED")
#for entering workers details
elif c==3:
#ASKING THE DETAILS
name=input("ENTER WORKER NAME:")
age=input("ENTER AGE:")
add=input("ENTER ADDRESS:")
cont=input("ENTER CONTACT NO.:")
 ms=input("ENTER MONTHLY_SALARY:")
#INSERTING VALUES ENTERED TO THE TABLE
mycursor.execute("insert into other_workers_details
values('"+name+"','"+age+"','"+add+"','"+cont+"','"+ms+"')")
mysql.commit()
print("SUCCESSFULLY ADDED")
#if unser wants to delete data
elif b==3:
print("""
1. DOCTOR DETAILS
2. NURSE DETAILS
3. OTHER WORKERS
""")
c=int(input("ENTER YOUR CHOICE:"))
#deleting doctor's details
if c==1:
name=input("ENTER DOCTOR'S NAME:")
mycursor.execute("select * from doctor_details where
name=='"+name+"'")
row=mycursor.fetchall()
print(row)
p=input("you really wanna delete this data? (y/n):")
if p=="y":
mycursor.execute("delete from doctor_details where
name='"+name+"'")
mysql.commit()
print("SUCCESSFULLY DELETED!!")
else:
print("NOT DELETED")

#deleting nurse details

elif c==2:
name=input("ENTER NURSE NAME:")
 mycursor.execute("select * nurse_details where name=='"+name+"'")
row=mycursor.fetchall()
print(row)
p=input("you really wanna delete this data? (y/n):")
if p=="y":
mycursor.execute("delete from nurse_details where
name='"+name+"'")
mysql.commit()
print("SUCCESSFULLY DELETED!!")
else:
print("NOT DELETED")
#deleting other_workers details
elif c==3:
name=input("ENTER THE WORKER NAME:")
mycursor.execute("select * from workers_details where
name=='"+name+"'")
row=mycursor.fetchall()
print(row)
p=input("you really wanna delete this data? (y/n):")
if p=="y":
mycursor.execute("delete from other_workers_details where
name='"+name+"'")
mysql.commit()
print("SUCCESSFULLY DELETED!!")
else:
print("NOT DELETED")
elif b==4:
break

#entering the patient details table

elif a==2:

print("""
1. SHOW PATIENT DETAILS
 2. ADD NEW PATIENT
3. DISCHARGE PATIENT
4. EXIT
""")
b=int(input("ENTER YOUR CHOICE:"))
#showing the existing details
#if user wants to see the details of PATIENT
if b==1:
mycursor.execute("select * from patient_details")
row=mycursor.fetchall()
for i in row:
b=0
v=list(i)
k=["NAME","SEX","AGE","ADDRESS","CONTACT"]
d=dict(zip(k,v))
print(d)

#adding new patient

elif b==2:
name=str(input("ENTER NAME: "))
sex=str(input("ENTER SEX: "))
age=str(input("ENTER AGE: "))
address=str(input("ADDRESS: "))
contact=str(input("CONTACT NUMBER: "))
mycursor.execute ("insert into patient_details
values('"+str(name)+"','"+str(sex)+"','"+str(age)+"','"+str(address)+"','"+str(contact)+"')")
mysql.commit()
mycursor.execute("select * from patient_details")
for i in mycursor:
v=list(i)
k=['NAME','SEX','AGE','ADDRESS','CONTACT']
print(dict(zip(k,v)))
print("""
====================================
 !!!!!!!REGISTERED SUCCESSFULLY!!!!!!
====================================
""")
#dischare process
elif b==3:
name=input("ENTER THE PATIENT NAME:")
mycursor.execute("select * from patient_details where
name='"+name+"'")
row=mycursor.fetchall()
print(row)
bill=input("HAS HE PAID ALL THE BILLS ? (y/n):")
if bill=="y":
mycursor.execute("delete from patient_details where
name='"+name+"'")
mysql.commit()
#if user wants to exit
elif b==4:
break
###SIGN OUT
elif a==3:
break

#IF THE USERNAME AND PASSWORD IS NOT IN THE DATABASE

else:
break

Output:

================================

WELCOME TO MYHOSPITAL

================================
ENTER THE DATABASE PASSWORD;"admin"

1. SIGN IN (LOGIN)

2. SIGN UP (REGISTER)

enter your choice:2

=======================================

!!!!!!!PLEASE REGISTER YOURSELF!!!!!!!!

=======================================

ENTER YOUR PREFERRED USERNAME!!:"cbse"

ENTER YOUR PREFERRED PASSWORD (PASSWORD SHOULD BE STRONG!!!:"cbse@123"

=======================================

!!!!!!!!REGISTERED SUCCESSFULLY!!!!!!!!

=======================================

enter any key to continue:

1. SIGN IN (LOGIN)

2. SIGN UP (REGISTER)

enter your choice:1

==================================

!!!!!!!! {{SIGN IN }} !!!!!!!!!!

==================================

ENTER THE USERNAME!!:"cbse"

ENTER THE PASSWORD!!:"cbse@123"

1.ADMINISTRATION
2.PATIENT (ADMISSION NAD DISCHARGE PROCESS)

3.SIGN OUT

ENTER YOUR CHOICE:1

1. SHOW DETAILS

2. ADD NEW MEMBER

3. DELETE EXISTING ONE

4. EXIT

ENTER YOUR CHOICE:2

1. DOCTOR DETAILS

2. NURSE DETAILS

3. OTHER WORKERS
ENTER YOUR CHOICE:1

ENTER DR. NAME:"Dr. Rohit Sharma"

ENTER SPECIALISATION:"Physician"

ENTER AGE:34

ENTER ADDRESS:"Mumbai"

ENTER CONTACT NO.:1234512345

ENTER FEES:450

ENTER MONTHLY_SALARY:550000

SUCCESSFULLY ADDED

1.ADMINISTRATION

2.PATIENT (ADMISSION NAD DISCHARGE PROCESS)

3.SIGN OUT

ENTER YOUR CHOICE:1

1. SHOW DETAILS
2. ADD NEW MEMBER

3. DELETE EXISTING ONE

4. EXIT

ENTER YOUR CHOICE:1

1. DOCTOR DETAILS

2. NURSE DETAILS

3. OTHER WORKERS

ENTER YOUR CHOICE:1

{'NAME': '"Dr. Rohit Sharma"', 'SPECIALISATION': '"Physician"', 'AGE': 34,

'ADDRESS': '"Mumbai"', 'CONTACT': '1234512345', 'FEES': 450, 'MONTHLY_SALARY':
550000}

{'NAME': 'rajkumar', 'SPECIALISATION': 'eye', 'AGE': 27, 'ADDRESS': 'new

delhi', 'CONTACT': '1231231224', 'FEES': 1000, 'MONTHLY_SALARY': 24000}

1.ADMINISTRATION

2.PATIENT (ADMISSION NAD DISCHARGE PROCESS)

3.SIGN OUT
ENTER YOUR CHOICE:

Hospital Management System Python

Project
Screenshots: