A Project report on

ONLINE DJ BOOKING SYSTEM

Submitted in partial fulfilment of the requirement for the final year award of the degree

BACHELOR OF COMPUTER APPLICATION

Of
DON BOSCO COLLEGE (Co-Ed)
Yelagiri Hills TIRUPATTUR , TAMIL NADU
(Affiliated to Thiruvalluvar University )
Submitted by
GANESH S
Reg.No :35820U09026
Under the guidance of
Ms Jayashree Msc..,

Internal Guide
External Guide
Asst. Ms Jayashree
Assistant Professor, BCA Department
Don Bosco College, Yelagiri Hills

BONAFIDE CERTIFICATE
 ONLINE DJ BOOKING SYSTEM

A bonafide of GANESH S Final year BCA (Computer Application), DON

BOSCO COLLEGE (Co-Ed) who carried out this project report titled .“ONLINE
DJ BOOKING SYSTEM ” the research under my supervision certified further, that
the best of knowledge . the work reported here in does not form part of any other
project report or dissertation on the basis of which a degree or award was conferred
on this or any other candidate

FACULTY GUIDE HEAD OF THE

DEPARTMENT

VIVA VOCE DATE_______________________

INTERNAL EXAMINAR EXTERNAL

EXAMINAR
 ACKNOWLEDGEMENT

First I would like to thank almighty who is always with me in each and every step of
my life and my parents, my sisters, my brothers and all my dear friends and well-wishers who
assisted me in this project work.

My very special gratitude and heartfelt thanks to our beloved Rector, Rev.fr. Bosco
Augustine SDB For his blessings and wishes to carry this project work. I would like to
express my deep gratitude to our principal Rev Dr. Thaddeus Gregory for permitting me to
undertake this project work.

I extent my heartful thanks to our beloved Vice Principal Prof. Dr. Rajendran For
his esteemed support and for all the efforts which he has taken to provide necessary and
essential facilities to do this project work.

I also thank Mr. SATHISH Head of the department for him constant support for
completing this project in times.

I thank my project guide Mr. BASKAR for her moral support and valuable
suggestions offered throughout my project work.

My special thanks to all the faculty members who guided me throughout my project
work and also thank Mr Baskar. For giving me permission to carry out this project work in
their organization.

Last but not least, I thank all my respondents.

GANESH.S

TABLE OF THE CONTENTS

3
CHAPTE
R TITLE PAGE
NO NO
1 INTRODUCTION 7
1.1 PROJECT DESCRIPTION 7
1.2 SYSTEM SPECIFICATION 8
1.2.1 HARDWARE CONFIGURATION 8
1.2.2 SOFTWARE SPECIFICATION 8
1.2.3 SOFTWARE DESCRIPTION 9
2 SYSTEM STUDY 16
2.1 EXISTING SYSTEM 16
2.1.1 DRAWBACKS OF EXISTING 16
2.2 PROPOSED SYSTEM 17
3 SYSTEM DESIGN AND 19
DEVELOPMENT
3.1 INPUT DESIGN 19
3.2 OUTPUT DESIGN 20
3.3 DATABASE DESIGN 21
3.4 SYSTEM DEVELOPMENT 22
3.4.1 DESCRIPTION OF MODULES 22
4 SYSTEM TESTING AND 24
IMPLEMENTATION
4.1 SYSTEM TESTING 24
4.2 SYSTEM IMPLEMENTATION 25
4.2.1 APPENDICES 29
A DATA FLOW DIAGRAM 29
B TABLE STRUCTURE 31
C SCREENSHOTS 36
D REPORTS 40
4.3 SAMPLE CODE 49
4.3.1 ABOUT.php 49
4.3.2 INDEX .php 53

4
4.3.3 SERVICES.php 56
4.3.4 BOOK-SERVICES.php 60
4.3.5 CONTACT.php 68
5 CONCLUSION 74

5
CHAPTE-1

6
 1. INTRODUCTION

1.1 PROJECT DESCRIPTION

A Disk Jockey (DJ) plays musical recordings in parties or events. Roles of
these professionals vary depending on the purpose or the setting of the music. They
may work for radio stations where they play musical selections from playlists. The
Online DJ Booking System makes a DJ more profitable as they can be reached in the
web. This system is programmed using php and mysql is the database used.

In this project, the objective of this application is to develop a system that

effectively manages all the data related to the various DJ events that take place in a
function. The purpose is to maintain a centralized database of all DJ event related
information. The goal is to support various functions and processes necessary to
manage the data efficiently. This will end the practice of calling various DJ agencies
and explaining the various requirement, here the user can view the website and check
out the information about the ODJMS (Online DJ Management System) service and
they can also enquire and book the DJ. The admin manage the types of event, add or
remove the vent. The admin can view the number of bookings approved or rejected.

Online DJ Management is a process of organizing a professional and focused

event, for a particular target audience. It involves visualizing concepts, planning,
budgeting, organizing and executing events such as wedding, musical concerts,
corporate seminars, exhibitions, birthday celebrations, theme parties, etc.

Online DJ Management is a multi-million dollar industry, growing rapidly,

with events hosted regularly. Surprisingly, there is no formalized research conducted
to access the growth of this industry. The industry includes fields such as the MICE
(Meetings, Incentives and Events), exhibitions, conferences and seminars as well as
live music and sporting events. On the profession side, event management is a
glamorous and exciting profession that demands a lot of hard work and dynamism.
The logistics side of the industry is paid less than the sales/sponsorship side, though
some may say that these are two different industries.

7
1.2 SYSTEM SPECIFICATION

1.2.1 HARDWARE CONFIGURATION

Processor : Intel Pentium Dual core 2.40 Ghz

Mother Board : Mercury

RAM : 2GB

Hard Disk : 320 GB

Mouse : Logitech Optical Mouse

Keyboard : Logitech Multimedia

1.2.2 SOFTWARE SPECIFICATION

Operating System : Windows 7/10

Front-End : PHP

Back End : Mysql

8
1.2.3 SOFTWARE DESCRIPTION

PHP

The PHP Hypertext Preprocessor (PHP) is a server scripting language, used

for making dynamic web pages. PHP is an open source software and it is free to
download and use. PHP supports a wide range of databases like MySQL, Oracle,
Sybase, Solid, PostgreSQL etc,. The PHP project is designed to fulfill the following
objectives:

• Understand how server-side programming works on the web.

• PHP Basic syntax for variable types and calculations.
• Creating conditional structures.
• Storing data in arrays.
• Using PHP built-in functions and creating custom functions.
• Understanding POST and GET in form submission.
PHP code is usually processed on a web server by a PHP interpreter
implemented as a module, a daemon or as a Common Gateway Interface (CGI)
executable. On a web server, the result of the interpreted and executed PHP code –
which may be any type of data, such as generated HTML or binary image data –
would form the whole or part of an HTTP response. Various web template systems,
web content management systems, and web frameworks exist which can be
employed to orchestrate or facilitate the generation of that response.

Additionally, PHP can be used for many programming tasks outside the web
context, such as standalone graphical applications[11] and robotic drone control.[12]
PHP code can also be directly executed from the command line. The standard PHP
interpreter, powered by the Zend Engine, is free software released under the PHP
License. PHP has been widely ported and can be deployed on most web servers on a
variety of operating systems and platforms.

9
PHP Server
The PHP Community Provides Some types of Software Server solution under
The GNU (General Public License). These are the following:

• XAMPP Server
• WAMP Server
• LAMP Server
• MAMP Server

Here we are using XAMPP Server.

XAMPP Server

XAMPP is an open-source software developed and distributed by Apache

Friends. It is an acronym for X- Cross-Platform, A- Apache Server, M- MariaDB, P-
PHP, P- Pearl. XAMPP is one of the most common PHP servers packages used by
developers for developing the sites. It was the first platform of such capability. It
makes the task of installation of PHP Servers a lot easier for developers. You don’t
need any technical help to install XAMPP. Developers used to install each tool
separately, but XAMPP offered them all the tools in one-click installation. Hence, it
made the task less time-consuming. The user interface is simple and easy to learn.
Other than PHP, it also offers Pearl.

XAMPP is a free and open source cross-platform web server solution stack
package developed by Apache Friends, consisting mainly of the Apache HTTP
Server, MariaDB database, and interpreters for scripts written in the PHP and Perl
programming languages. XAMPP stands for Cross-Platform (X), Apache (A),
MariaDB (M), PHP (P) and Perl (P). It is a simple, lightweight Apache distribution
that makes it extremely easy for developers to create a local web server for testing
and deployment purposes. Everything needed to set up a web server – server
application (Apache), database (MariaDB), and scripting language (PHP) – is
included in an extractable file. XAMPP is also cross-platform, which means it works
equally well on Linux, Mac and Windows. Since most actual web server

10
deployments use the same components as XAMPP, it makes transitioning from a
local test server to a live server extremely easy as well.

PHP: Advantage

Most important advantage of PHP is that it’s open source and free from cost. It
can be downloaded at anywhere and readily available to use for event of web
applications. It is platform independent. PHP based applications can run on any OS
like UNIX, Linux and Windows, etc. Application can easily be loaded which are
based on PHP and connected to database. It’s mainly used due to its faster rate of
loading over slow internet speed than another programming language.

PHP has less learning curve, because it is simple and straightforward to use.
Someone familiar with C programming can easily work on PHP. It is more stable
from a few years with assistance of providing continuous support to various
versions. It helps in reusing an equivalent code and no got to write lengthy code and
sophisticated structure for event of web applications. It helps in managing code
easily and it has powerful library support to use various function modules for data
representation.

PHP’s built-in database connection modules help in connecting database easily

reduce trouble and time for development of web applications and content based sites.
Popularity of PHP gave rise to various community of developers, a fraction of which
may be potential candidates for hire. Flexibility makes PHP ready to effectively
combine with many other programming languages in order that the software package
could use foremost effective technology for every particular feature.

11
BACK END: MYSQL

MySQL Workbench is a unified visual tool for database architects, developers,

and DBAs. MySQL Workbench provides data modeling, SQL development, and
comprehensive administration tools for server configuration, user administration,
backup, and much more.
MySQL Workbench is available on Windows, Linux and Mac OS X.

MySQL is an open-source relational database management system (RDBMS). It

is the most popular database system used with PHP. MySQL is developed,
distributed, and supported by Oracle Corporation.

• The data in a MySQL database are stored in tables which consists of columns
and rows.
• MySQL is a database system that runs on a server.
• MySQL is ideal for both small and large applications.
• MySQL is very fast, reliable, and easy to use database system.It uses standard
SQL.
• MySQL compiles on a number of platforms.

RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS)

MySQL is a relational database management system. This database language

is based on the SQL queries to access and manage the records of the table.

EASY TO USE

MySQL is easy to use. We have to get only the basic knowledge of SQL. We
can build and interact with MySQL by using only a few simple SQL statements.

SECURE

MySQL consists of a solid data security layer that protects sensitive data
from intruders. Also, passwords are encrypted in MySQL.

12
CLIENT/ SERVER ARCHITECTURE

MySQL follows the working of a client/server architecture. There is a

database server (MySQL) and arbitrarily many clients (application programs), which
communicate with the server; that is, they can query data, save changes, etc.

SCALABLE

MySQL supports multi-threading that makes it easily scalable. It can handle

almost any amount of data, up to as much as 50 million rows or more. The default
file size limit is about 4 GB. However, we can increase this number to a theoretical
limit of 8 TB of data.

SPEED AND FLEXIBILITY

MySQL is considered one of the very fast database languages, backed by a

large number of the benchmark test. MySQL supports a large number of embedded
applications, which makes MySQL very flexible.

COMPATIBLE

SQL is compatible to run on many operating systems, like Novell NetWare,

Windows* Linux*, many varieties of UNIX* (such as Sun* Solaris*, AIX, and
DEC* UNIX), OS/2, FreeBSD*, and others. MySQL also provides a facility that the
clients can run on the same computer as the server or on another computer
(communication via a local network or the Internet).

HIGH PERFORMANCE

MySQL is faster, more reliable, and cheaper because of its unique storage
engine architecture. It provides very high-performance results in comparison to other
databases without losing an essential functionality of the software. It has fast loading
utilities because of the different cache memory.

13
GUI SUPPORT

MySQL provides a unified visual database graphical user interface tool named
"MySQL Workbench" to work with database architects, developers, and Database
Administrators. MySQL Workbench provides SQL development, data modeling, data
migration, and comprehensive administration tools for server configuration, user
administration, backup, and many more. MySQL has a fully GUI supports from
MySQL Server version 5.6 and higher.

--

14
CHAPTER-2

15
 2. SYSTEM STUDY

2.1 EXISTING SYSTEM

The Existing system is manual based and need lot of efforts and consume enough
time. In the existing system we cannot apply for DJ’s online and the allotment
processes are done manually. People can book DJ without knowing about them.

The existing system does not deals with mess calculation and complaint
registration. Each and every action is done manually using forms. It takes more time
to finish and also having chances of committing some mistakes for each action. The
maintenance is also difficult for the existing system. Also, the manual process
performs the above requirements it takes more time.

2.1.1 DRAWBACKS OF EXISTING SYSTEM

• People need to find the DJ’s Directly by their self.  Requires lots of time.
• It is difficult to maintain or update all records and retrieve a certain data. The
loss and damage of any of the registers leads to the damage of hundreds of
records a time.
• Records need to be generated manually. Data store on the Paper may be lost,
Stolen or destroyed due to natural calamity. Difficult to maintain or update
records all the records.
• There is lot of chances of human error and it lacks security. It has no backup
option.
So this may lead to reduce the chances of recovering data from record.
• High Cost of Maintenance.

16
2.2 PROPOSED SYSTEM

The proposed system is to overcome the drawbacks of existing system. This

project is aimed to develop a system for booking Dj and to find the current location
of events. This system will helpful for Dj event conducting companies to manage the
affairs of their business. This system will provide full information about a Dj event.
It will show events which are available or not and number of Dj or company number.
This system will also provide a report on the summary detail regarding price and
venues to users.

FEATURES OF PROPOSED SYSTEM

• Customers who make a decision to book a event don’t want to wait until you
are in the office, they want to lock in the activity on their own schedule.
Using an online booking system means that your business is open 24 hours a
day, seven days a week.
• Customers who book their own reservations are more likely to show up,
making noshows a thing of the past. If a customer does need to cancel, the
spot automatically opens online, giving another customer the chance to book
it. By maximizing your reservations, you won’t leave unused activity events.
• With an online dj booking system, you can require customers to prepay for
activities and rentals. This puts money into your pocket faster and helps make
sure that on the day of the event you don’t have to worry about payment.
• With an online booking system, you can require customers to prepay for
activities and rentals. This puts money into your pocket faster.
• With an online booking system, you can require customers to prepay for
activities and rentals. This puts money into your pocket faster and helps make
sure that on the day of the event you don’t have to worry about payment —
giving you and your customers more time to have fun.
• Easy to handle for updating or removing data.

17
CHAPTER-3

18
 3. SYSTEM DESIGN AND DEVELOPMENT

3.1 INPUT DESIGN

Input design is the process of converting user-oriented inputs to a computer-
based format. The quality of the system input determines the quality of system
output. Input design is a part of the overall system design, which requires very
careful attention. If the data going into the system is incorrect then the processing
and output will magnify these errors

Designs are used to enter the separate value for the process and methods.
Development can be made by one of the user. In this input design the user and admin
login to the page. Both also have a separate user id and password. User can update
their status. Admin is verifying the user status. The input design is the link between
the information system and the user.

It is achieved by creating user-friendly screens for the data entry to handle

large volume of data. The goal of designing input is to make data entry easier and to
be free from errors. The data entry screen is designed in such a way that all the data
manipulates can be performed. It also provides record viewing facilities.

The input design is made in various window forms such as

• DJ services - In this section, admin can manage services (add/delete).

• Type of Event: In this section, admin can manage event type (add/delete).
• Contact us Queries: In this section, admin can view and maintain the Queries.
• Search: In this section, admin can search booking details and user queries
with the help of name, mobile number, and booking id.
• Book Dj – User can book DJ’s.

19
3.2 OUTPUT DESIGN

Output design is very important concept in the computerized system, without

reliable output the user may feel the entire system is unnecessary and avoids using it.
The proper output design is important in any system and facilitates effective
decision-making.

The output design is an ongoing activity almost from the beginning of the project,
and follows the principles of form design. Effects and well define an output design
improves the relationship of system and the user, thus facilitating decision-making.

A quality output is one, which meets the requirements of the end user and presents
the information clearly. In any system results of processing are communicated to the
users and to other system through outputs. It is the most important and direct source
information to the user. Efficient and intelligent output design improves the system’s
relationship to help user decision-making.

The output form of an information system should accomplish one or more of the
following objectives.

• Convey information about past activities, current status or projections of the

• Future.

• Signal important events, opportunities, problems, or warnings.

• Trigger an action.

The output design is made in various window forms such as

• Dashboard - In this section, admin can see all detail in brief like the total
services, Total unread queries, Total read queries, Total new booking, Total
Approved booking, Total Cancelled Booking, and Total Event Type  Pages
- In this part user can see contact details of admin.
• Booking - In this section, admin can view new, approved, canceled bookings
and also give a remark.
• Reports - In this section, admin can view booking in a particular period.

20
3.3 DATABASE DESIGN

Database design is the process of producing a detailed data model of a database.

This logical data model contains all the needed logical and physical design choices
and physical storage parameters needed to generate a design in a Data Definition
Language, which can then be used to create a database. A fully attributed data model
contains detailed attributes for each entity.

In the relational model these are the tables and views. In an object database the
entities and relationships map directly to object classes and named relationships.
However, the term database design could also be used to apply to the overall process
of designing, not just the base data structures, but also the forms and queries used as
part of the overall database application within the database management system
(DBMS).The most important consideration in designing the database is how
information will be used. The main objectives of designing a database are:

Data integration

In a database, information from several file are coordinated, accessed and operated
upon as through it is in a single file. Logically, the information are centralized,
physically, the data may be located on different devices, connected through data
communication facilities.

Data integrity

Data integrity means storing all data in one place only and how each application to
access it. This approach results in more consistent information, one update being
sufficient to achieve a new record status for all applications which use it.

Conceptual design

The next step is to form a concise description of the data requirements using a high
level data model. This description would be independent of storage requirements.
This step involves identifying entities involves in the system, and the relationship
between the different entities. Entities and relationships are depicted in the form of a
diagram called the Entity relationship Diagram.

21
3.4 SYSTEM DEVELOPMENT

3.4.1 DESCRIPTION OF MODULES

The project consists of the following modules display as follows.

A) Admin module
B) User module

A) ADMIN MODULE
The admin module contains:
• Dashboard: In this section, admin can see all detail in brief like the total
services, Total unread queries, Total read queries, Total new booking, Total
Approved booking, Total Cancelled Booking, and Total Event Type.
• DJ Services: In this section, admin can manage services (add/delete).
• Type of Event: In this section, admin can manage event type (add/delete).
• Pages: In this section, the admin can manage about us and contact us pages.
• Booking: In this section, admin can view new, approved, canceled bookings
and also give a remark.
• Contact us Queries: In this section, admin can view and maintain the
Queries.
• Reports: In this section, admin can view booking in a particular period.
• Search: In this section, admin can search booking details and user queries
with the help of name, mobile number, and booking id
Admin can also update his profile, change the password and recover the password.

B) USER MODULE
The user module contains:
• About – Users can view the website and check out the information about
ODJMS services and they can also inquiry and book DJ.
• Book service – User can book service by using this module.
• Contact – User can drop name, e-mail id, mobile number and message to
give feedback.

22
CHAPTER-4

23
 4. SYSTEM TESTING AND IMPLEMENTATION

4.1 SYSTEM TESTING

The purpose of testing is to discover errors. Testing is the process of trying to

discover every conceivable fault or weakness in a work product. It provides a way to
check the functionality of components, sub assemblies, assemblies and/or a finished
product It is the process of exercising software with the intent of ensuring that the
Software system meets its requirements and user expectations and does not fail in an
unacceptable manner. There are various types of test. Each test type addresses a
specific testing requirement.

UNIT TESTING

The software units in the system are modules and routines that are assembled
and integrated to perform a specific function. As a part of unit testing we executed
the program for individual modules independently. This enables, to detect errors in
coding and logic that are contained within each of the three module. This testing
includes entering data that is filling forms and ascertaining if the value matches to
the type and entered into the database.
The various controls are tested to ensure that each performs its action as required.

INTEGRATION TESTING

Data can be lost across any interface, one module can have an adverse effect
on another, sub functions when combined, may not produce the desired major
functions. Integration testing is a systematic testing to discover errors associated
within the interface. The objective is to take unit tested modules and build a program
structure. All the modules are combined and tested as a whole. Here the admin
module, employee module and student module options are integrated and tested. This
testing provides the assurance that the application is well integrated functional unit
with smooth transition of data.

24
USER ACCEPTANCE TESTING
User acceptance of a system is the key factor for the success of any system.
The system under consideration is tested for user acceptance by constantly keep the
records of applicants and making changes to the details and password whenever
required.

4.2 SYSTEM IMPLEMENTATION

Implementation is the stage of the project when the theoretical design is turned out
into a working system. Thus it can be considered to be the most critical stage in
achieving a successful new system and in giving the user, confidence that the new
system will work and be effective. The implementation stage involves careful
planning, investigation of the existing system and it’s constraints on implementation,
designing of methods to achieve changeover and evaluation of changeover methods.

The major tasks involved in the implementation are:

• Computer based/system testing.

• Training the user personnel
• Full system testing and making the necessary changes as desired by the user.
• Change over.
• Maintenance.
The implementation strategy used is the parallel changeover. The automated
system has been put to use gradually so that its usage can prove better for the
concern. After the system has been tested, the implementation type or the change
over technique from the existing system to the new system is a step-by-step process.
When the end-user related to the particular module is satisfied with the performance,
the next step of implementation is preceded.

Implementation Procedures

Implementation means converting older system to a new design in operation. This

involves creating computer capable files and basic software needed to run this
system. The basic concept for implementation needed is software installation and
system requirements. So in order to implement them, suitable hardware and software

25
must be available. Now the computer is ready for implementing the proposed
system.

Creating an Entity-Relationship (ER) diagram for an online DJ booking system involves

identifying the main entities involved, their attributes, and the relationships between them.
Here's a basic ER diagram for such a system:

Entities:

User
DJ
Event
Booking
Payment
Attributes:

User:

UserID (Primary Key)

Username
Email
Password
Phone Number

DJ:

DJID (Primary Key)

DJName
Genre
Price
Rating

Event:

EventID (Primary Key)

EventType
Date
Time
Location
Description

Booking:

BookingID (Primary Key)

UserID (Foreign Key)
DJID (Foreign Key)
EventID (Foreign Key)
BookingDate

26
Status

Payment:

PaymentID (Primary Key)

BookingID (Foreign Key)
Amount
PaymentDate
PaymentMethod

Relationships:

User-Booking: One user can make many bookings; one booking is made by one user.
DJ-Booking: One DJ can be booked for many events; one event can have one DJ.
Event-Booking: One event can have many bookings; one booking is for one event.
Booking-Payment: One booking can have one payment; one payment is made for one
booking.
DJ-Rating: One DJ can have many ratings; one rating is given to one DJ.

Here's the ER diagram representation:

Sql

Copy code
+---------+ +---------+
| User | | DJ |
+---------+ +---------+
| |
| |
| |
| |
| |
+-----|----------------------|-----+
| v v |
| +-------+ +-------+ |
| |Event | |Booking| |
| +-------+ +-------+ |
| | ^ | ^ |
| | | | | |
| | | | | |
| | | | | |
| v | | v |

27
| +------------+ | +---------+
| | Payment | | | Rating |
| +------------+ | +---------+
+--------------------------+

In this diagram:
Each box represents an entity.
Lines between boxes represent relationships.
The symbols on the lines denote cardinality (one-to-one, one-
to-many, many-to-many).
This ER diagram provides a basic structure for an online DJ
booking system. Depending on the specific requirements and
functionalities of your system, you might need to further
refine and expand this model.

28
 APPENDICES

A. DATA FLOW DIAGRAM

LEVEL 0:

ODMS

User register LOGIN PAGE

User login

View of value
Abilities details

Book A Room & Know Details

About DJ Events

29
LEVEL 1:

Admin

Login

Add Services and Dashboard

Pages

Update or Remove View information of DJ

details services

30
B. TABLE STRUCTURE
Table Name : Admin Primary Key : Username

S.NO FIELD NAME FIELD TYPE SIZE DESCRIPTION

1 Username nvarchar 20 Unique

2 Password nvarchar 20 User password

3 Email nvarchar 40 Email

Table Name : Event type

S.NO FIELD NAME FIELD TYPE SIZE DESCRIPTION

1 ID nvarchar 20 ID

2 Event type nvarchar 20 Event type

3 Creation Date nvarchar 40 Event Creation Date

Table Name : Booking

S.NO FIELD NAME FIELD TYPE SIZE DESCRIPTION

31
 1 ID nvarchar 20 Unique

2 Booking ID nvarchar 40 User E-mail

3 Service ID nvarchar 20 User Password

4 Name nvarchar 20 Name

5 Mobile Number nvarchar 10 Number

20
6 Email nvarchar Email id

10
7 Event date nvarchar Event date

12
8 Event starting time nvarchar Starting time

12
9 Event Ending time nvarchar Ending time

50
10 Venue Address nvarchar Address

20
11 Event type nvarchar Event type

Additional 50
12 nvarchar Additional information
Information

10
13 Booking Date nvarchar Booking Date

10
14 Remark nvarchar Remarks

10
15 Status nvarchar Status

10
16 Updation Date nvarchar Updated date

Table Name : Pages

S.NO FIELD NAME FIELD TYPE SIZE DESCRIPTION

32
 1 ID nvarchar 5 ID

2 Page title nvarchar 20 Page title

3 Page type nvarchar 20 Page type

4 Page description nvarchar 50 Page description

5 Email nvarchar 20 email

6 Mobile no nvarchar 10 Mobile number

Table Name : Service

S.NO FIELD NAME FIELD TYPE SIZE DESCRIPTION

1 Id nvarchar 20 ID

33
 2 Service name nvarchar 20 Service name

3 SerDes nvarchar 30 Service description

4 ServicePrice nvarchar 20 Service price

Table Name : User

S.NO FIELD NAME FIELD TYPE SIZE DESCRIPTION

1 ID nvarchar 5 ID

2 Name nvarchar 20 Name

3 Mobile number nvarchar 10 Mobile Number

4 Email nvarchar 20 Email id

5 Message nvarchar 50 Message

6 Message date nvarchar 10 Message date

7 Is read nvarchar 10 Is read

34
C. SCREENSHOTS

Fig.1: Home page

35
Fig.2: About us

36
Fig.3: Service

37
Fig.4: Contact Us

38
D. REPORTS

Fig.5: Admin Login

39
Fig.6: Dash board

40
Fig.7: Add Service

41
Fig.8: Manage Service

42
Fig.9: New booking

43
Fig.10: Approved Booking

44
Fig.11: Total Booking

45
Fig.12: Search Booking

46
Fig.13: Search User Queries

47
 4.3 SAMPLE CODE

4.3.1 ABOUT.php

<?php
session_start();
error_reporting(0);

include('includes/dbconnection.php');
?>
<!DOCTYPE html>
<html>
<head>
<title>Online DJ Management System || About Us</title>
<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />
<!-- Custom Theme files -->
<link href="css/style.css" rel="stylesheet" type="text/css" media="all" />
<link rel="stylesheet" href="css/touchTouch.css" type="text/css" media="all" />
<!-- Custom Theme files -->
<script src="js/jquery.min.js"></script>
<script type="application/x-javascript"> addEventListener("load", function()
{ setTimeout(hideURLbar, 0); }, false); function hideURLbar()
{ window.scrollTo(0,1); } </script>
<!--webfont-->
<link href='http://fonts.googleapis.com/css?family=Monoton' rel='stylesheet'
type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Raleway' rel='stylesheet'
type='text/css'>
<!---//End-css-style-switecher----->
<script type="text/javascript" src="js/jquery.fancybox.js"></script>
<link rel="stylesheet" type="text/css" href="css/jquery.fancybox.css"
media="screen" />
<script type="text/javascript">

48
 $(document).ready(function() {
/*
* Simple image gallery. Uses default settings
*/

$('.fancybox').fancybox();

});
</script>

</head>
<body>
<!---->
<?php include_once('includes/header.php');?>
<div class="about content">
<div class="container">
<ol class="breadcrumb">
<li><a href="index.php">Home</a></li>
<li class="active">About</li>
</ol>
<?php
$sql="SELECT * from tblpage where PageType='aboutus'";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);

$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $row)
{ ?>
<h2><?php echo htmlentities($row->PageTitle);?></h2>
<div class="about-main">
<div class="col-md-6 abt-pic">

49
 <img src="images/abt.jpg" class="img-responsive"
alt=""/>
</div>
<div class="col-md-6 abt-pic-info">

<p style="color:#fff"><?php echo $row-

>PageDescription;?>.</p>

</div>
<?php $cnt=$cnt+1;}} ?>
<div class="clearfix"></div>
</div>

<div class="latest">
<h3>LATEST PHOTOS</h3>
<div class="pic start">
<a class="fancybox" href="images/4.jpg" data-
fancybox-group="gallery" title="Lorem ipsum dolor sit amet"><img
src="images/4.jpg" class="img-style row6" alt=""><span> </span></a>
<h4><a href="event.html">Aenean rutrum</a></h4>
<p>Suspendisse posuere enim eu ante scelerisque,
vehicula turpis.</p>
</div>
<div class="pic">
<a class="fancybox" href="images/5.jpg" data-
fancybox-group="gallery" title="Lorem ipsum dolor sit amet"><img
src="images/5.jpg" class="img-style row6" alt=""><span> </span></a>
<h4><a href="event.html">Aenean rutrum</a></h4>
<p>Suspendisse posuere enim eu ante scelerisque,
vehicula turpis.</p>
</div>
<div class="pic">
<a class="fancybox" href="images/6.jpg" data-
fancybox-group="gallery" title="Lorem ipsum dolor sit amet"><img
src="images/6.jpg" class="img-style row6" alt=""><span> </span></a>
<h4><a href="event.html">Aenean rutrum</a></h4>

50
 <p>Suspendisse posuere enim eu ante scelerisque,
vehicula turpis.</p>
</div>
<div class="pic">
<a class="fancybox" href="images/7.jpg" data-
fancybox-group="gallery" title="Lorem ipsum dolor sit amet"><img
src="images/7.jpg" class="img-style row6" alt=""><span> </span></a>
<h4><a href="event.html">Aenean rutrum</a></h4>
<p>Suspendisse posuere enim eu ante scelerisque,
vehicula turpis.</p>
</div>
<div class="pic">
<a class="fancybox" href="images/8.jpg" data-
fancybox-group="gallery" title="Lorem ipsum dolor sit amet"><img
src="images/8.jpg" class="img-style row6" alt=""><span> </span></a>
<h4><a href="event.html">Aenean rutrum</a></h4>
<p>Suspendisse posuere enim eu ante scelerisque,
vehicula turpis.</p>
</div>
<div class="clearfix"></div>
</div>
<?php include_once('includes/footer.php');?>
</div>
</div>
<!---->

<!---->
</body>
</html>

51
 4.3.2 INDEX.php

<!DOCTYPE html>
<html>
<head>
<title>Online DJ Booking System||Home Page</title>
<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />
<!-- jQuery (Bootstrap's JavaScript plugins) -->
<script src="js/jquery.min.js"></script>
<script type="application/x-javascript"> addEventListener("load", function()
{ setTimeout(hideURLbar, 0); }, false); function hideURLbar()
{ window.scrollTo(0,1); } </script>
<!-- Custom Theme files -->
<link href="css/style.css" rel="stylesheet" type="text/css" media="all" />

<link href='http://fonts.googleapis.com/css?family=Monoton' rel='stylesheet'

type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Raleway' rel='stylesheet'
type='text/css'>
</head>
<body>
<!---->
<?php include_once('includes/header.php');?>
<!---->
<script src="js/responsiveslides.min.js"></script>
<script>
// You can also use "$(window).load(function() {"
$(function () {
$("#slider").responsiveSlides({
auto: true,
manualControls: '#slider3-pager',
});
});
</script>

52
<div class="content">
<div class="container">
<div class="slider">
<!-- Slideshow 3 -->
<ul class="rslides" id="slider">
<li><img src="images/7.jpg" alt="">
<div class="caption">
<h1>Image1</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
<li><img src="images/2.jpg" alt="">
<div class="caption">
<h1>Image2</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
<li><img src="images/10.jpg" alt="">
<div class="caption">
<h1>Image3</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
<li><img src="images/5.jpg" alt="">
<div class="caption">
<h1>Image1</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
<li><img src="images/8.jpg" alt="">
<div class="caption">

53
 <h1>Image2</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
<li><img src="images/1.jpg" alt="">
<div class="caption">
<h1>Image3</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
<li><img src="images/13.jpg" alt="">
<div class="caption">
<h1>Image2</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
<li><img src="images/3.jpg" alt="">
<div class="caption">
<h1>Image3</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
</ul>
<!-- Slideshow 3 Pager --></br></br>
<ul id="slider3-pager">
<li><a href="#"><img src="images/77.jpg" alt=""></a></li>
<li><a href="#"><img src="images/22.jpg" alt=""></a></li>
<li><a href="#"><img src="images/1010.jpg" alt=""></a></li>
<li><a href="#"><img src="images/55.jpg" alt=""></a></li>
<li><a href="#"><img src="images/88.jpg" alt=""></a></li>
<li><a href="#"><img src="images/11.jpg" alt=""></a></li>

54
 <li><a href="#"><img src="images/1313.jpg" alt=""></a></li>
<li><a href="#"><img src="images/33.jpg" alt=""></a></li>
</ul>
<div class="clearfix"></div>
</div>
</div>
<?php include_once('includes/footer.php');?>
</div>
<!---->

<!---->
</body>
</html>

3. SERVICES.php

<!DOCTYPE html>
<html>
<head>
<title>Online DJ Booking System||Home Page</title>
<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />
<!-- jQuery (Bootstrap's JavaScript plugins) -->
<script src="js/jquery.min.js"></script>
<script type="application/x-javascript"> addEventListener("load", function()
{ setTimeout(hideURLbar, 0); }, false); function hideURLbar()
{ window.scrollTo(0,1); } </script>
<!-- Custom Theme files -->
<link href="css/style.css" rel="stylesheet" type="text/css" media="all" />

<link href='http://fonts.googleapis.com/css?family=Monoton' rel='stylesheet'

type='text/css'>

55
<link href='http://fonts.googleapis.com/css?family=Raleway' rel='stylesheet'
type='text/css'>
</head>
<body>
<!---->
<?php include_once('includes/header.php');?>
<!---->
<script src="js/responsiveslides.min.js"></script>
<script>
// You can also use "$(window).load(function() {"
$(function () {
$("#slider").responsiveSlides({
auto: true,
manualControls: '#slider3-pager',
});
});
</script>
<div class="content">
<div class="container">
<div class="slider">
<!-- Slideshow 3 -->
<ul class="rslides" id="slider">
<li><img src="images/7.jpg" alt="">
<div class="caption">
<h1>Image1</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
<li><img src="images/2.jpg" alt="">
<div class="caption">
<h1>Image2</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>

56
 </div>
</li>
<li><img src="images/10.jpg" alt="">
<div class="caption">
<h1>Image3</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
<li><img src="images/5.jpg" alt="">
<div class="caption">
<h1>Image1</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
<li><img src="images/8.jpg" alt="">
<div class="caption">
<h1>Image2</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
<li><img src="images/1.jpg" alt="">
<div class="caption">
<h1>Image3</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
<li><img src="images/13.jpg" alt="">
<div class="caption">
<h1>Image2</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>

57
 </div>
</li>
<li><img src="images/3.jpg" alt="">
<div class="caption">
<h1>Image3</h1>
<p>Nam est purus, egestas eu varius in, commodo
vitae massa. Fusce mollis a lacus in tincidunt.</p>
</div>
</li>
</ul>
<!-- Slideshow 3 Pager --></br></br>
<ul id="slider3-pager">
<li><a href="#"><img src="images/77.jpg" alt=""></a></li>
<li><a href="#"><img src="images/22.jpg" alt=""></a></li>
<li><a href="#"><img src="images/1010.jpg" alt=""></a></li>
<li><a href="#"><img src="images/55.jpg" alt=""></a></li>
<li><a href="#"><img src="images/88.jpg" alt=""></a></li>
<li><a href="#"><img src="images/11.jpg" alt=""></a></li>
<li><a href="#"><img src="images/1313.jpg" alt=""></a></li>
<li><a href="#"><img src="images/33.jpg" alt=""></a></li>
</ul>
<div class="clearfix"></div>
</div>
</div>
<?php include_once('includes/footer.php');?>
</div>
<!---->

<!---->
</body>
</html>

58
 4. BOOK-SERVICES.php

<?php
session_start();
error_reporting(0);
include('includes/dbconnection.php');

if(isset($_POST['submit']))
{
$bid=$_GET['bookid'];

$name=$_POST['name'];
$mobnum=$_POST['mobnum'];
$email=$_POST['email'];
$edate=$_POST['edate'];
$est=$_POST['est'];
$eetime=$_POST['eetime'];
$vaddress=$_POST['vaddress'];
$eventtype=$_POST['eventtype'];
$addinfo=$_POST['addinfo'];
$bookingid=mt_rand(100000000, 999999999);
$sql="insert into
tblbooking(BookingID,ServiceID,Name,MobileNumber,Email,EventDate,EventStart
ingtime,EventEndingtime,VenueAddress,EventType,AdditionalInformation)values(:
bookingid,:bid,:name,:mobnum,:email,:edate,:est,:eetime,:vaddress,:eventtype,:addin
fo)";
$query=$dbh->prepare($sql);
$query->bindParam(':bookingid',$bookingid,PDO::PARAM_STR);
$query->bindParam(':bid',$bid,PDO::PARAM_STR);
$query->bindParam(':name',$name,PDO::PARAM_STR);
$query->bindParam(':mobnum',$mobnum,PDO::PARAM_STR);
$query->bindParam(':email',$email,PDO::PARAM_STR);
$query->bindParam(':edate',$edate,PDO::PARAM_STR);
$query->bindParam(':est',$est,PDO::PARAM_STR);

59
$query->bindParam(':eetime',$eetime,PDO::PARAM_STR);
$query->bindParam(':vaddress',$vaddress,PDO::PARAM_STR);
$query->bindParam(':eventtype',$eventtype,PDO::PARAM_STR);
$query->bindParam(':addinfo',$addinfo,PDO::PARAM_STR);

$query->execute();
$LastInsertId=$dbh->lastInsertId();
if ($LastInsertId>0) {
echo '<script>alert("Your Booking Request Has Been Send. We Will Contact You
Soon")</script>';
echo "<script>window.location.href ='services.php'</script>";
}
else
{
echo '<script>alert("Something Went Wrong. Please try again")</script>';
}

?>
<!DOCTYPE html>
<html>
<head>
<title>Online DJ Management System || Contact Us</title>
<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />
<!-- Custom Theme files -->
<link href="css/style.css" rel="stylesheet" type="text/css" media="all" />
<link rel="stylesheet" href="css/touchTouch.css" type="text/css" media="all" />
<!-- Custom Theme files -->
<script src="js/jquery.min.js"></script>

<script type="application/x-javascript"> addEventListener("load", function()

{ setTimeout(hideURLbar, 0); }, false); function hideURLbar()
{ window.scrollTo(0,1); } </script>

60
<!--webfont-->
<link href='http://fonts.googleapis.com/css?family=Monoton' rel='stylesheet'
type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Raleway' rel='stylesheet'
type='text/css'>
<!---//End-css-style-switecher----->
<script type="text/javascript" src="js/jquery.fancybox.js"></script>
<link rel="stylesheet" type="text/css" href="css/jquery.fancybox.css"
media="screen" />
<script type="text/javascript">
$(document).ready(function() {
/*
* Simple image gallery. Uses default settings
*/

$('.fancybox').fancybox();

});
</script>

</head>
<body>
<?php include_once('includes/header.php');?>
<div class="contact content">
<div class="container">
<ol class="breadcrumb">
<li><a href="index.php">Home</a></li>
<li class="active">Book Services</li>
</ol>

<div class="contact-grids">
<div class="col-md-6 contact-left">
<p>Book Your Events now. </p>

61
 <form method="post">

<ul>
<li class="text-info">Name: </li>
<li><input type="text" class="form-
control" name="name" required="true"></li>
</ul>

<ul>
<li class="text-info">Email: </li>
<li><input type="email" class="form-
control" name="email" required="true"></li>
</ul>
<ul>
<ul>
<li class="text-info">Mobile Number:
</li>
<li><input type="text" class="text"
name="mobnum" required="true" maxlength="10" pattern="[0-9]+"></li>
</ul>
<li class="text-info">Event Date: </li>
<li><input type="date" class="form-
control" name="edate" required="true"></li>
</ul>
<ul>
<li class="text-info">Event Starting
Time:</li>
<li><select type="text" class="form-
control" name="est" required="true">
<option value="">Select
Starting Time</option>
<option value="1 a.m">1
a.m</option>
<option value="2 a.m">2
a.m</option>
<option value="3 a.m">3
a.m</option>

62
 <option value="4 a.m">4
a.m</option>
<option value="5 a.m">5
a.m</option>
<option value="6 a.m">6
a.m</option>
<option value="7 a.m">7
a.m</option>
<option value="8 a.m">8
a.m"</option>
<option value="9 a.m">9
a.m</option>
<option value="10 a.m">10
a.m</option>
<option value="11 a.m">11
a.m</option>
<option value="12 p.m">12
a.m</option>
<option value="1 p.m">1
p.m</option>
<option value="2 p.m">2
p.m</option>
<option value="3 p.m">3
p.m</option>
<option value="4 p.m">4
p.m</option>
<option value="5 p.m">5
p.m</option>
<option value="6 p.m">6
p.m</option>
<option value="7 p.m">7
p.m</option>
<option value="8 p.m">8
p.m</option>
<option value="9 p.m">9
p.m</option>
<option value="10 p.m">10
p.m</option>

63
 <option value="10 p.m">10
p.m</option>
<option value="12 a.m">12
a.m</option>
</select></li>
</ul>
<ul>
<li class="text-info">Event Finish
Time:</li>
<li><select type="text" class="form-
control" name="eetime" required="true">
<option value="">Select Finish
Time</option>
<option value="1 a.m">1
a.m</option>
<option value="2 a.m">2
a.m</option>
<option value="3 a.m">3
a.m</option>
<option value="4 a.m">4
a.m</option>
<option value="5 a.m">5
a.m</option>
<option value="6 a.m">6
a.m</option>
<option value="7 a.m">7
a.m</option>
<option value="8 a.m">8
a.m"</option>
<option value="9 a.m">9
a.m</option>
<option value="10 a.m">10
a.m</option>
<option value="11 a.m">11
a.m</option>
<option value="12 p.m">12
a.m</option>

64
 <option value="1 p.m">1
p.m</option>
<option value="2 p.m">2
p.m</option>
<option value="3 p.m">3
p.m</option>
<option value="4 p.m">4
p.m</option>
<option value="5 p.m">5
p.m</option>
<option value="6 p.m">6
p.m</option>
<option value="7 p.m">7
p.m</option>
<option value="8 p.m">8
p.m</option>
<option value="9 p.m">9
p.m</option>
<option value="10 p.m">10
p.m</option>
<option value="10 p.m">10
p.m</option>
<option value="12 a.m">12
a.m</option>
</select></li>
</ul>
<ul>
<li class="text-info">Venue
Address:</li>
<li><textarea type="text" class="form-
control" name="vaddress" required="true" ></textarea></li>
</ul>
<ul>
<li class="text-info">Type of
Event:</li>
<li><select type="text" class="form-
control" name="eventtype" required="true" >

65
 <option value="">Choose Event
Type</option>
<?php

$sql2 = "SELECT * from tbleventtype ";

$query2 = $dbh -> prepare($sql2);
$query2->execute();
$result2=$query2->fetchAll(PDO::FETCH_OBJ);

foreach($result2 as $row)
{
?>
<option value="<?php echo htmlentities($row->EventType);?>"><?php echo
htmlentities($row->EventType);?></option>
<?php } ?>
</select></li>
</ul>
<ul>
<li class="text-info">Additional
Information:</li>
<li><textarea type="text" class="form-
control" name="addinfo" required="true"></textarea></li>
</ul>
<input type="submit" name="submit"
value="Book">
</form>
</div>
<div class="col-md-6 contact-right">
<div class="contact-map">
<img src="images/431427.jpg" class="img-
responsive" height="900" width="500" alt=""/>
</div>
</div>
<div class="clearfix"></div>
</div>

66
 </div>
<?php include_once('includes/footer.php');?>
</div>
</div>
<!---->

<!---->
</body>
</html>

5. CONTACT.php

<?php
session_start();
error_reporting(0);
include('includes/dbconnection.php');

if(isset($_POST['submit']))
{
$name=$_POST['name'];
$mobnum=$_POST['mobnum'];
$email=$_POST['email'];
$msg=$_POST['message'];
$sql="insert into
tbluser(Name,MobileNumber,Email,Message)values(:name,:mobnum,:email,:msg)";
$query=$dbh->prepare($sql);
$query->bindParam(':name',$name,PDO::PARAM_STR);
$query->bindParam(':mobnum',$mobnum,PDO::PARAM_STR);
$query->bindParam(':email',$email,PDO::PARAM_STR);
$query->bindParam(':msg',$msg,PDO::PARAM_STR);
$query->execute();
$LastInsertId=$dbh->lastInsertId();
if ($LastInsertId>0) {

67
 echo '<script>alert("Your Message Has Been Send. We Will Contact You
Soon")</script>';
echo "<script>window.location.href ='contact.php'</script>";
}
else
{
echo '<script>alert("Something Went Wrong. Please try again")</script>';
}

?>
<!DOCTYPE html>
<html>
<head>
<title>Online DJ Booking System || Contact Us</title>
<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />
<!-- Custom Theme files -->
<link href="css/style.css" rel="stylesheet" type="text/css" media="all" />
<link rel="stylesheet" href="css/touchTouch.css" type="text/css" media="all" />
<!-- Custom Theme files -->
<script src="js/jquery.min.js"></script>

<script type="application/x-javascript"> addEventListener("load", function()

{ setTimeout(hideURLbar, 0); }, false); function hideURLbar()
{ window.scrollTo(0,1); } </script>
<!--webfont-->
<link href='http://fonts.googleapis.com/css?family=Monoton' rel='stylesheet'
type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Raleway' rel='stylesheet'
type='text/css'>
<!---//End-css-style-switecher----->
<script type="text/javascript" src="js/jquery.fancybox.js"></script>
<link rel="stylesheet" type="text/css" href="css/jquery.fancybox.css"
media="screen" />

68
 <script type="text/javascript">
$(document).ready(function() {
/*
* Simple image gallery. Uses default settings
*/

$('.fancybox').fancybox();

});
</script>

</head>
<body>
<?php include_once('includes/header.php');?>
<div class="contact content">
<div class="container">
<ol class="breadcrumb">
<li><a href="index.php">Home</a></li>
<li class="active">Contact</li>
</ol>
<?php
$sql="SELECT * from tblpage where PageType='contactus'";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);

$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $row)
{ ?>
<h2><?php echo htmlentities($row->PageTitle);?></h2>
<div class="contact-main">

69
 <h4 style="color: white"><span class="glyphicon glyphicon-home"
aria-hidden="true"> <?php echo htmlentities($row->PageDescription);?></h4>
<br>
<h4 style="color: white"><span class="glyphicon glyphicon-
envelope" aria-hidden="true"> <?php echo htmlentities($row->Email);?></h4>
<br>
<h4 style="color: white"><span class="glyphicon
glyphicon-phone" aria-hidden="true"> <?php echo htmlentities($row-
>MobileNumber);?></h4>
<?php $cnt=$cnt+1;}} ?>

<div class="contact-grids">
<div class="col-md-6 contact-left">
<p>or drop a message we wiil reply you soon, </p>
<form method="post">
<ul>
<li class="text-info">Name: </li>
<li><input type="text" class="text"
name="name" required="true" ></li>
</ul>

<ul>
<li class="text-info">Email: </li>
<li><input type="text" class="text"
name="email" required="true"></li>
</ul>
<ul>
<li class="text-info">Mobile Number:
</li>
<li><input type="text" class="text"
name="mobnum" required="true" maxlength="10" pattern="[0-9]+"></li>
</ul>
<ul>
<li class="text-info">Message:</li>
<li><textarea value="Write here"
name="message" required="true"></textarea></li>

70
 </ul>
<input type="submit" name="submit"
value="Submit">
</form>
</div>
<div class="col-md-6 contact-right">
<div class="contact-map">
<iframe
src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!
1d1578265.0941403757!2d-98.9828708842255!3d39.41170802696131!2m3!1f0!
2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x54eab584e432360b
%3A0x1c3bb99243deb742!2sUnited+States!5e0!3m2!1sen!2sin!
4v1407515822047"> </iframe>
</div>
</div>
<div class="clearfix"></div>
</div>
</div>
<?php include_once('includes/footer.php');?>
</div>
</div>
<!---->

<!---->
</body>
</html>

71
CHAPTER-5

72
 5. CONCLUSION
The ―ODJMS (Online DJ Booking System)‖ was successfully designed and
is tested for accuracy and quality. During this project we have accomplished all the
objectives and this project meets the needs of the organization. The developed will
be used in searching, retrieving and generating information for the concerned
requests.

As the name suggests, it means conceptualizing, planning, organizing and

finally executing an event. The event could be of any type - musical show, concert,
exhibition, product launching etc. This industry is just eight years old in India, but
holds a lot of promise for expansion. It offers enormous scope for ambitious young
people. Event management is the planning and implementation of events, large and
small that meet the marketing goals of an organization. Event management is an area
that is growing rapidly, and isexpected to have a better growth rate in the next
decade. Typical events organized by professional event managers include product
launches, parties, sponsored events, sporting events, competitions, concerts and
festivals, fundraisers, trade shows, corporate open days, seminars and tours

FUTURE ENHANCEMENT

DJ Event management is a exciting profession which demands a lot of hard

work and dynamism. Companies should consider investing in information
technology platform for easy monitoring and transactions processing. This is because
the use of business information systems can help in reducing the cost of doing
business and also improve on the decision-making process since information that
suppo1is decision making can be accessed in a faster and timely way. DJ Event
Planners should ensure that the customer's privacy and security 1s maximum to
avoid losses. The development of a mobile application version for this system would
be a great innovation as it would sease the processes of accessibility

73
 BIBILIOGRAPHY

BOOK REFERENCES

1. Arthorne, J.; Laffra, C. (2004). Official eclipse 3.0 FAQs, Addison – Wesley
Professional.
2. Bernardi, M. L.; Lucca, G. A. D., Improving Design Patterns Modularity
Using Aspect Orientation, RCOST, University of Saunio, Italy.
3. Boehm, B. (1986). A Spiral Model of Software Development and
Enhancement,
ACM SIGSOFT Software Engineering Notes, ACM, 11, 4 (August, 1986),
pp.14-24.
4. Clement, A. et al. (2003), Aspect-Oriented Programming with AJDT,
Workshop on Analysis of Aspect-Oriented Software, ECOOP 2003.
5. Dijkstra, E.W. (1974). On the role of scientific thought, EWD 447 (Nuenen,
The th
Netherlands, 30 August 1974).
6. Whitten, Bentley, and Dittman. 2004. System Analysis and Design Methods
(5th ed).
McGraw-Hill: New York, NY.
7. PerlScriptsJavaScripts.com. 2006. ―MySQL Tutorial, Database Commands,
Beginners Guide‖.
http://www.perlscriptsjavascripts.com/tutorials/mysql/index.html.
Accessed 2/3/06.

WEBSITE REFERENCES

1. http://www.tutorialspoint.com
2. https://www.w3schools.com/
3. in.php.net
4. en.wikipedia.org/wiki/PHP
5. www.hotscripts.com/category/php/
6. www.apache.org/
7. www.mysql.com/click.php?e=35050

74