neelam documantation of railway reservation for print

8/11/2019 Neelam Documantation of Railway Reservation for Print

1/57

Railway Reservation System

PREPARED BYNutan vadodariya. Nilam Vihol Komal Modha

Held in Aril!"#$$

By

SA%RASH&RA %N'VERS'&YRA(K)&

1

1

SHR' P.K.M *)++E,E )- &E*H

)PP.HAVE+' AAD'/ Nr. S.& *)++)NY/

*)++E,E R)AD /

(%NA,ADH 01# ##".

'NS&'&%&')N


2/57

2

2


3/57

SR N). *)N&EN&S$ De2laration

" Pro3e2t Pro4ile

0 A25nowled6ement

7 So4tware reuirement

8 Data9ase analysis

1 Data 4low dia6ram

: -orm desi6n

; Sour2e 2ode

< *on2lusion

$# Bi9lo6rahy

3

3


4/57

I am Nutan Vadodariya, The Student P.G.D.C.A.here by declare that the ro!ect

"or# entitled a$ RA'+AY RESERVA&')N SYS&EMi$ re$ult o% my "or# and my

indebtedne$$ to other "or# ublication, i% any ha&e been duly ac#no"led'ed.

Date( 1)th*un 2++

Place( *-NAGAD

SIGNAT-/0


5/57

I am Nilam Vihol The Student o%

P.G.D.C.A.

here by declare that the ro!ect"or# entitled a$ RA'+AY

RESERVA&')Ni$ re$ult o% my "or# and mindebtedne$$ to other "or# ublication,

i% any ha&e been duly ac#no"led'ed.

Date( 1)th*une 2++

Place( *-NAGAD

SIGNAT-/0

)

)


6/57

I am omal odha The Student o% P.G.D.C.A. here by declare that the

ro!ect "or# entitled a$ RA'+AY RESERVA&')N i$ re$ult o% my "or# and

mindebtedne$$ to other "or# ublication, i% any ha&e been duly ac#no"led'ed.

Date( 1)th*une 2++

Place( *-NAGAD

SIGNAT-/0

4

4


7/57

roject title

( /ail"ay /e$er&ation

Front end tools ( h

Back and tools ( my$5l

roject guide ( i$$. Seema ho#har

i$$. S"eta Patel

P C6770G0 68 T0C..

Developed by ( Nutan Vadodariya 9 :

Nilam Vihol 9 :

omal odha 9 :

Operating system( "indo"$ ;P

AP

/DESy S5l

1+

1+


11/57

+),'N

Fieldname Type SizeUsername Varchar 10

Password Varchar 10

&RA'N=MAS&ER

Fieldname Type SizeTrain_no Int 4

Train_name Varchar 50

Source Varchar 30

Destination Varchar 30

Arr_time Time

Dept_time Time

Day_in_week Varchar 40

Dist_in_km Int 5

11

11


12/57

R))& MAS&ER


Station Varchar 30

! Int 5

Arr_time Time

Dept_time Time

*)A*H MAS&ER


"oach_id #ar$inary %

"oach_name #archar 30

"&ach_per_seat Int 3

"har'e_per_km ()oat

*o_o+_coach Int 3

PASSEN,ER DE&A'+

Fieldname Type SizeTicket_no Int ,

-oo'ie_no Int 3

Seat_no Varchar 5

*ame Varchar 25

A'e Int 5

.ender Varchar 1

"ontact_no Varchar 10

12

12


13/57

RESERVA&')N MAS&ER


Train_name Varchar 50

Arr_time Time

/eser#e_date Date

"oach Varchar 30

Station_(rom Varchar 30

Station_To Varchar 30

/eser#e_time Time! Int 5

ourney_date Varchar 10

Ticket_no Int ,

&RANSA*&')N MAS&ER


ourney_date Varchar 10

")ass Varchar 30

Tota)_seat Int 5

/eser#ed_seat Int 5

Unreser#e_seat Int 5

/eser#e_time Time

seat_no Varchar 5

Ticket_no Int ,

*AN*E++A&')N

Fieldname Type CollationTrain_no Int 4

Ticket_no Int 5

"ance))ation_date Date

ourney_date Date

13

13


14/57

FieldnameType Collation

(air Int 2

1

1


15/57

&his s2reen will dislay the lo6in ro2ess.

>inde?.h@

h

session=start>@C

i4>isset>=P)S&Fsu9$FG@@

in2lude>Fmy2on.hF@CmysIl=sele2t=d9>Fd9railwayF@C

resJmysIl=Iuery>Fsele2t 4rom lo6in where usernameJLF.

=P)S&LunameLG.FLF@C

2J$C

while>rowJmysIl=4et2h=asso2>res@@

i4>rowFusernameFGJJ=P)S&FunameFG

rowFasswordFGJJ=P)S&FassFG@

=SESS')NFunameFGJrowFusernameFGC

session=re6ister>FunameF@C

1)

1)


16/57

header>Flo2ationinde?$.hF@C

2J#C

O

O

i4>2JJ$@

e2ho FH$ A+',NJL*EN&ERL-)N& S'QEJL0L *)+)RJLREDLu'nvalid

%sername Passwardu4ontH$FC

O

O

9ody 962olorJFT##**--F te?tJFT--****F

9r9r9r9r9r

h$ ali6nJF2enterFu+),'N -)RMu

4orm nameJFlo6inF a2tionJFTF methodJFostF

Enter %sername

inut tyeJFte?tF nameJLunameL ta9inde?JF$F9r

Enter Password

inut tyeJFasswordF nameJFassF9r

inut tyeJFsu9mitF nameJFsu9$F valueJFS',N 'NF

4orm

9ody

>'nde?$.h@

h

in2lude>Fheader.hF@C

in2lude>Fmenu.hF@C

in2lude>F4ooter.hF@C

e2ho headerC

e2ho menuC

e2ho F9r9r9r9rre h" ali6nJL2enterL E+*)ME

&) )%R RA'+AY EN()Y

()%RNY.........h"re9r9r9r9r9r9r9r9r9r9r9

rFCe2ho 4ooterC

9ody 962olorJFT


17/57

headerJFhtml ?mlnsJLhttwww.w0.or6$

RESERVA&')Nah$

div idJLheader!lin5sL

divdivFC

>Menu.h@

h

menuJFdiv idJLmenuL

ul

li idJL2urrentLa hre4JLinde?$.hLHomeali

li idJL2urrentLa hre4JLinIuiry.hL'nIuiryali

li 2lassJLlastLa hre4JLtrain=detail.hL&rain=Detailli

lia hre4JLroot=detail.hLRoot=Detailali

lia hre4JL2oa2h=detail.hL*oa2h=detailali

lia hre4JLreservation.hLReservation ali

lia hre4JL2an2ellation.hL*an2ellationali lia hre4JLlo6out.hL+o6outali

ul

divFC

>-ooter.h@

h

4ooterJFdiv idJL4ooterL ui&HANKS -)R V'S'&'%BR

1Sele2ted=root.h@

hin2lude>Fmy2on.hF@C

mysIl=sele2t=d9>Fd9railwayF@C


in2lude>Fmenu.hF@C


e2ho headerC

e2ho menuC

IueryJFsele2t train=no 4rom train=mastFC

resJmysIl=Iuery>Iuery@C

e2ho Fh$ ali6nJL2enterL4orm nameJL4$L methodJLostL a2tionJLTL

sele2t nameJLtrainLotionsele2t trainotionFC

while>rowJmysIl=4et2h=array>res/MYSW+=ASS)*@@

4orea2h>row as 5eyJval@

e2ho FotionvalotionFC

O

O

e2ho Fsele2tFC

e2ho F9r9rinut tyeJLsu9mitL nameJLsu9L valueJLa22etL

4ormh$FCi4>isset>=P)S&Lsu9LG@@

IueryJFsele2t 4rom root=mast where &rain=noJLF.=P)S&LtrainLG.FLFC


rint>Fta9le 9orderJL#L ali6nJL2enterLF@C

?J#C

rint>Ftr 962olorJL2yanLF@C

while>?mysIl=num=4ields>res@@

rint4>FthXsthF/mysIl=4ield=name>res/?@@C?C

O

rint>FtrF@C

2ntJ#C

while>arrJmysIl=4et2h=array>res/MYSW+=ASS)*@@

i4>2ntX"JJ#@

rint>Ftr 962olorJLT##**44LF@C

4orea2h>arr as 5eyJvalue@

rint4>FtdXstdF/value@C

2FtrF@C

O

else

rint>Ftr 962olorJLin5LF@C



O

rint>FtrF@C

O

2ntC

O

rint>Fta9leF@C

O

e2ho 4ooterC

2

2


29/57

&he 4ollowin6 s2reen will 9e dislay 2oa2h=detail/ when user 2li25 on

2oa2h=detail menu.

>*oa2h=detail.h@

h

in2lude>Fmy2on.hF@C



in2lude>Fmenu.hF@C


e2ho headerC

e2ho menuC

e2ho F9r9rh$ ali6nJL2enterLu*)A*H=DE&A'+uh$FC

IueryJFsele2t distin2t 2oa2h=id/2oa2h=name/2oa2h=er=seat/2har6e=er=5m

4rom 2oa2h=detailFC



?J#C



rint4>FthXsthF/mysIl=4ield=name>res/?@@C

?CO

2

2


30/57

rint>FtrF@C

2ntJ#C

while>arrJmysIl=4et2h=array>res/MYSW+=ASS)*@@

i4>2ntX"JJ#@

rint>Ftr 962olorJLT##**44LF@C



O

rint>FtrF@C

O

else




O

rint>FtrF@C

O

2ntC

O

rint>Fta9leF@C

e2ho F9r9r9rF.4ooterC

3+

3+


31/57

&he 4ollowin6 s2reen will 9e dislay 4or reservation/ when user 2li25 on

reservation menu.

>Reservation.h@

h

session=start>@C

in2lude>Fmy2on.hF@C


i4>isset>=P)S&Lo5LG@@

=SESS')NLtrainnoLGJ =P)S&LtrainnoLGC

session=re6ister>LtrainnoL@Cheader>F+o2ation reserve=train.hF@C

O


in2lude>Fmenu.hF@C


e2ho headerC

e2ho menuC

e2ho F9r9r9rla9elh$

ali6nJL2enterLuReservationuh$la9elFC

e2ho F4orm nameJL4$L methodJLostL a2tionJLreservation.hL

31

31


32/57

ta9le ali6nJL2enterLtr

td &rain no td

tdsele2t nameJLtrainnoLotionsele2t trainotionFC

IueryJFsele2t train=no 4rom train=mastFC

resJmysIl=Iuery>Iuery@Cwhile>rowJmysIl=4et2h=array>res/MYSW+=ASS)*@@



O

O

e2ho Fsele2ttdtr

trtdinut tyeJLsu9mitL valueJLsendL nameJLo5Ltd

ta9le

4ormFC

e2ho F9r9r9r9r9rF.4ooterC

32

32


33/57

&he 4ollowin6 s2reen will 9e dislay train=in4ormation 4or reservation/ when user

sele2t train=no 4rom 2om9o 9o? in reservation.h.

>Reserve=train.h@

h

session=start>@C

in2lude>Fmy2on.hF@C


i4>isset>=P)S&LreserveLG@@

=SESS')NLnmLGJ=P)S&LtrainnameLGC

session=re6ister>LnmL@C=SESS')NLtimeLGJ=P)S&LtimeLGC

session=re6ister>Larr=timeL@C

=SESS')NLdateLGJ=P)S&Lre=dtLGC

session=re6ister>LdateL@C

=SESS')NL2oa2hLGJ=P)S&L2oa2hLGC

session=re6ister>L2oa2hL@C

=SESS')NL4romLGJ=P)S&L4romLGC

session=re6ister>L4romL@C

=SESS')NLtoLGJ=P)S&LtoLGC

session=re6ister>LtoL@C

=SESS')NLre=timeLGJ=P)S&Lre=timeLGC

session=re6ister>Lre=timeL@C

33

33


34/57

=SESS')NL5mLGJ=P)S&L5mLGC

session=re6ister>L5mL@C

header>F+o2ationessen6er=detail.hF@C

O

in2lude>Fheader.hF@Cin2lude>Fmenu.hF@C


i4>isset>=SESS')NLtrainnoLG@@

IueryJFsele2t train=name 4rom train=mast where train=noJLF.

=SESS')NLtrainnoLG.FLFC



4orea2h>row as val@

aJ valC

O

O

IueryJFsele2t arr=time 4rom train=mast where train=noJLF.

=SESS')NLtrainnoLG.FLFC



4orea2h>row as val@

9J valC

O

O

O

e2ho headerC

e2ho menuC

e2ho Fh$ ali6nJL2enterLu&RA'N=DE&A'+uh$9rFC

e2ho F4orm nameJL4$L a2tionJLTL methodJLostL

ta9le ali6nJL2enterL

tr

td&rain nametd tdinut tyeJLte?tL nameJLtrainnameL valueJatd

tr

tr

tdArr timetd

tdinut tyeJLte?tL nameJLtimeL valueJ9td

tr

tr

tdReserve date td

tdinut tyeJLte?tL nameJLre=dtL valueJLF.date>[email protected]

td

trtr

3

3


35/57

tdReserve timetd

tdinut tyeJLte?tL nameJLre=timeL valueJLF.date>[email protected]

td

tr

trtd*oa2htd

tdsele2t nameJL2oa2hLotionsele2t 2oa2h nameotionFC

IueryJFsele2t distin2t 2oa2h=name 4rom 2oa2h=detailFC





O

O

e2ho Ftd

tr

tr

tdStation -romtd

tdinut tyeJLte?tL nameJL4romLtd

tr

tr

tdstation &o td

tdinut tyeJLte?tL nameJLtoL td

tr tr

tdKMtd

tdinut tyeJLte?tL nameJL5mL

tr

tr

tdinut tyeJLsu9mitL valueJLa22etL nameJLreserveL on2li25JL

return 2he25>4$@Ltd

td

trta9le4ormFC

e2ho 4ooterC

s2rit lan6ua6eJF3avas2ritF

4un2tion 2he25>4orm?@

i4>4orm?.4rom.valueJJLL ]] 4orm?.to.valueJJLL ]] 4orm?.5m.valueJJLL@

alert>FP+EASE A&&EMP& A++ 'N-)RMA&')NF@C

return 4alseC

4orm?.4rom.4o2us>@C

O

O

s2rit

3)

3)


36/57

&he 4ollowin6 s2reen will 9e dislay/ when user not 4ill u all in4ormation 4rom

[reserve=train.h\.

34

34


37/57


38/57

IJFSE+E*& -R)M transa2tion=mast HERE &rain=noJ LF.no.FL

Seat=noJLF.seat.FL (ourney=dateJLF.3dt.FLFC

resJmysIl=Iuery>I@C

tJ#C

while>rowJmysIl=4et2h=row>res@@

tJ$C

O

i4>t@

e2ho Fh$ ali6nJL2enterLuS)RRY/&H'S SEA& 'S A++READY

RESERVEDu

4orm nameJL4$L methodJLostL a2tionJLreservation.hL

9rinut tyeJLsu9mitL valueJLBA*KL4ormh$FC

O

else

9oo6ieJ=P)S&L9oo6ieLGC

seatJ=P)S&LseatLGC

nameJ=P)S&LnmLGC

a6eJ=P)S&La6eLGC

6enderJ=P)S&L6enderLGC

2onte2tJ=P)S&L2onte2tLGC

IueryJFinsert into Pessen6er=Detail

>&i25et=no/Boo6ie=no/Seat=no/Name/A6e/,ender/*onta2t=no@

values>LF.ti25etno.FL/LF.9oo6ie.FL/LF.seat.FL/LF.name.FL/LF.a6e.FL/LF.6ender.FL/LF.2onte2t.FL@FC


noJ=SESS')NLtrainnoLGC

nmJ=SESS')NLnmLGC

timeJ=SESS')NLtimeLGC

dateJ=SESS')NLdateLGC

2oa2hJ=SESS')NL2oa2hLGC

sour2eJ=SESS')NL4romLGC

destJ=SESS')NLtoLGC

re=timeJ=SESS')NLre=timeLGC

5mJ=SESS')NL5mLGCIueryJFinsert into reservation=mast

>&rain=no/&rain=name/Arr=time/Reserve=date/*oa2h/Station=-ro

m/Station=&o/reserve=time/5m/3ourney=date/ &i25et=no@

values>LF.no.FL/LF.nm.FL/LF.time.FL/LF.date.FL/LF.2oa2h.FL/LF.

sour2e.FL/LF.dest.FL/LF.re=time.FL/LF.5m.FL/LF.3dt.FL/LF.

ti25etno.FL@FC


2lassJ=SESS')NL2oa2hLGC

seatJ=SESS')NLseatLGC

IueryJFinsert into transa2tion=mast

>train=no/3ourney=date/2lass/total=seat/reserved=seat/seat=no/reserve=time/&i25et=no@

3

3


39/57

value>LF.no.FL/LF.3dt.FL/LF.2lass.FL/8:1/$/LF.seat.FL/LF.re=time.FL/LF.

ti25etno.FL@FC


IJFsele2t sum>reserved=seat@ 4rom transa2tion=mast where train=noJLF.

no.FL 3ourney=dateJLF.3dt.FLFCresJmysIl=Iuery>I@C


4orea2h>row as val@

aJvalC

O

O

IueryJFudate transa2tion=mast

set unreserve=seatJ>total=seat!a@

where train=noJLF.no.FLFC


header>F+o2ation REP=&'*KE&.hF@C

O

O


in2lude>Fmenu.hF@C


e2ho headerCe2ho menuC

e2ho Fh$ ali6nJL2enterLuPessen6er=Detailu9r

4orm nameJL4$L methodJLostL a2tionJLT^L

ta9le ali6nJL2enterL

tr

td&i25et notdtdinut tyeLte?tL nameJLti25etnoL

ma?len6thJ;td

tr

tr

tdBoo6ie notdtdinut tyeJLte?tL nameJL9oo6ieLma?len6thJ"

tr tr

tdSeat notdtdinut tyeJLte?tL nameJLseatLma?len6thJ7td

tr

tr

td Nametdtdinut tyeJLte?tL nameJLnmL ma?len6thJ$8td

tr

tr

tdA6etdtdinut tyeJLte?tL nameJLa6eL ma?len6thJ"td

tr

tr

td ,endertdtdinut tyeJLte?tL nameJL6enderLma?len6thJ$td

3

3


40/57

tr

tr

td *onte2t no tdtdinut tyeJLte?tL nameJL2onte2tL

ma?len6thJ$#td

tr tr

td(ourney=datetdtdinut tyeJLte?tL nameJL3=dateL

valueJLyear!dd!mmL on4o2usJL2ls>4$@Ltd

tr

tr tdinut tyeJLsu9mitL nameJLreservationL valueJLreserveL

on2li25JLreturn 2he25>4$@Ltd

4orm

td4orm nameJL4"L methodJLostL a2tionJLreservation.hL

inut tyeJLsu9mitL nameJLnoreservationL valueJLunreserveLtd

tr

4ormta9leFC

e2ho 4ooterC

s2rit lan6ua6eJF3avas2ritF

4un2tion 2he25>?@

i4>?.ti25etno.valueJJLL ]] ?.9oo6ie.valueJJLL ]] ?.seat.valueJJLL ]]

?.nm.valueJJLL ]] ?.a6e.valueJJLL ]] ?.6ender.valueJJLL ]] ?. 2onte2t.valueJJLL ]]

_.3ourney=date.valueJJLL@

alert>FP+EASE A&&EMP& A++ 'N-)RMA&')NF@Creturn 4alseC

?.nrno.4o2us>@C

O

O

4un2tion 2ls>?@

?.3=date.valueJFFC

O

s2rit

+

+


41/57

&he 4ollowin6 s2reen will 9e dislay/ when user miss enter any in4ormation in

dislayed assen6er=4orm

-rom [assen6er=detail.h\.

1

1


42/57

&he 4ollowin6 s2reen will 9e dislay >ti25et reort@/ when user 4ill u all

in4ormation and 2li25 on reserve 9utton 4rom [assen6er=detail.h\.

>Re=ti25et.h@

h

session=start>@C

in2lude>Fmy2on.hF@C


ti25etnoJ=SESS')NLti25etnoLGC


5mJ=SESS')NL5mLGC

re=dtJ=SESS')NLdateLGC3=dateJ=SESS')NL3=dateLGC


a6eJ=SESS')NLa6eLGC

2

2


43/57

4romJ=SESS')NL4romLGC

toJ=SESS')NLtoLGC

e2ho Fh$ ali6nJL2enterLu4ont 2olorJLma6entaLHAPPY ()%RNEYu

ta9le 9orderJ#

trtd&i25et no!tdtdinut tyeJLte?tL disa9led valueJLF.ti25etno.FLtd

tr

tr

td&rain=no!tdtdinut tyeJLte?tL disa9led valueJLF.no.FLtd

tr

tr

td*lass!tdtdinut tyeJLte?tL disa9led valueJLF.2lass.FLtd

tr

tr

tdKM!tdtdinut tyeJLte?tL disa9led valueJLF.5m.FLtd

tr

tr

tdReserve=Date!tdtdinut tyeJLte?tL disa9led valueJLF.

re=dt.FLtd

tr

tr

td(ourney=Date!tdtdinut tyeJLte?tL disa9led valueJLF.

3=date.FLtd

tr

tr

tdSour2e!tdtdinut tyeJLte?tL disa9led valueJLF.4rom.FLtdtr

tr

tdDestinstion!tdtdinut tyeJLte?tL disa9led valueJLF.to.FLtd

tr

tr

tdReservation -ees!tdtdinut tyeJLte?tL disa9led valueJ8#td

tr

ta9le4onth$FC

IJFsele2t 9oo6ie=no/seat=no/name/a6e/6ender 4rom essen6er=detail where

&i25et=noJLF.ti25etno.FLFC

resJmysIl=Iuery>I@Crint>Fta9le 9orderJL#L ali6nJL2enterLF@C

?J#C




?C

O

rint>FtrF@C



3

3


44/57


45/57

&he 4ollowin6 s2reen will 9e dislay 4or 2an2ellation reserved ti25et/when user

2li25 on 2an2ellation.h.

>*an2ellation.h@

h

session=start>@C

in2lude>Fmy2on.hF@C



in2lude>Fmenu.hF@C


e2ho headerCe2ho menuC

e2ho Fla9elh$ ali6nJL2enterLu*an2ellationla9eluh$la9elFC

e2ho F4orm nameJL2an2elL methodJLostL a2tionJLTL

h$ ali6nJL2enterLEnter &i25et=no.! inut tyeJLte?tL nameJLti25etnoL

ma?len6thJ;9r

inut tyeJLsu9mitL nameJLdeleteL valueJL2an2elL

4ormh$FC

i4>isset>=P)S&LdeleteLG@@

ti25etnoJ=P)S&Lti25etnoLGC

IJFsele2t train=no/reserve=date/3ourney=date/station=4rom/station=to 4rom

reservation=mast where &i25et=noJLF.ti25etno.FLFC

)

)


46/57

resJmysIl=Iuery>I@C


?J#C




?C

O

rint>FtrF@C



4orea2h>row as val@

rint>FtdvaltdF@C

O

rint>FtrF@C

O

rint>Fta9leF@C

IJFsele2t &i25et=no/9oo6ie=no/seat=no/name/a6e 4rom essen6er=detail where


resJmysIl=Iuery>I@C


?J#Crint>Ftr 962olorJL2yanLF@C



?C

O

rint>FtrF@C



4orea2h>row as val@

rint>FtdvaltdF@C

O

rint>FtrF@C

O

rint>Fta9leF@C

IJFdelete 4rom reservation=mast where &i25et=noJLF.ti25etno.FLFC

resJmysIl=Iuery>I@C

IJFdelete 4rom essen6er=detail where &i25et=noJLF.ti25etno.FLFC

resJmysIl=Iuery>I@CIJFdelete 4rom transa2tion=mast where &i25et=noJLF.ti25etno.FLFC

4

4


47/57

resJmysIl=Iuery>I@C

trainnoJ=SESS')NLtrainnoLGC


2an2el=dateJ=SESS')NLdateLGC3dtJ=SESS')NL3=dateLGC

4airJ=SESS')NL4airLGC

IJFinsert into

2an2ellation>train=no/ti25et=no/2an2ellation=date/3ourney=date/4air@values>LF.

trainno.FL/LF.ti25etno.FL/LF.2an2el=date.FL/LF.3dt.FL/LF.4air.FL@FC

resJmysIl=Iuery>I@C

e2ho resC

O

e2ho Fh$ ali6nJL2enterLa hre4JLre=2an2ellin6.hLsee 2an2ellin6

reortah$FC

e2ho 4ooterC

&'*KE& REP)R&@

>Re=ti25et.h@

h

session=start>@C

in2lude>Fmy2on.hF@C




5mJ=SESS')NL5mLGC

re=dtJ=SESS')NLdateLGC

3=dateJ=SESS')NL3=dateLGC


a6eJ=SESS')NLa6eLGC

4romJ=SESS')NL4romLGC

toJ=SESS')NLtoLGC

e2ho Fh$ ali6nJL2enterLu4ont 2olorJLma6entaLHAPPY ()%RNEYu

ta9le 9orderJ#

trtd&i25et no!tdtdinut tyeJLte?tL disa9led valueJLF.ti25etno.FLtd

)1

)1


52/57

tr

tr

td&rain=no!tdtdinut tyeJLte?tL disa9led valueJLF.no.FLtd

tr

trtd*lass!tdtdinut tyeJLte?tL disa9led valueJLF.2lass.FLtd

tr

tr

tdKM!tdtdinut tyeJLte?tL disa9led valueJLF.5m.FLtd

tr

tr

tdReserve=Date!tdtdinut tyeJLte?tL disa9led valueJLF.

re=dt.FLtd

tr

tr

td(ourney=Date!tdtdinut tyeJLte?tL disa9led valueJLF.

3=date.FLtd

tr

tr

tdSour2e!tdtdinut tyeJLte?tL disa9led valueJLF.4rom.FLtd

tr

tr

tdDestinstion!tdtdinut tyeJLte?tL disa9led valueJLF.to.FLtd

tr

tr

tdReservation -ees!tdtdinut tyeJLte?tL disa9led valueJ8#tdtr

ta9le4onth$FC

IJFsele2t 9oo6ie=no/seat=no/name/a6e/6ender 4rom essen6er=detail where


resJmysIl=Iuery>I@C


?J#C



rint4>FthXsthF/mysIl=4ield=name>res/?@@C?C

O

rint>FtrF@C



4orea2h>row as val@

rint>FtdvaltdF@C

Orint>FtrF@C

)2

)2


53/57

O

rint>Fta9leF@C

IJFsele2t distin2t 2har6e=er=5m 4rom 2oa2h=detail where 2oa2h=nameJLF.

2lass.FLFC

resJmysIl=Iuery>I@Cwhile>rowJmysIl=4et2h=array>res/MYSW+=ASS)*@@

4orea2h>row as val@

aJvalC

O

O

4airJ5maC

4airJ4air8#C

i4>a6eJ1#@

4airJ4air#.8#C

O

=SESS')NL4airLGJ4airC

session=re6ister>L4airL@C

e2ho F4orm nameJL4$L methodJLostL a2tionJLreservation.hL

ta9le 9orderJ# ali6nJL2enterL

trtd-air!tdtdinut tyeJLte?tL disa9led valueJLF.4air.FLtd

trtdinut tyeJLsu9mitL valueJLBA*KLtd

trta9le4ormFC

9ody 962olorJFT--**--F te?tJFT


54/57

>*AN*E++'N, REP)R&@

>Re=2an2ellin6.h@

h

in2lude>Fmy2on.hF@C


2urr=dateJdate>LY!n!3L@C

e2ho F9rh$ ali6nJL2enterLu4ont 2olorJLma6entaL*an2ellin6!

Reort4ontuh$FC

IJFsele2t distin2t 4rom 2an2ellation where 2an2ellation=dateJLF.2urr=date.FLFC

resJmysIl=Iuery>I@C


?J#C




?C

O

rint>FtrF@Cwhile>rowJmysIl=4et2h=array>res/MYSW+=ASS)*@@

)

)


55/57


4orea2h>row as val@

rint>FtdvaltdF@C

O

rint>FtrF@C

O

rint>Fta9leF@C

e2ho Fh$ ali6nJL2enterL4orm nameJL4$L methodJLostL

a2tionJL2an2ellation.hL

9rinut tyeJLsu9mitL valueJLBA*KL4ormh$FC

9ody 962olorJFT--**--F9ody

))

))


56/57

*urrently the Railway Non Reserved &i25et Boo5in6Z is doin6 its wor5on manual 9asi2. &his entire 9oo5 to maintain sto25 5ee re2ord o4 ea2h meter

rearin6 or di so it well 9e time 2onsumin6. &hey maintain various resisters to

store the in4ormation.

At resent the deartment o4 Railway Reservation sta44>3una6adh@

maintain resisters 4or the urose o4 mana6in6 the 4irm/ whi2h are as 9elow.

'ndent 4or assen6er 2ard ti25ets

&i25et sto25 9oo5>station wise 2lass wise@

Daily train 2ash!2um!summary 9oo5

As er tye o4 train

Detail o4 non!issued ti25et

Detail o4 ti25et issued at 2on4essional rates.

)4

)4


57/57

neelam documantation of railway reservation for print

Documents