VISVESVARAYA TECHNOLOGICAL UNIVERSITY,

BELGAUM-590 014

A Mini-Project Report
on
“Online Movie Ticket Management System”

Submitted in partial fulfillment of the requirement for the award of the degree of

BACHELOR OF ENGINEERING
in
COMPUTER SCIENCE AND ENGINEERING

Submitted by

ASHUTOSH PANDEY-1VE18CS023
ANCHIT KUMAR SINGH-1VE18CS015

Under the Guidance of

Mr. LOKESH M
Assistant Professor
Department of Computer Science and Engineering
Sri Venkateshwara College of Engineering, Bangalore-562 157

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

SRI VENKATESHWARA COLLEGE OF ENGINEERING
BANGALORE - 562 157
2020-2021
 SRI VENKATESHWARA COLLEGE OF ENGINEERING,
Vidyanagar, Bangalore – 562 157
Department of Computer Science and Engineering

CERTIFICATE

This is to certify that the Mini-Project entitled “Online Movie Ticket Management
System” carried out by Mr. ASHUTOSH PANDEY [1VE18CS023] and Mr.
ANCHIT KUMAR SINGH [1VE18CS015] of V Semester students of Sri
Venkateshwara College of Engineering, in partial fulfillment for the award of Bachelor
of Engineering in Computer Science and Engineering of Visvesvaraya Technological
University, Belgaum during the academic year 2020-2021. The Mini-Project report has
been approved as it satisfies the academic requirements in respect of DBMS Laboratory
with Mini-Project work prescribed for the said Degree.

Signature of the Guide Signature of the HOD

Mr. LOKESH M Dr. S. C. Lingareddy
Asst. Professor, Dept. of CS&E HOD, Dept. of CS&E
SVCE, Bangalore SVCE, Bangalore

Name of the Examiners: Signature with Date

 ACKNOWLEDGEMENT

The satisfaction and euphoria that accompany the successful completion of any task
would be incomplete without complementing those who made it possible, whose
guidance and encouragement made our efforts successful.

My sincere thanks to highly esteemed institution SRI VENKATESHWARA

COLLEGE OF ENGINEERING for grooming up me in to be software engineer.

I express our sincere gratitude to Dr. SURESHA , Principal, SVCE, Bengaluru for
providing the required facility. I am extremely thankful to Dr. S C Lingareddy, HOD of
CSE, SVCE for providing support and encouragement.

I am grateful to Mr. Lokesh M, Asst. Professor, Dept. of CSE, SVCE who helped me
to complete this project successfully by providing guidance, encouragement and valuable
suggestion during entire period of the project.

I thank all my computer science staff and others who helped directly or indirectly to
meet my project work with grand success.
Finally, I am grateful to my parents and friends for their invaluable support guidance and
encouragement.

ASHUTOSH PANDEY [1VE18CS023]

ANCHIT KUMAR SINGH [1VE18CS015]

 ABSTRACT

Our project basically manages the ticket booking process of a multiplex,

providing an interface to the user to book movie tickets in more easier way.
At the front end we have used PHP and at the back end My SQL server. The
project proceeds through a sequence of well-designed forms provided with
validations to ensure consistency, reliability and most importantly
correctness of information fed into the database.
 TABLE OF CONTENTS

Sl. No Title Page No

INTRODUCTION
1.
1.1OBJECTIVES

1.2 LIMITATIONS

2.
STUDY OF EXISTING SYSTEM

2.1 A CASE STUDY ON ONLINE MOVIE TICKET

MANAGEMENT SYSTEM
2.2 PROPOSED SYSTEM

3.
DATABASE DESIGN

3.1 SOFTWARE REQUIREMENT

3.1.1 COLLECTION OF REQUIREMENTS
3.1.2 FUNCTIONAL REQUIREMENTS
3.1.3 SOFTWARE AND HARDWAR REQUIREMENTS

3.2 CONCEPTUAL DESIGN

3.3 IMPLEMENTATION
3.3.1 FRONT END
3.3.2 BACK END
3.3.3 SMS GATE WAY
4.
IMPLEMENTATION IN PHP, HTML &
MYSQL,XAMPPSERVER

5. USER INTERFACE - (SCREENSHOTS )

CONCLUSIONS

REFERENCES
 CHAPTER-1
INTRODUCTION

1.1 OBJECTIVES

In this project we have created one application which is easy to access and user
friendly. For this application we used the backend as MySQL and XAMPPSERVER to
store the data which is used in the application and for the user interface, we have used
the PHP and HTML, CSS, JS. The user is able to access this application. The application
keeps a backup of the database of all Students, companies and admin.
This report discusses the result of the work done in development of “Online Movie
Ticket Management System” on “PHP and HTML” as the Front-end Platform and
“MySQL and XAMPPSERVER” as the back-end Platform.
At the development of an application PHP provides a good connecting facility between
all pages, also the back-end XAMPPSERVER is most important to save all the data related
the application.
Movie Ticket Booking Portal provides all the basic functionality of a modern-day
Multiplex with multiple screens and all other functionalities like ticket booking. The
functionality is divided into four different modules, Theater, User, Admin and
Transaction which perform their independent functions. The theater module manages
the functions of movie screening and consists of classes and Interfaces related to the
Screens, time Slots, etc. for movie screenings. The User module is meant for the
customer wherein he can perform ticket bookings and food ordering. The admin module
provides the administrative operations for the theater. Transaction Module manages all
the transactions of the customer with the theater.

The four modules function parallelly to function as a modern-day multiplex.

 MODULES

1. Theater
2. User
3. Admin
4. Transaction
0.4 TRANSACTION MODULE

The transaction module is used for managing all the transactions like ticket booking.
Classes - Ticket
1.2 LIMITATIONS

Our project has the following limitations: -

In this system the customer will not select seat number. The authorized people in this
process will be the employee who works at the cinema.

2. In this system the customer can book the tickets only for the present day.
Advanced booking for the upcoming movies (2 or 3 months before the movie is
released) is not included but can be included later.

3. Also, a printing system will not be in this project. In future, a ticket printing
system can be integrated.
 CHAPTER – 2
STUDY OF EXISTING SYSTEM

For studying the existing system on ticket booking, we conducted a case study on a major
ticket booking venture present today in India.

2.1 A case study on SVCE THEATRE: -

An Online Ordering, Payment and Loyalty Management Solution for SVCE THEATRE
has broken many national records in field of cinema exhibition. Their theatres, the first
chains of multiplexes in the country, boast of the highest box office collections in India
for 5 consecutive years. The cumulative admissions till date have exceeded more than 6
million movie goers. SVCE THEATRE is a brand name synonymous with state-of-the-art
cinema exhibition in India. SVCE THEATRE specializes in developing and operating
state-of-the-art Multiplexes. Over the last three years, Cinemas has established itself as a
very strong brand associated with movies, quality exhibition, food and youth targeted
promotions. By attracting a record number of urban middle- & upper-income consumers
to the complex, major national & international brands - have opened their outlets in the
multiplexes, making SVCE THEATRE the destination for complete family
entertainment. Situation Faced with an increasing number of customers standing in long
queues outside their theatres, SVCE THEATRE faced the challenge of providing
"Customer Delight". Customers desperately wanted a easy way of ordering and paying
for their tickets without the delays and inconvenience of standing in long queues needed a
mechanism to administer their loyalty program " SVCE THEATRE ", as well as provide
for other promotional and membership services to help partners maximize their presence
at the multiplexes. SVCE THEATRE had introduced phone booking but it was not to
prove viable, as customers were often "no-shows", leading to un-sold seats. This affected
business profits.
SOLUTION

1. Movie Ticket Booking over the Internet

In response to the SVCE Theatre requirements, we proposed an E-business
solution using Microsoft Platform which would enable movie goers to book their
tickets electronically over the Internet from the comfort of their office or home.
With the advent of the modern age, the typical user didn't have enough time to
stand in line outside the theaters. The online solution allows users to select their
shows, book and pay for their tickets. This guarantees them a ticket even before
they arrive at the cinema hall.

1. Secure electronic booking through bank payment gateway

Customers were provided with a convenient option of booking tickets through the
Internet via a secure channel using Verisign SSL (Secure Socket Layer) and for the
first-time the customers experienced the advantages of an electronic ordering system.
This feature enabled customers to get confirmed tickets online from the web site by
making payment using their credit card or debit cards. Trisoft integrated the online
transaction seamlessly with the bank Payment Gateway Server.
In order to market the website to the customers and increase the customer base for
online booking, KVR Cinemas introduced the concept of a movie club for those users
who register themselves as members. Once a customer becomes a member, they are
allowed to buy tickets within minutes using their credit cards and, can participate in
contests and win prizes. Members can also subscribe to newsletters containing movie-
related events and movie charts.

2. Statement of Account and Payment Reconciliation

The application also provides the facility to generate an end-of-month statement
of transactions executed by the system. This helps the KVR staff to reconcile their
accounts with the Citibank Payment Gateway and has drastically reduced the
time-consuming process of manual reconciliation.

3. The Technology
The website runs on Microsoft Windows 2000 Server and Microsoft SQL Server
2000. It receives more than 200,000 hits a per day and has the capacity to cater to
250 concurrent users at any given time.

Benefits
The movie portal has benefited KVR in many ways out of which a few have been
outlaid below:
• Convenient online ticket booking through the Internet, which in turn leads to
more, and repeat customers and shorter queues.

• Access to information and other movie-related promotional news through the

newsletters.

• Increased Operational Efficiency through painless transaction reconciliation at

the month end.

• Online Brand extension by projecting a tech-savvy image, and appealing to

Generation Y consumers who spend a lot of time browsing the Internet.

• The Club Class memberships through the portal have built successful and
lasting relationships with customers who are provided with special services like
contests, loyalty points and redemption against exciting gifts, home delivery of
tickets at a nominal cost, online account maintenance and more.
 2.2 Proposed System

We propose a system which is more reliable, entertaining and easy than the present
system.

Our solution targets those users who do not have spare time to stand in queue for
booking tickets. We propose an easy way of ordering and paying for the tickets
without any delays and inconvenience.

The people who book tickets are assured of a ticket before going to the theater
without their physical presence.

Customers who book tickets will receive an instant message (m-ticket) in

their mobile phone. By splashing this m-ticket at the counter of multiplex, the
customer can get the physical ticket.

The staff at the multiplex no longer needs complicated manual ticket availability and
tracking mechanisms for issuing tickets. The ticket information is stored securely in a
database which can be accessed any time for verification.
 Chapter 3
DATABASE DESIGN

The database-planning phase begins when a customer requests to develop a database

project. It is set of tasks or activities, which decide the resources required in the database
development and time limits of different activities.

3.1 SOFTWARE REQUIREMENT SPECIFICATION(SRS)

3.1.1 Collection of Requirements

Requirements analysis is done in order to understand the problem, which is to be solved.

That is very important activity for the development of database system. The requirements
and the collection analysis phase produce both data requirements and functional
requirements. The data requirements are used as a source of database design. The data
requirements should be specified in as detailed and complete form as possible.

In parallel with specifying the data requirements, it is useful to specify the

known functional requirements of the application. These consist of user-defined
operations that will be applied to the database (retrievals and updates). The functional
requirements are used as a source of application software design.
The Data-requirements are given as follows: -

User Module

* User Registration
• User Register with Name, A Username (for logging in later), Password, Phone Number,
E-mail address.
* User Login
• User Can Book the Ticket After Log in.
• User Login with User Name and Password.
• Forgot Password use for Retrieve Password.
* Check Availability
• After Login, User, Can Search Movie From Movie List.
• User Can Check Ticket Availability.
• User can also check the Movie Running Hours.
• If Ticket is Available User Can Book Ticket.
* Book Ticket
• User can book ticket by specifying username and Phone Number.
• Then Select Number of Seats to Book.
• A conformation Message will be sent to the Given Number. The content of the message
is as shown below: -
“BKID-RANDOM 7 DIGIT NUMBER”
Admin Control:
* Admin User Login.
• Admin User Login with Admin User Name and Password.
Show Manage.
• Admin Can Change Show Name and Show Time.
* Movie Mange.
• Admin Can Add New Movie.
• Admin Can Edit Old Movie Details.
• Admin Can Delete Movie.
* Schedule Manage.
• Admin Can Add New Movie Schedule.
• Admin Can Edit Movie Schedule.
• Admin Can Delete Movie Schedule.
* User Manage
• Admin Can control the signed-up users
• Admin can delete the account of users who didn't show up for the movie after booking
tickets.
*Counter Control
• Counter Employee Login with Counter User Name and Password.
• Counter Employee type the message shown by the Customer in the field given and
confirm the user.
• Tickets are issued from the Counter.
3.1.2 FUNCTIONAL REQUIREMENTS

1. The schedule of the movies will be generated via a query according to the data selected
by the user.
2. A way in which users(both customer & admin) can login to the system to perform
different operation.
3. A way in which the customer can commit order by “Point and Click” method.
4. The system can verify the data before transaction.

3.1.3 SOFTWARE AND HARDWARE REQUIREMENTS

Intel core i3 2nd generation is used as processor because it is faster & provide reliable
and stable working environment.
A RAM size of 1gb is used as it will provide fast reading & writing capabilities.

3.2 CONCEPTUAL DESIGN

Once all the requirements have been collected and analyzed, the next step is to create a
conceptual schema for the database, using a high-level conceptual data model. This phase

is the conceptual design. The result of this phase is an Entity Relationship (ER) diagram.
It is a high-level data model of the specific application area. It describes how different
entities (objects, items) are related to each other. It also describes what attributes
(properties) each entity has. It includes the definitions of all the concepts (entities,
attributes) of the application area.
3.3 IMPLEMENTATION

The various system tools that have been used in developing both the front end, back end
and other tools of the project are being discussed in this chapter.

3.3.1 FRONT END:

PHP, HTML, CSS, JAVA SCRIPTS are utilized to implement the frontend.

Different pages in the applications are designed using JS. A java sever page component is
a type of java servlet that is designed to fulfill the role of a user interface for a java web
application. Web development write JSPs as text files that combine HTML or XHTML
code, XML elements, and embedded JSP actions and commands. Using JSP, one can
collect input from users through web page.

HTML (Hyper Text Markup Language)

HTML is a syntax used to format a text document on the web.

CSS (Cascading Style Sheets)

CSS is a style sheet language used for describing the look and formatting of a document
written in a markup language.

Java Script

JS is a dynamic computer programming language. It is most commonly used as part of

web browsers, whose implementations allow client-side scripts to interact with the user,
control the browser, communicate asynchronously, and alter the document content that is
displayed.
PHP

PHP is a server-side scripting language designed for web development but also used as a
general-purpose programming language. PHP code is interpreted by a web server with a
PHP processor module, which generates the resulting web page: PHP commands can be
embedded directly into an HTML source document rather than calling an external file to
process data.

3.3.2 BACK END

The back end is implemented using MYSQL which is used to design the databases.
MYSQL
MySQL is the world’s second most widely used open-source relational database
management system (RDMS). The SQL phrase stands for structured query.

3.3.3 SMS GATEWAY

An SMS gateway allows a computer to send or receive short message services (SMS)
transmissions to or from a telecommunications network. Most messages are eventually
routed into the mobile phone networks. Many SMS gateways support media conversion
from email and other formats. A direct-to-mobile gateway is a device which has built-in
wireless. GSM connectivity. It allows SMS text messages to be sent or received by email,
from web pages or from other software applications by acquiring a unique identifier from
the mobile phone's subscriber identity module, or "SIM card". Direct-to-mobile gateways
are different from SMS aggregators, because they are installed on an organization's own
network and connect to a local mobile network. The connection to the mobile network is
made by acquiring a SIM card number from the mobile operator and installing it in the
gateway. Typically, direct-to mobile gateway appliances are used for hundreds to
thousands of text messages per month. More modern appliances now offer the capability
of send up to 100,000 messages each day. Several vendors that have historically provided
GSM Gateway equipment for voice also have SMS capability. Some are more primitive
than others. The more capable devices are designed with SIM management to regulate the
number of SMS messages per SIM, ODBC to connect to a database, and HTTP interfaces
to interact with third party applications. Text messages can be sent from a personal
computer to mobile devices via an SMS gateway, using most popular email client
programs, such as Eudora, Thunderbird, and so on. The messages must be sent in ASCII
"text-only" mode. If they are sent in HTML mode, or using non-ASCII characters, they
will most likely appear as nonsense on the recipient's mobile telephone. Before the
message can be sent, one must determine the domain of the mobile carrier's SMS
gateway.
 Chapter 4
IMPLEMENTATION IN PHP, HTML & MYSQL,
XAMPPSERVER

4.1 DATABASE CODE

-- Database: `db_movie`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_bookings`
--

CREATE TABLE IF NOT EXISTS `tbl_bookings` (

`book_id` int(11) NOT NULL AUTO_INCREMENT,
`ticket_id` varchar(30) NOT NULL,
`t_id` int(11) NOT NULL COMMENT 'theater id',
`user_id` int(11) NOT NULL,
`show_id` int(11) NOT NULL,
`screen_id` int(11) NOT NULL,
`no_seats` int(3) NOT NULL COMMENT 'number of seats',
`amount` int(5) NOT NULL,
`ticket_date` date NOT NULL,
`date` date NOT NULL,
`status` int(1) NOT NULL,
PRIMARY KEY (`book_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
--
-- Dumping data for table `tbl_bookings`
--

INSERT INTO `tbl_bookings` (`book_id`, `ticket_id`, `t_id`, `user_id`, `show_id`,

`screen_id`, `no_seats`, `amount`, `ticket_date`, `date`, `status`) VALUES
(3, '', 4, 4, 3, 3, 200, 75, '2019-12-21', '2019-12-21', 1),
(4, '', 4, 4, 1, 3, 2, 150, '2019-12-22', '2019-12-22', 1),
(5, '', 3, 3, 6, 1, 200, 70, '2019-12-25', '2019-12-22', 1),
(6, '', 3, 3, 6, 1, 100, 70, '2019-12-22', '2019-12-22', 1),
(7, '', 3, 3, 5, 1, 1, 70, '2019-12-22', '2019-12-22', 1),
(11, 'BKID5258816', 4, 2, 3, 3, 1, 75, '2019-12-22', '2019-12-22', 1);

-- --------------------------------------------------------
--
-- Table structure for table `tbl_contact`
--
CREATE TABLE IF NOT EXISTS `tbl_contact` (
`contact_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`mobile` int(11) NOT NULL,
`subject` varchar(1000) NOT NULL,
PRIMARY KEY (`contact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------
--
-- Table structure for table `tbl_login`
--
CREATE TABLE IF NOT EXISTS `tbl_login` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`username` varchar(50) NOT NULL COMMENT 'email',
`password` varchar(50) NOT NULL,
`user_type` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `tbl_login`
--

INSERT INTO `tbl_login` (`id`, `user_id`, `username`, `password`, `user_type`)

VALUES
(1, 0, 'admin', 'password', 0),
(2, 3, 'theatre', 'password', 1),
(3, 4, 'theatre2', 'password', 1),
(4, 5, 'USR858911', 'PWD608112', 1),
(5, 6, 'USR389436', 'PWD214748', 1),
(6, 7, 'USR389436', 'PWD214748', 1),
(7, 8, 'USR389436', 'PWD214748', 1),
(8, 9, 'USR503036', 'PWD713319', 1),
(9, 10, 'USR447274', 'PWD420652', 1),
(10, 11, 'USR486163', 'PWD790452', 1),
(12, 2, 'rahulreghunath11@gmail.com', 'rahul', 2),
(13, 12, 'USR568113', 'PWD334935', 1),
(14, 13, 'USR280780', 'PWD906419', 1),
(15, 14, 'USR295127', 'PWD195747', 1),
(16, 3, 'vishnut300@gmail.com', 'vishnut300', 2);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_movie`
--
CREATE TABLE IF NOT EXISTS `tbl_movie` (
`movie_id` int(11) NOT NULL AUTO_INCREMENT,
`t_id` int(11) NOT NULL COMMENT 'theatre id',
`movie_name` varchar(100) NOT NULL,
`cast` varchar(500) NOT NULL,
`desc` varchar(1000) NOT NULL,
`release_date` date NOT NULL,
`image` varchar(200) NOT NULL,
`video_url` varchar(200) NOT NULL,
`status` int(1) NOT NULL COMMENT '0 means active ',
PRIMARY KEY (`movie_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `tbl_movie`
--

INSERT INTO `tbl_movie` (`movie_id`, `t_id`, `movie_name`, `cast`, `desc`,

`release_date`, `image`, `video_url`, `status`) VALUES
(1, 3, 'Sakhav', 'Nivin', 'This story revolves around a student political leader who fights
for his left-wing ideals. When some people try to use him in order to fulfill their
intentions, he is forced to fight for his ideals.', '2018-01-01', 'images/maxresdefault.jpg',
'https://www.youtube.com/watch?v=x_AK7HWpJ-0', 0),
(2, 3, 'Comarade In America', 'Dulquer Salmaan', 'Aji Mathew is a lovable, courageous,
and modest youngster who hails from Pala. He meets a girl named Sara at college, and
they fall in love regardless of their upbringing.', '2019-12-12', 'images/cia-new-poster-
759.jpeg', 'https://www.youtube.com/watch?v=f5nvCp0QFdA', 0),
(3, 3, 'Angamaly Diaries', ' Reshma Rajan, Tito Wilson, Sarath Kumar', 'Angamaly
Diaries is a 2019 Indian Malayalam-language crime drama film directed by Lijo Jose
Pellissery and written by Chemban Vinod Jose.', '2019-12-01', 'images/angamaly-diaries-
2.jpg', 'https://www.youtube.com/watch?v=4yRBJCrjabU', 0),
(8, 3, 'Godha', 'Tovino Thomas, Wamiqa Gabbi ', 'Godha is an Malayalam Sports-
Comedy movie directed by Basil Joseph, starring Tovino Thomas, Wamiqa Gabbi and
Renji Panicker in the lead roles', '2019-12-19', 'images/godha.jpg',
'https://www.youtube.com/watch?v=hnICGugY6fI', 0),
(10, 3, 'Ramante Edanthottam', 'Kunchacko Boban, Anu Sithara', 'Ramante Edanthottam
is an upcoming Malayalam language film written produced and directed by Ranjith
Shankar.', '2019-12-12', 'images/raman.jpg',
'https://www.youtube.com/watch?v=H6HK51qVdmc', 0);

-- --------------------------------------------------------
--
-- Table structure for table `tbl_news`
--
CREATE TABLE IF NOT EXISTS `tbl_news` (
`news_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`cast` varchar(100) NOT NULL,
`news_date` date NOT NULL,
`description` varchar(200) NOT NULL,
`attachment` varchar(200) NOT NULL,
PRIMARY KEY (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tbl_news`
--
INSERT INTO `tbl_news` (`news_id`, `name`, `cast`, `news_date`, `description`,
`attachment`) VALUES
(3, 'The Mummy', 'Tom Cruiz', '2019-06-15', 'Thought safely entombed in a crypt deep
beneath the desert, an ancient princess whose destiny was unjustly taken from her is
awakened in the modern era', 'news_images/mummy.jpg'),
(5, 'Transformers: The Last Knight', ' Mark Wahlberg , Isabela Moner ', '2019-07-21',
'Humans are at war with the Transformers, and Optimus Prime is gone. The key to saving
the future lies buried in the secrets of the past and the hidden history of Transformers on
Earth', 'news_images/tra.jpg'),
(6, 'Tiyan', 'Privthi Raj,Indrajith', '2019-10-18', 'Tiyaan is an upcoming Indian Malayalam
film written by Murali Gopy and directed by Jiyen Krishnakumar.',
'news_images/tiyan.jpg');

-- --------------------------------------------------------
--
-- Table structure for table `tbl_registration`
--
CREATE TABLE IF NOT EXISTS `tbl_registration` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`phone` varchar(12) NOT NULL,
`age` int(2) NOT NULL,
`gender` varchar(10) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_registration`
--
INSERT INTO `tbl_registration` (`user_id`, `name`, `email`, `phone`, `age`, `gender`)
VALUES
(1, 'rahul', '', '9037500119', 23, 'gender'),
(2, 'rahul', 'rahulreghunath11@gmail.com', '9037500119', 23, 'gender'),
(3, 'vishnu', 'vishnut300@gmail.com', '8156820497', 22, 'gender');

-- --------------------------------------------------------
--
-- Table structure for table `tbl_screens`
--
CREATE TABLE IF NOT EXISTS `tbl_screens` (
`screen_id` int(11) NOT NULL AUTO_INCREMENT,
`t_id` int(11) NOT NULL COMMENT 'theatre id',
`screen_name` varchar(110) NOT NULL,
`seats` int(11) NOT NULL COMMENT 'number of seats',
`charge` int(11) NOT NULL,
PRIMARY KEY (`screen_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tbl_screens`
--

INSERT INTO `tbl_screens` (`screen_id`, `t_id`, `screen_name`, `seats`, `charge`)

VALUES
(1, 3, 'Screen 1', 100, 70),
(2, 3, 'Screen 2', 150, 60),
(3, 4, 'Screen 1', 200, 75),
(4, 14, 'Screen1', 34, 120);

-- --------------------------------------------------------
--
-- Table structure for table `tbl_shows`
--

CREATE TABLE IF NOT EXISTS `tbl_shows` (

`s_id` int(11) NOT NULL AUTO_INCREMENT,
`st_id` int(11) NOT NULL COMMENT 'show time id',
`theatre_id` int(11) NOT NULL,
`movie_id` int(11) NOT NULL,
`start_date` date NOT NULL,
`status` int(11) NOT NULL COMMENT '1 means show available',
`r_status` int(11) NOT NULL,
PRIMARY KEY (`s_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `tbl_shows`
--

INSERT INTO `tbl_shows` (`s_id`, `st_id`, `theatre_id`, `movie_id`, `start_date`, `status`,

`r_status`) VALUES
(1, 9, 4, 1, '2019-12-01', 1, 1),
(2, 10, 4, 1, '2019-12-01', 1, 1),
(3, 11, 4, 2, '2019-12-01', 1, 1),
(4, 12, 4, 2, '2019-12-01', 1, 1),
(5, 1, 3, 1, '2019-12-01', 1, 1),
(6, 2, 3, 1, '2019-12-01', 1, 1),
(7, 3, 3, 1, '2019-12-01', 1, 1),
(8, 4, 3, 1, '2019-12-01', 1, 1),
(9, 5, 3, 2, '2019-12-01', 1, 1),
(10, 6, 3, 2, '2019-12-01', 1, 1),
(11, 7, 3, 2, '2019-12-01', 1, 1),
(12, 8, 3, 2, '2019-12-01', 1, 1),
(13, 1, 3, 10, '2019-02-25', 1, 0),
(14, 2, 3, 10, '2019-02-25', 1, 0),
(15, 9, 4, 8, '2019-12-28', 1, 0),
(16, 10, 4, 8, '2019-12-28', 1, 0),
(17, 11, 4, 8, '2019-12-28', 1, 0),
(18, 12, 4, 8, '2019-12-28', 1, 0);

-- --------------------------------------------------------
--
-- Table structure for table `tbl_show_time`
--
CREATE TABLE IF NOT EXISTS `tbl_show_time` (
`st_id` int(11) NOT NULL AUTO_INCREMENT,
`screen_id` int(11) NOT NULL,
`name` varchar(40) NOT NULL COMMENT 'noon,second,etc',
`start_time` time NOT NULL,
PRIMARY KEY (`st_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `tbl_show_time`
--

INSERT INTO `tbl_show_time` (`st_id`, `screen_id`, `name`, `start_time`) VALUES

(1, 1, 'Noon', '10:00:00'),
(2, 1, 'Matinee', '14:00:00'),
(3, 1, 'First', '18:00:00'),
(4, 1, 'Second', '21:00:00'),
(5, 2, 'Noon', '10:00:00'),
(6, 2, 'Matinee', '14:00:00'),
(7, 2, 'First', '18:00:00'),
(8, 2, 'Second', '21:00:00'),
(9, 3, 'Noon', '10:00:00'),
(10, 3, 'Matinee', '14:00:00'),
(11, 3, 'First', '18:00:00'),
(12, 3, 'Second', '21:00:00'),
(14, 4, 'Noon', '12:03:00');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_theatre`
--
CREATE TABLE IF NOT EXISTS `tbl_theatre` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`address` varchar(100) NOT NULL,
`place` varchar(100) NOT NULL,
`state` varchar(50) NOT NULL,
`pin` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `tbl_theatre`
--

INSERT INTO `tbl_theatre` (`id`, `name`, `address`, `place`, `state`, `pin`) VALUES
(2, 'Nayanam', 'Adoor', 'Adoor', 'Kerala', 691523),
(3, 'Nadam', 'Adoor', 'Adoor, Kerala, India', 'Kerala', 691523),
(4, 'Smitha', 'Adoor', 'adoor', 'Kerala', 691523),
(5, 'Smitha', 'Adoor', 'adoor', 'Kerala', 691523),
(6, 'rty', 'ryty', 'rty', 'tryt', 545),
(7, 'rty', 'ryty', 'rty', 'tryt', 545),
(8, 'rty', 'ryty', 'rty', 'tryt', 545),
(9, 'dgd', 'dgf', 'Mannady, Chennai, Tamil Nadu, India', 'Tamil Nadu', 600001),
(10, 'vxcv', 'sdfs', 'Mannady, Prakasam Road, George Town, Chennai, Tamil Nadu, India',
'Tamil Nadu', 600001),
(11, '', '', '', '', 0),
(12, '', '', '', '', 0),
(13, 'rye', 'yetyy', 'Yeyeye Hotel, Changchun, Jilin, China', 'Jilin Sheng', 130012),
(14, 'Trinity Movies', 'Pathanamthtta', 'Pathanamthitta, Kerala, India', 'Kerala', 691554);

4.2 FRONT END IMPLEMENTATION IN PHP AND HTML

HOMEPAGE

<html>
<body>
<!--
Author: W3layouts
Author URL: http://w3layouts.com
License: Creative Commons Attribution 3.0 Unported
License URL: http://creativecommons.org/licenses/by/3.0/
-->
<!DOCTYPE HTML>
<html>
<head>
<title>Free Theater Website Template | About :: w3layouts</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
<link rel="stylesheet" href="css/flexslider.css" type="text/css" media="all" />
<link type="text/css" rel="stylesheet"
href="http://www.dreamtemplate.com/dreamcodes/tabs/css/tsc_tabs.css" />
<link rel="stylesheet" href="css/tsc_tabs.css" type="text/css" media="all" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script src='js/jquery.color-RGBa-patch.js'></script>
<script src='js/example.js'></script>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<div class="header">
<div class="header-top">
<div class="wrap">
<div class="h-logo">
<a href="index.php"><img src="images/logo.png" alt=""/></a>
</div>
<div class="nav-wrap">
<ul class="group" id="example-one">
<li><a href="index.php">Home</a></li>
<li><a href="movies_events.php">Movies</a></li>
<li><a href="login.php">Login</a></li>
</ul>
</div>
<div class="clear"></div>
</div>
</div>
<div class="clear"></div>

<div class="block">
<div class="wrap">

<form action="process_search.php" id="reservation-form" method="post"

onsubmit="myFunction()">
<fieldset>
<div class="field" >

<input type="text" placeholder="Search Movies Here..."

style="height:27px;width:500px" required id="search111" name="search">
 <input type="submit" value="Search" style="height:28px;padding-top:4px"
id="button111">
</div>

</fieldset>
</form>
<div class="clear"></div>
</div>
</div>
<script>
function myFunction() {
if($('#hero-demo').val()=="")
{
alert("Please enter movie name...");
return false;
}
else{
return true;
}
</script>
}
<div class="content">
<div class="wrap">
<div class="content-top">
<div class="listview_1_of_3 images_1_of_3">
<h3>Upcoming Movies</h3>
<div class="content-left">
<div class="listimg listimg_1_of_2">
<img src="admin/news_images/mummy.jpg">
</div>
<div class="text list_1_of_2">
<div class="extra-wrap">
<span style="text-color:#000"
class="data"><strong>The Mummy</strong><br>
<span style="text-color:#000"
class="data"><strong>Cast :Tom Cruiz</strong><br>
<div class="data">Release Date :2019-06-15</div>
 <span class="text-top">Thought safely entombed in a crypt deep beneath the desert, an
ancient princess whose destiny was unjustly taken from her is awakened in the modern era</span>
</div>
</div>
<div class="clear"></div>
</div>
<div class="content-left">
<div class="listimg listimg_1_of_2">
<img src="admin/news_images/tra.jpg">
</div>
<div class="text list_1_of_2">
<div class="extra-wrap">
<span style="text-color:#000"
class="data"><strong>Transformers: The Last Knight</strong><br>
<span style="text-color:#000"
class="data"><strong>Cast : Mark Wahlberg , Isabela Moner </strong><br>
<div class="data">Release Date :2019-07-21</div>

<span class="text-top">Humans are at war with the Transformers, and Optimus Prime
is gone. The key to saving the future lies buried in the secrets of the past and the hidden history of
Transformers on Earth</span>
</div>
</div>
<div class="clear"></div>
</div>
<div class="content-left">
<div class="listimg listimg_1_of_2">
<img src="admin/news_images/tiyan.jpg">
</div>
<div class="text list_1_of_2">
<div class="extra-wrap">
 <span style="text-color:#000"
class="data"><strong>Tiyan</strong><br>
<span style="text-color:#000"
class="data"><strong>Cast :Privthi Raj,Indrajith</strong><br>
<div class="data">Release Date :2019-10-18</div>

<span class="text-top">Tiyaan is an upcoming Indian Malayalam film written by

Murali Gopy and directed by Jiyen Krishnakumar.</span>
</div>
</div>
<div class="clear"></div>
</div>

</div>
<div class="listview_1_of_3 images_1_of_3">
<h3>Trending Trailers</h3>
<div class="middle-list">

<div class="listimg1">
<a target="_blank"
href="https://www.youtube.com/watch?v=4yRBJCrjabU"><img src="images/angamaly-diaries-2.jpg"
alt=""/></a>
<a target="_blank"
href="https://www.youtube.com/watch?v=4yRBJCrjabU" class="link">Angamaly Diaries</a>
</div>

<div class="listimg1">
<a target="_blank"
href="https://www.youtube.com/watch?v=Srp90Hp0G70"><img src="images/LUDO.jpg" alt=""/></a>
<a target="_blank"
href="https://www.youtube.com/watch?v=Srp90Hp0G70" class="link">LUDO </a>
</div>

<div class="listimg1">
 <a target="_blank"
href="https://www.youtube.com/watch?v=f5nvCp0QFdA"><img src="images/cia-new-poster-759.jpeg"
alt=""/></a>
<a target="_blank"
href="https://www.youtube.com/watch?v=f5nvCp0QFdA" class="link">Comarade In America</a>
</div>

<div class="listimg1">
<a target="_blank"
href="https://www.youtube.com/watch?v=hnICGugY6fI"><img src="images/godha.jpg" alt=""/></a>
<a target="_blank"
href="https://www.youtube.com/watch?v=hnICGugY6fI" class="link">Godha</a>
</div>

<div class="listimg1">
<a target="_blank"
href="https://www.youtube.com/watch?v=H6HK51qVdmc"><img src="images/raman.jpg" alt=""/></a>
<a target="_blank"
href="https://www.youtube.com/watch?v=H6HK51qVdmc" class="link">Ramante Edanthottam</a>
</div>
</div>

</div>

<div class="listview_1_of_3 images_1_of_3">

<h3>Films in Theaters</h3>

<div class="content-left">
<div class="listimg listimg_1_of_2">
<a
href="about.php?id=11"><img src="images/LUDO.jpg"></a>
</div>
<div class="text list_1_of_2">
<div class="extra-wrap1">
<a href="about.php?id=11" class="link4">LUDO </a><br>
<span class="data">Release Date:2021-01-04</span><br>
 Cast:<Span class="data">Abhishek Bachchan as Batukeshwar “Bittu” Tiwari
Aditya Roy Kapur as Akash Chauhan
Rajkummar Rao as Alok “Alu” Kumar Gupta
Pankaj Tripathi as Rahul Satyendra “Sattu” Tripathi
Fatima Sana Shaikh as Pinky Jain
Sanya Malhotra as Shruti Choksi
Rohit Suresh Saraf as Rahul Awasthi
Pearle Maaney as Sheeja Thomas</span><br>
Description: <span" class="color2">Ludo starts with two people contemplating
life and death and they decide to play ludo. The game they play correlates to the lives of Sattu Bhaiya,
Akash, Alu and Bittu.

Sattu Bhaiya is a notorious gangster who has to settle old scores with Bittu, who was once his right-hand
man. Sattu Bhaiya becomes the dice of Ludo and Bittu forms the red side in Ludo.

Akash and Shruti form the yellow side. They find that someone has recorded a video of their affair and
have uploaded it to the Internet. Then they start the race to find the culprit and take down the video before
Shruti's would-be husband finds out.

The blue side is formed by Sheeja Thomas and Rahul Avasthi. Sheeja is a Malayali nurse who speaks only
Malayalam and Rahul is a struggling young man from a small town being bullied by his boss. They find the
treasure of Sattu Bhaiya and the gang chases them and they try to escape.

The green side is formed by Alu and his sweet heart Pinky. Pinky's husband becomes a suspect in a
mu</span><br>
</div>
</div>

<div class="clear"></div>
</div>
<div class="content-left">
<div class="listimg listimg_1_of_2">
<a
href="about.php?id=8"><img src="images/godha.jpg"></a>
</div>
<div class="text list_1_of_2">
<div class="extra-wrap1">
 <a href="about.php?id=8" class="link4">Godha</a><br>
<span class="data">Release Date:2019-12-19</span><br>
Cast:<Span class="data">Tovino Thomas, Wamiqa Gabbi </span><br>
Description: <span" class="color2">Godha is an Malayalam Sports-Comedy
movie directed by Basil Joseph, starring Tovino Thomas, Wamiqa Gabbi and Renji Panicker in the lead
roles</span><br>
</div>
</div>

<div class="clear"></div>
</div>
<div class="content-left">
<div class="listimg listimg_1_of_2">
<a
href="about.php?id=3"><img src="images/angamaly-diaries-2.jpg"></a>
</div>
<div class="text list_1_of_2">
<div class="extra-wrap1">
<a href="about.php?id=3" class="link4">Angamaly Diaries</a><br>
<span class="data">Release Date:2019-12-01</span><br>
Cast:<Span class="data"> Reshma Rajan, Tito Wilson, Sarath Kumar</span><br>
Description: <span" class="color2">Angamaly Diaries is a 2019 Indian
Malayalam-language crime drama film directed by Lijo Jose Pellissery and written by Chemban Vinod
Jose.</span><br>
</div>
</div>

<div class="clear"></div>
</div>
 </div>
<div class="clear"></div>

</div>
</div>
<div class="footer">
<div class="wrap">
<div class="footer-top">
<div class="col_1_of_4 span_1_of_4">
<div class="footer-nav">
<ul>
<li><a href="index.php">Home</a></li>
<li><a href="movies_events.php">Movies</a></li>
<li><a href="login.php">Login</a></li>
</ul>
</div>
</div>
<div class="col_1_of_4 span_1_of_4">
<div class="textcontact">
<p>SVCE Theatre <br>
Ph: +91 82 980 870 31<br>
</p>
</div>
</div>
<div class="col_1_of_4 span_1_of_4">
<div class="call_info">
<p class="txt_3">Call us toll free:</p>
<p class="txt_4">1 800 234 23456</p>
</div>
</div>
<div class="col_1_of_4 span_1_of_4">
<div class=social>
<a href="#"><img src="images/fb.png" alt=""/></a>
<a href="#"><img src="images/tw.png" alt=""/></a>
 <a href="#"><img src="images/dribble.png"
alt=""/></a>
<a href="#"><img src="images/pinterest.png"
alt=""/></a>
</div>
</div>
<div class="clear"></div>
</div>
</div>
</div>
</body>
</html>

<style>
.content {
padding-bottom:0px !important;
}
#form111 {
width:500px;
margin:50px auto;
}
#search111{
padding:8px 15px;
background-color:#fff;
border:0px solid #dbdbdb;
}
#button111 {
position:relative;
padding:6px 15px;
left:-8px;
border:2px solid #207cca;
background-color:#207cca;
color:#fafafa;
}
#button111:hover {
background-color:#fafafa;
color:#207cca;
}

</style>

<script src="js/auto-complete.js"></script>
<link rel="stylesheet" href="css/auto-complete.css">
<script>
var demo1 = new autoComplete({
selector: '#search111',
minChars: 1,
source: function(term, suggest){
term = term.toLowerCase();
var string="";
//alert("'COMARADE IN AMERICA','ANGAMALY
DIARIES','GODHA','RAMANTE EDANTHOTTAM','LUDO ',");
var choices=['COMARADE IN AMERICA','ANGAMALY DIARIES','GODHA','RAMANTE
EDANTHOTTAM','LUDO ',];
var suggestions = [];
for (i=0;i<choices.length;i++)
if (~choices[i].toLowerCase().indexOf(term)) suggestions.push(choices[i]);
suggest(suggestions);
}
});
</script>
</div>
4.3 CONNECTION BETWEEN FRONT END AND BACK END

4.3.1 Connecting to a MySQL database

You need your MySQL server address (if the database is on the same server as the web
server it
will most likely be localhost or 127.0.0.1), username, password and database name. Add
the code
specified below to connect the database to the server and the html, css code.

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "db_movie";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die ("Connection failed: " . $conn->connect_error);
}
?>
Here the local host is the server name, root is the username and since I have not given
any
password that field is empty.
 CHAPTER-5
USER INTERFACES
1.MOVIE PAGE
2.HOME PAGE
3.USER LOGIN PAGE

4.ADMIN LOGIN PAGE

5.THEATRE LOGIN PAGE
 CONCLUSION

Nowadays, traditional reservation ways of cinema ticketing is dying. It’s new age where
technology dominates human life. With the software and technological devices,
exceptions are reduced and even terminated. Also, people prefer easy, quick and safe way
for every part of his life. This project is designed to meet the requirements of a cinema
ticket booking system. It has been developed in PHP and the database has been built in
My SQL server keeping in mind the specifications of the system. In our project: with this
cinema ticketing system; cinema companies can satisfy comfortable facilities to their
customers. The relationship between cinema manager, employee, and customer satisfy a
good communication to complete ticketing process. With this platform we developed, we
are hoping to reduce time wasting, avoid misunderstandings, provide easy data flow,
customer pleasure, and less hard work. We believe that we have accomplished our goals
and satisfied with the code we developed.
REFERENCES

[1] Elmasri and Navathe, “Fundamentals of Database Systems” , 3/e, Addison - Wesley,
2001
[2] A Silberschaltz, H.F. Korth, and S sudarshan, “Database System Concepts”, 3/e, Tata
Mcgraw Hill,1997
[3] Thomas M. Connolly, Carolyn E. Begg, “Database Systems & Practical Approach to
Design Implementation and Management”, 4/e, Addison – Wesley, 2005