Army Public School, Dhaula Kuan
ACADEMIC YEAR: 2021-22
PROJECT REPORT ON
CREATING MOVIE TICKET BOOKING
ROLL NO :
NAME : Aman Kumar
CLASS : XII-E
SUBJECT : COMPUTER SCIENCE
SUB CODE : 083
PROJECT GUIDE: Mrs. Pallavi sharma
1
CERTIFICATE
This is to certify that Cadet Aman Kumar has successfully completed the
project Work entitled MOVIE TICKET BOOKING the subject Computer Science laid
down in the regulations of CBSE for the purpose of Practical Examination in Class
XII to be held in Army public School.
(Pallavi Sharma)
PGT Comp Sci
Master IC
Examiner:
Name:
Signature:
2
TABLE OF CONTENTS [ T O C ]
SER DESCRIPTION PAGE NO
01 ACKNOWLEDGEMENT 04
03 OBJECTIVES OF THE PROJECT 05
05 FLOW CHART 06
06 SOURCE CODE 09
07 OUTPUT 11
3
ACKNOWLEDGEMENT
Apart from the efforts of me, the success of any project depends largely on
the encouragement and guidelines of many others. I take this opportunity to express
my gratitude to the people who have been instrumental in the successful completion
of this project.
I express deep sense of gratitude to almighty God for giving me strength for
the successful completion of the project.
I express my heartfelt gratitude to my parents for constant encouragement
while carrying out this project.
I gratefully acknowledge the contribution of the individuals who contributed in
bringing this project up to this level, who continues to look after me despite my flaws,
I express my deep sense of gratitude to the luminary The Principal, Army
public school who has been continuously motivating and extending their helping hand
to us.
I express my sincere thanks to the academician The Vice Principal, Army
public school, for constant encouragement and the guidance provided during this
project
I am overwhelmed to express my thanks to The Administrative Officer for
providing me an infrastructure and moral support while carrying out this project in the
school.
My sincere thanks to Mrs. Pallavi Sharma, Master In-charge, A guide, Mentor
all the above a friend, who critically reviewed my project and helped in solving each
and every problem, occurred during implementation of the project.
The guidance and support received from all the members who contributed
and who are contributing to this project, was vital for the success of the project. I am
grateful for their constant support and help.
4
OBJECTIVES OF THE PROJECT
The objective of this project is to let the students apply the programming
knowledge into a real- world situation/problem and exposed the students how
programming skills helps in developing a good software.
1. Write programs utilizing modern software tools.
2. Apply object oriented programming principles effectively when developing
small to medium sized projects.
3. Write effective procedural code to solve small to medium sized problems.
4. Students will demonstrate a breadth of knowledge in computer science, as
exemplified in the areas of systems, theory and software development.
5. Students will demonstrate ability to conduct a research or applied Computer
Science project, requiring writing and presentation skills which exemplify
scholarly style in computer science.
5
FLOW CHART FOR LAB
Start
print ("Enter your choice as 1,2,3&4")
print ("$$$$$$$$$$$$ PALLAVAN THEATRE BOOKING (AC & NON AC)
$$$$$$$$$$$$$$")
print ("SIGN UP")
print ("LOG IN")
print ("PALLAVAN THEATRE")
con = input ("do you want to continue or not :")
ch=int(input("Enter your choice :"))
if ch==1:
v_mname = input("Enter the movie name :")
v_phno = input("Enter phone number :")
v_tic = input("Enter total tickets :" )
v_sex = input ("Enter your sex :" )
v_fname = input ("Enter your first name :")
v_lname = input ("Enter your last name :")
v_passwd = input ("Enter your passwd :")
v_userID = input ("Enter your userID :")
v_snacks = input ("Order your snacks :")
v_ins="insert into theatre values( ‘
{}','{}','{}','{}','{}','{}','{}','{}','{}')".format(v_mname,v_phno,v_tic,v_sex,v_fname,v_
lname,v_passwd,v_userID,v_snacks)
6
c1.execute(v_ins)
conn.commit()
print (" ticket booked congrats")
print ("Thank you for visiting pallavan theatre")
print ("ratings")
ch=int(input("Enter your choice :"))
if ch =2:
print ("##############WELCOME TO THE BOX OFFICE
(AC)##################")
c = input ("Enter your movie name :")
a = input ("Enter your name :")
d = input ("Enter total tickets :")
b = input ("Enter your ph_no :")
pswd= input("Enter the password :")
sks = input(" Order your snacks :")
print ("*********************TICKET BOOKED***********************")
ch=int(input("Enter your choice :"))
if ch ==3:
print ("************welcome to 1st class ticket booking **************")
7
c = input ("Enter your movie name :")
a = input ("Enter your name :")
d = input ("Enter total tickets :")
b = input ("Enter your ph_no :")
pswd= input("Enter the password :”)
sks = input(" Order your snacks :")
print ("**TICKET BOOKED**")
ch=int(input("Enter your choice :"))
if ch == 4:
print ("!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!WELCOME TO 2nd CLASS TICKET
BOOKING !!!!!!!!!!!!!!!!!!!!!!!!!!!!")
a = input ("Enter your name :")
b = input ("Enter your movie name :")
c = input ("Enter your ph_no :")
d = input ("Enter total tickets :")
pswd= input("Enter the password :")
sks = input(" Order your snacks :")
print ("///////////////ENJOY THE MOVIE AND HAVE FUN/////////////////")
stop
8
SOURCE CODE
import mysql.connector as sql
conn=sql.connect(host = 'localhost',user='root',passwd='manager',database='soft')
c1=conn.cursor()
if conn.is_connected():
print ("Enter your choice as 1,2,3&4")
print ("$$$$$$$$$$$$ PALLVAN THEATRE BOOKING (AC & NON AC)
$$$$$$$$$$$$$$")
print ("SIGN UP")
print ("LOG IN")
print ("PALLAVAN THEATRE")
con = input ("do you want to continue or not :")
ch=int(input("Enter your choice :"))
if ch==1:
v_mname = input("Enter the movie name :")
v_phno = input("Enter phone number :")
v_tic = input("Enter total tickets :" )
v_sex = input ("Enter your sex :" )
v_fname = input ("Enter your first name :")
v_lname = input ("Enter your last name :")
v_passwd = input ("Enter your passwd :")
v_userID = input ("Enter your userID :")
v_snacks = input ("Order your snacks :")
v_ins="insert into theatre
values( '{}','{}','{}','{}','{}','{}','{}','{}','{}')".format(v_mname,v_phno,v_tic,v_sex,v_fname,v
_lname,v_passwd,v_userID,v_snacks)
c1.execute(v_ins)
conn.commit()
print (" ticket booked congrats")
print ("Thank you for visiting pallavan theatre")
print ("ratings")
ch=int(input("Enter your choice :"))
if ch ==2:
print ("##############WELCOME TO THE BOX OFFICE
(AC)##################")
c = input ("Enter your movie name :")
a = input ("Enter your name :")
d = input ("Enter total tickets :")
b = input ("Enter your ph_no :")
pswd= input("Enter the password :")
sks = input(" Order your snacks :")
print ("*********************TICKET BOOKED***********************")
ch=int(input("Enter your choice :"))
if ch ==3:
print ("************welcome to 1st class ticket booking **************")
c = input ("Enter your movie name :")
a = input ("Enter your name :")
d = input ("Enter total tickets :")
b = input ("Enter your ph_no :")
pswd= input("Enter the password :")
sks = input(" Order your snacks :")
print ("**TICKET BOOKED**")
9
ch=int(input("Enter your choice :"))
if ch == 4:
print ("!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!WELCOME TO 2nd CLASS TICKET
BOOKING !!!!!!!!!!!!!!!!!!!!!!!!!!!!")
a = input ("Enter your name :")
b = input ("Enter your movie name :")
c = input ("Enter your ph_no :")
d = input ("Enter total tickets :")
pswd= input("Enter the password :")
sks = input(" Order your snacks :")
print ("///////////////ENJOY THE MOVIE AND HAVE FUN/////////////////")
10
OUTPUT
# adding details:
11
12
