1
KENDRIYA VIDYALAYA NO.2
NAUSENABAGH VISAKHAPATNAM
HYDERABAD REGION
A PROJECT REPORT ON
MYSQL CONNECTIVITY
(TRAIN TICKET REGISTRATION)
SUBMITTED TO SUBMITTED BY:
MR. ARVIND KUMAR SHRIVAS RAJNISH KUMAR
P.G.T. (COMP. SC)
CERTIFICATE
2
This is to certify that RAJNISH KUMAR of class XII A of
K. V. NO.2 NSB has done his project on MYSQL
CONNECTIVITY under my supervision. He has taken
interest and has shown at most sincerity in completion of
this project.
I certify this Project up to my expectation & as per
guidelines issued by CBSE, NEW DELHI.
Internal Examiner : External
Examiner :
Principal :
ACKNOWLEDGMENT
3
It is with pleasure that I acknowledge my sincere gratitude
to our teacher, ARVIND KUMAR SHRIVAS who taught and
undertook the responsibility of teaching the subject
computer science. I have been greatly benefited from his
classes.
I am especially indebted to our Principal who
has always been a source of encouragement and support
and without whose inspiration this project would not have
been a successful I would like to place on record heartfelt
thanks to him.
Finally, I would like to express my sincere appreciation for
all the other students for my batch their friendship & the
fine times that we all shared together.
CODING :
import [Link]
from datetime import date
import random , time , os
4
x=[Link](host='localhost',user='root',passwd='12345678',database
='TRAIN')
y=[Link]()
print('FOR RESERVATION AND ENQUIRY ONLY')
print('RS:RESERVATION','CL:CANCELLATION')
print('LS:LIST','EN:ENQUIRY','UP:UPDATE')
print('DL:DELETE')
listA=[]
listB=[]
listC=[]
listD=[]
listE=[]
listF=[]
listG=[]
q=['UB','MB','LB']
qq=['SUPER FAST EXPRESS','RAJDHANI EXPRESS','MAIL
EXPRESS','SHATABDI EXPRESS','GARIBRATH EXPRESS']
d=[Link](qq)
r=[Link]()
count=0
num2=0
num=count
num1=num
print('DATE :',r)
5
while True:
z=[Link](1,7)
t=[Link](11223,99780)
w=[Link](32546765,98564367)
s=[Link](1122345678,9987976899)
xx=[Link](12,30)
yy=[Link](90,2800)
ans=input('ENTER YOUR ANS:')
if ans=='RS':
ft=input('ENTER FIRST NAME : ')
sd=input('ENTER SECOND NAME : ')
ss=ft+'-'+sd
ts='CONFIRM'
gm=input('ENTER GENDER : ')
mh=input('ENTER PHONE NO. : ')
fm=input('ENTER BOARDING : ')
ds=input('ENTER DESTINATION : ')
val1=(ss,gm,mh,fm,ds,r,ts,s)
query1="insert into
REGISTRY_DATA(NAME,GENDER,PHONE_NO,BOARDING,DESTINATION,
DATE,STATUS,PNR)\
values(%s,%s,%s,%s,%s,%s,%s,%s)"
[Link](query1,val1)
[Link]()
6
print('============================')
nm=int(input('Enter no. of people:'))
for a in range(nm):
b=[Link](100,999)
print('Enter',a+1,'person')
print('-----NAME IN 12 WORDS-----')
ne=input('ENTER FIRST NAME : ')
me=input('ENTER SECOND NAME : ')
dds=ne+'-'+me
ts='CONFIRM'
gn=input('ENTER GENDER : ')
ag=int(input('ENTER AGE : '))
query2=("insert into train_registration
(TICKET_NO,TRAIN_NO,PNR,NAME,GENDER,BOARDING,DESTINATION,P
_NO)"
"values(%s,%s,%s,%s,%s,%s,%s,%s)")
data1=str(r)+' '+str(b)+' '+str(t)+' '+str(w)+' '+str(s)
data3=' '+gn+' '+str(ag)+' '+dds
[Link](data1)
[Link](data3)
val2=(w,t,s,dds,gn,fm,ds,b)
[Link](query2,val2)
[Link]()
dd=ne+'-'+me,' ',gn,' ',ag
7
pe=gn+' '+str(ag)+' '+ne+'-'+me
[Link](pe)
[Link](dd)
[Link](b)
print('---------------------------')
print('AC:AC CLASS , SL:SLEEPER CLASS , GN:GENERAL
CLASS ')
cl=input('ENTER CLASS : ')
if cl=='AC':
print('AC CLASS RESERVATION.......')
print('3:THIRD TIER , 2:SECOND TIER , 1:FIRST TIER ')
ch=int(input('ENTER COACH TYPE : '))
print('--------------------')
if ch==3:
print('TICKET NO.:',w)
print('TRAIN NO.:',t)
print('PNR:',s)
for bb in range(nm):
k=[Link](q)
po=[Link](1,72)
ko='B'+str(z),' ',str(po),k
print('B'+str(z),' ',str(po),k,' ',listA[bb],end=' ')
print('[Link].:',listC[bb])
8
data2=' '+'B'+str(z)+' '+str(po)+' '+k+'
'+ts+' '+fm+' '+ds
[Link](data2)
print('[Link]:',xx,'[Link] Rs:',yy*nm)
print('TRAIN:',fm+' '+ds+' '+str(d))
d1=[Link](11,31)
t1=[Link](10,23)
t2=[Link](10,60)
vau=[r,t,w,s,listB[bb],ko,ts,fm,ds]
print('--------------------')
continue
if ch==2:
print('TICKET NO.:',w)
print('TRAIN NO.:',t)
print('PNR:',s)
for c in range(nm):
k=[Link](q)
wo=[Link](1,54)
print('A'+str(z),' ',str(wo),k,' ',listA[c],end=' ')
print('[Link].:',listC[c])
data2=' '+'A'+str(z)+' '+str(wo)+' '+k+'
'+ts+' '+fm+' '+ds
[Link](data2)
print('[Link]:',xx,'[Link] Rs:',yy*nm)
9
print('TRAIN:',fm+' '+ds+' '+str(d))
d1=[Link](11,31)
t1=[Link](10,23)
t2=[Link](10,60)
print('--------------------')
continue
else:
print('TICKET NO.:',w)
print('TRAIN NO.:',t)
print('PNR:',s)
for d in range(nm):
k=[Link](q)
do=[Link](1,26)
print('H'+str(z),' ',str(do),k,' ',listA[d],end=' ')
print('[Link].:',listC[d])
data2=' '+'H'+str(z)+' '+str(do)+' '+k+'
'+ts+' '+fm+' '+ds
[Link](data2)
print('[Link]:',xx,'[Link] Rs:',yy*nm)
print('TRAIN:',fm+' '+ds+' '+str(d))
d1=[Link](11,31)
t1=[Link](10,23)
t2=[Link](10,60)
print('--------------------')
10
continue
elif cl=='SL':
print('SLEEPER RESERVATION.......')
print('TICKET NO.:',w)
print('TRAIN NO.:',t)
print('PNR:',s)
for t in range(nm):
k=[Link](q)
to=[Link](1,80)
print('SL'+str(z),' ',str(to),k,' ',listA[t],end=' ')
print('[Link].:',listC[t])
data2=' '+'SL'+str(z)+' '+str(to)+' '+k+' '+ts+'
'+fm+' '+ds
[Link](data2)
print('[Link]:',xx,'[Link] Rs:',yy*nm)
print('TRAIN:',fm+' '+ds+' '+str(d))
d1=[Link](11,31)
t1=[Link](10,23)
t2=[Link](10,60)
print('--------------------')
continue
else:
print('GENERAL RESERVATION.......')
print('TICKET NO.:',w)
11
print('TRAIN NO.:',t)
print('PNR:',s)
for m in range(nm):
k=[Link](q)
mo=[Link](1,108)
print('GN'+str(z),' ',str(mo),k,' ',listA[m],end=' ')
print('[Link].:',listC[m])
data2=' '+'GN'+str(z)+' '+str(mo)+' '+k+'
'+ts+' '+fm+' '+ds
[Link](data2)
print('[Link]:',xx,'[Link] Rs:',yy*nm)
print('TRAIN:',fm+' '+ds+' '+str(d))
d1=[Link](11,31)
t1=[Link](10,23)
t2=[Link](10,60)
print('--------------------')
continue
elif ans=='CL':
co=input('ENTER PNR NO. : ')
dt="delete from TRAIN_REGISTRATION where PNR="+co
do="update REGISTRY_DATA set STATUS='CANCEL' where
PNR="+co
[Link](dt)
[Link](do)
12
[Link]()
print('YOUR TICKET HAS BEEN CANCELLED...........')
elif ans=='EN':
co=input('ENTER PNR NO. : ')
to="select * from TRAIN_REGISTRATION where pnr="+co
[Link](to)
ds=[Link]()
for n in ds:
num1+=1
print(num1,'.',n)
elif ans=='LS':
for ck in listD:
C1=[Link](ck)
[Link](listD[C1]+listG[C1]+listE[C1])
xt=open('[Link]','a')
for i in listF:
[Link](i)
[Link]('\n')
[Link]()
[Link]("select * from REGISTRY_DATA")
ds=[Link]()
13
print('=========================================REGISTRY_DATA:'
)
for n in ds:
count+=1
print(count,'.',n)
print('----------------------------')
print('=======================================TRAIN_REGISTRATI
ON:')
[Link]("select * from TRAIN_REGISTRATION")
dds=[Link]()
for nn in dds:
num+=1
print(num,'.',nn)
print('----------------------------')
print('YOU WANT TO OPEN REGISTRATION FILE')
an=input('-------------------------------')
if an=='':
[Link](r"C:\Users\HP\OneDrive\Documents\practical class
12 IMP\[Link]")
else:
continue
elif ans=='UP':
co=input('ENTER [Link]. : ')
nmm=input('ENTER NAME : ')
14
gl=input('ENTER GENDER : ')
al="update TRAIN_REGISTRATION set NAME=%s,GENDER=%s
where P_NO="+co
al2=(nmm,gl)
[Link](al,al2)
[Link]()
elif ans=='DL':
print('BE CAREFULL YOUR ALL DATA WILL BE
CLEARED !!!!!')
print('===============================================
ANS : Y/N')
sw=input('YOU WANT TO ERASE ALL DATA : ')
if sw=='Y':
[Link]("select PNR from TRAIN_REGISTRATION")
pw1=[Link]()
for aa in pw1:
pw11="delete from TRAIN_REGISTRATION where
PNR=%s"
pr1=aa
[Link](pw11,pr1)
[Link]()
[Link]("select PNR from REGISTRY_DATA")
pw2=[Link]()
for pp in pw2:
pw22="delete from REGISTRY_DATA where PNR=%s"
15
pr2=pp
[Link](pw22,pr2)
[Link]()
[Link](2)
print('DATA CLEARED SUCCESSFULLY !.................')
else:
continue
else:
print('PROGRESS SUCCESSFULLY DONE............')
break
print('THANK YOU FOR VISITING ! HAVE A HAPPY JOURNEY !')
OUTPUT :
16
17
18
19
BIBLIOGRAPHY :
[Link]
[Link] SCEINCE XII TEXTBOOK
