Class 12 Computer Project | Hospital Management System | Python Project | Class 12 Python Mysql

[@gkconnection1242]

Plz provide the pdf of it

[@seharishnoor722]

It's a wanted code sir! Plz give its code in description

[@computerdevta]

6396644970

[@AjayKumar-amba]

Computer devta ki jai

[@computerdevta]

Ha ha ha

[@terror653]

sir how can i display my data in a table form.....i tried the code but it is showing the data in brackets

[@aryadeepdas7057]

Bro.... please...also create a project on RAILWAY RESERVATION SYSTEM for class 12 .....

[@charliefascinatingfacts]

Source code please!

[@ascarobleed8262]

Sir woh update wale main kuch glti aa rhi h, error aa rha h pls help me as soon as possible

[@prachisharma1545]

Update wale section me error aa raha hai execute karne par

[@NotLeazy]

Sir pdf kaha milega iska

[@ankith4163]

Bro did u receive?

[@rupalgupta5010]

Sir how will i get source code?

[@HIMANSHUKUMAR-cz8ew]

Sir i can try but getting error in code..
Sir please help me..

[@computerdevta]

Send ur code to my mail id
ankitsaxenahp at the rate Gmail dot com

[@HIMANSHUKUMAR-cz8ew]

@@computerdevta thankyou ✨💫so much sir..

[@computerdevta]

Welcome

[@techicalelight2063]

Iska code kaha milega

[@loyalprashant8438]

Wlcm back

[@computerdevta]

Thanks

[@fellingza]

Bhai ye to chalte hi ja raha hai ruk hi nahi Raha jaise hi program ko run Kiya bhai

[@deepak_kumar41]

Sir please help me send source code my practical date is 20/12/2022

[@computerdevta]

Try to write code

[@eklavya3951]

Sir please pdf dedo iska

[@NCR_COLLEGES]

🔥🔥❤️

[@L_i_g_h_t_]

Sir plzz provide code .. it is urgent ... 🙏🏻🙂

[@ankith4163]

Bro did u receive?

[@brucelee649]

Source code dedo

[@armaangoidani4026]

Can u pls share the code

[@computerdevta]

Try to write
I ll definitely help you

[@armaangoidani4026]

@@computerdevta i wrote the whole program of your bakery management system but at last it show error everything was proper even the indentation

[@computerdevta]

send Google meet I'd on my mail now
ankitsaxenahp at the rate gmail.com

[@computerdevta]

Send soon

[@armaangoidani4026]

@@computerdevta sorry i didn't get u my google meet I'd?

[@riya-tb6sj]

Sir can we get source code to run

[@computerdevta]

Try to write
I ll help you

[@riya-tb6sj]

@@computerdevta thanx sir i m asking because from ur old videos I tried there is occuring error in my computer

[@computerdevta]

@@riya-tb6sj send Google meet I'd on my mail
ankitsaxenahp at the rate gmail.com

[@anubhavbansal8048]

Sir update ma error aa raha hai

[@yonogaming1081]

sir i dont know why but mere python ke program mein mene same chee type kiya hai thode changes ke saath but ab woh connect nhi ho rha hai like out put nhi aarha hai
input:
def add():
print("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------")
print("Insert the Information About the Patient")
P_ID=int(input("Enter the Patient ID in digits:"))
P_Name=input("Enter the Patient's name:")
Age=int(input("Enter the Age of the Patient:"))
Disease=input("Enter the Disease of the Patient:")
Incharge=input("Enter the Name of Doctor Incharge:")
fee=int(input("Enter the amount of Per Day Fees:"))
cursor.execute("insert into ravishankar(P_ID,P_Name,Age,Disease,Incharge,fee)values('%d','%s','%d','%s','%s','%d')"%(P_ID,P_Name,Age,Disease,Incharge,fee))
print("Patient added Successfully")
conn.commit()
print("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------")
def delete():
print("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------")
s=int(input("Enter P_ID of the Patient you want to Delete:"))
cursor.execute("delete from ravishankar where P_ID={}".format(s))
print("Patient Record Deleted Successfully")
conn.commit()
print("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------")
def display():
print("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------")
print(" ***********RAVISHANKAR HOSPITAL RECORD TABLE***********")
cursor.execute("select * from ravishankar")
u=cursor.fetchall()
for i in u:
print(i)
conn.commit()
print("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------")
def update():
print("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------")
m=input("Enter the Patient ID:")
dr=input("Enter the New Doctor Fees:")
cursor=conn.cursor()
n="update ravishankar set fee="+dr+'where P_ID='+m+';'
cursor.execute(n)
cursor.execute("select * from ravishankar where P_ID="+m)
print("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------")
for i in cursor:
P_ID,P_Name,Age,Disease,Incharge,fee=i
print("P_ID\tP_Name\tAge\tDisease\tIncharge\tfee")
print(P_ID,"\t",P_Name,"\t",Age,"\t",Disease,"\t",Incharge,"\t\t",fee)
print("************RECORD UPDATED*************")
conn.commit()
def search():
print("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------")
t=input("Enter P_ID to be Searched:")
cursor.execute("select * from ravishankar where P_ID="+t)
u=cursor.fetchone()
print(u)
conn.commit()
print("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------")
# HOSPITAL MANAGEMENT SYSTEM
print('''
=============================================================================================================================
************************************************** CLASS 12 ***************************************************************
************************************************* CS PROJECT **************************************************************
****************************************** HOSPITAL MANAGEMENT SYSTEM *****************************************************
********************************************** BY DHRUVRAJ SINGH ***********************************************************
=============================================================================================================================
''')
print('''
=============================================================================================================================
***********WELCOME TO RAVISHANKAR HOSPITAL***********
=============================================================================================================================
''')
#CREATING TABLE
import mysql.connector
conn=mysql.connector.connect(host="localhost",user="root",password="garud",database="hospital_management")
if conn.is_connected():
print("connected")
cursor=conn.cursor()
cursor.execute("use hospital_management")
cursor.execute("create table if not exists ravishankar\
(P_ID int primary key,\
P_Name varchar(20),\
Age is not null,\
Disease varchar(20),\
incharge varchar(20),\
fee int)")
print(''' ***********MANAGING DEPARTMENT***********''')
print('''======================================================================================================================
''')
#MAIN PROGRAM
print(''' List For Managing Records Of Patient''')
dm=0
while dm==0:
print('''======================================================================================================================''')
print("1.Add a New Patient")
print("2.Delete Old Records")
print("3.Display the Records")
print(" 4.Update the Records")
print("5.Search the Records")
print("6.Exit")
print('''======================================================================================================================''')
ch=int(input("Enter Your Option:"))
if ch==1:
add()
elif ch==2:
delete()
elif ch==3:
display()
elif ch==4:
update()
elif ch==5:
search()
elif ch==6:
break
else:
print("Invalid Choice")
output:
=================== RESTART: C:\Users\Admin\AppData\Local\Programs\Python\Python311\dhruv bhaiyaaaaa.py ==================
=============================================================================================================================
************************************************** CLASS 12 ***************************************************************
************************************************* CS PROJECT **************************************************************
****************************************** HOSPITAL MANAGEMENT SYSTEM *****************************************************
********************************************** BY DHRUVRAJ SINGH ***********************************************************
=============================================================================================================================
=============================================================================================================================
***********WELCOME TO RAVISHANKAR HOSPITAL***********
=============================================================================================================================
===================================================== RESTART: Shell =====================================================