VISVESVARAYA TECHNOLOGICAL

UNIVERSITY
“Jnana Sangama”, Belgaum-590018

2022-2023
A Mini project Report On

“COLLEGE EVENT MANAGEMENT SYSTEM”

SUBMITTED FOR V SEM MINI PROJECT OF DBMS
LAB WITH MINI PROJECT (18CSL58)

BACHELOR OF ENGINEERING
IN
INFORMATION SCIENCE & ENGINEERING

Submitted By,
THARUN REDDY M (1AM20IS104)

Under the Guidance of

Mrs. Ayain John
Assistant Professor, Dept. of ISE
And
Mrs. Navya Damodar
Assistant Professor, Dept. of ISE

AMC ENGINEERING COLLEGE

DEPARTMENT OF INFORMATION SCIENCE AND ENGINEERING
18th K.M. Bannerghatta Main Road, Bengaluru-560083
 AMC ENGINEERING COLLEGE
18th K.M. Bannerghatta Main Road, Bengaluru-560083
DEPARTMENT OF INFORMATION SCIENCE AND ENGINEERING

CERTIFICATE

Certified that the project work entitled “COLLEGE EVENT MANAGEMENT SYSTEM” has
been successfully completed by NITISH REDDY PATIL (1AM20IS064), SANTHOSH
KUMAR REDDY G (1AM20IS085), SHARAN KUMAR N (1AM20IS087), THARUN
REDDY M (1AM20IS104), all bonafide students of AMC ENGINEERING COLLEGE,
Bengaluru in partial fulfilment of the requirements for award of degree in Bachelor of
Engineering in Information Science and Engineering of Visvesvaraya Technological
University, Belgaum during the academic year 2022-2023. The project report has been
approved as it satisfies the academic requirements in respect of project work for the said degree.

Mrs. Ayain John DR. M. Sathya Dr. Girisha C

Project Guide Associate Professor & HOD Principal
Assistant Professor Department of ISE AMCEC
Department of ISE AMCEC
 AMC ENGINEERING COLLEGE
18 K.M. Bannerghatta Main Road, Bengaluru-560083
th

DECLARATION

We, NITISH REDDY PATIL (1AM20IS064), SANTHOSH KUMAR REDDY G

(1AM20IS085), SHARAN KUMAR N (1AM20IS087), THARUN REDDY M (1AM20IS104),
students of V semester of BE, Information Science and Engineering, AMC Engineering College
hereby declare that the Mini project work entitled “COLLEGE EVENT MANAGEMENT
SYSTEM” has been carried out by us at AMC Engineering College, Bengaluru and submitted in
partial fulfilment of the course requirements of Bachelor of Engineering in Information Science
and Engineering of Visvesvaraya Technological University, Belagavi, during the academic
year 2022-2023.We also declare that, to the best of our knowledge and belief, the work reported
here does not from part of any other dissertation on the basis of which a degree or an award was
conferred on an earlier occasion on this by any other student.

Date:
Place: Bengaluru NITISH REDDY PATIL (1AM20IS064)

SANTHOSH KUMAR REDDY G (1AM20IS085)

SHARAN KUMAR N (1AM20IS087)

THARUN REDDY M (1AM20IS104)

 AMC ENGINEERING COLLEGE
18 K.M. Bannerghatta Main Road, Bengaluru-560083
th

ACKNOWLEDGEMENT
At the very onset, we would like to place our gratitude on all those people who helped us in
making this project successful one.

Coming up, this project to be a success was not easy. Apart from the sheer effort, the
enlightenment of our very experienced teachers also a paramount role because it is they who
guide us in the right direction.

First of all, we would like to thank the Management of AMC Engineering College for
providing such a healthy environment for the successful completion of the project work.

In this regard, we express our sincere gratitude to the Principal Dr. Girisha C., for providing
us all the facilities in this college.

We are extremely grateful to our Head of the Department Dr. M. Sathya, for having
accepted to patronize us in the right direction with all her wisdom.

We place our heartfelt thanks to Mrs. Ayain John, Assistant Professor and Mrs Navya
Damodar, Assistant Professor Department of Information Science and Engineering for
having guided us the project, and all the staff members of our department for helping us out
at all times.

NITISH REDDY PATIL (1AM20IS064)

SANTHOSH KUMAR REDDY G (1AM20IS085)
SHARAN KUMAR N (1AM20IS087)

THARUN REDDY M (1AM20IS104)

 ABSTRACT

This project is an Event management portal that is implemented on a website. This

project gives feature of remotely creating, removing, information retrieval, allotting tasks to
different participants, etc in an event.
This project is capable of providing all the important access to the admin and all the
people related to a particular event. It gives Event Manager access to see participants and
guest list. Also, he/she will be able to create or delete an event. This project will reduce
paperwork and manpower hence creating a hassle-free way of managing an event.

Every event requirement will be traceable. One would be able to collect feedback
from people and improve according to that feedback. Volunteer can be invited and duties can
be assigned to them also revenue collection can be monitored through this platform. The
purpose of creating this project is to digitalize the processes involved in an event, also it is
easy to access so one can access it anytime and anywhere and perform a manage an event.

It provides most of the basic functionality required by any event manager to smoothly
run the event. This is to satisfy the needs of event manager as well as participants of event.
They can enter their data and register for the event. This data is then sent to administrator
which in turn can contact the participants.

This project belons to the category DBMS (Data Base Management System). The
project is based on JAVA (GUI (Graphical User Interface)) and MYSQL.

(Keywords: Traceable, Event Management, Functionality, participant)

 TABLE OF CONTENTS

SL.NO. TITLE Page No.

1. CHAPTER 1
Introduction
1
1.1 PHP
Benefits of PHP 2
1.2
Features of PHP 4
1.3
HTML
CSS

2. CHAPTER 2
System Requirements
2.1 Hardware Configuration: Table 5
2.2 Software Configuration: Table

3. CHAPTER 3
3.1 System Design and Modelling
6
Entity-Relationship model on
College Event Management
System.
4. CHAPTER 4
4.1 Implementation 7
4.2 Appendix A 8
4.3 Appendix B 23
 5. CHAPTER 5
5.1 Conclusion 32

6.0 References 33

LIST OF DIAGRAMS

Figure no. TITLE Page no.

3.1.1 ER-DIAGRAM 06
4.3.1 HOME 23
4.3.2 TECHNICAL EVENTS 23
4.3.3 SPORTS EVENTS 24
4.3.4 ON-STAGE EVENTS 24
4.3.5 OFF-STAGE EVENTS 24
4.3.6 PARTICIPANT REGISTER 25
4.3.7 ADMIN 25
4.3.8 EVENT DETAILS 26
4.3.9 DELETE EVENTS 26
4.3.10 STUDENT DETAILS 27
4.3.11 STUDENT CO-ORDINATOR DETAILS 27
4.3.12 STAFF CO-ORDINATOR DETAILS 28
4.3.13 – DATABASE 28-31
4.3.17
COLLEGE EVENT MANAGEMENT SYSTEM

CHAPTER 1
INTRODUCTION:
College event management system create opportunities for people to connect with an
area, spend time together, celebrate and experience the diversity of cultures and foster
creativity and innovation. They allow a community to come alive and provide an opportunity
for a destination to showcase its tourism experience and increase economic activity. Events
contribute significantly to community building, lifestyle and leisure enhancement, cultural
development, tourism promotion and increased visitation, volunteer participation, fundraising
and economic development. Most importantly, events create a sense of fun and vibrancy,
resulting in a strong sense of community connectivity, pride and a sense of place.

Events Management Strategy Events are widely acknowledged as presenting

opportunities as a strong economic and tourism generator as well as bringing a range of
community and social benefits to their host destination. The major drivers of this strategy are
the cultural, social and environmental benefits of community events. A clear vision is needed
to provide direction to activity in the future, hence the development of an Events
Management Strategy for Irwin. In developing this Strategy our objectives are to:

 Gain a sound understanding of existing events and venues;

 Achieve clarity regarding the role and responsibilities of event management

company to support and host events

 Develop a sustainable, outcome focused events programme which maximises the

potential of our involvement in events;

 Incorporate the cultural, lifestyle and environmental factors unique to the

destination into the events programme;

 Pursue campaign which support events and which contribute to overall destination
marketing;

Events are a dynamic and fast-growing sector that has obvious synergies with
tourism. If managed and hosted effectively, they can expand the visitor economy, provide
media exposure, promote regional development, and stimulate the upgrading of infrastructure

DEPT. OF ISE, AMCEC 2022-2023 PAGE-1

COLLEGE EVENT MANAGEMENT SYSTEM

and the emergence of new partnerships for financing sport, tourism, culture, and leisure
facilities.

1.1 PHP

The term PHP is an acronym for PHP: Hypertext Pre-processor. PHP is a server-side
scripting language designed specifically for web development. It is open-source which means
it is free to download and use. It is very simple to learn and use. The files have the extension
“.php”.
Rasmus Lerdorf inspired the first version of PHP and participated in the later
versions. It is an interpreted language and it does not require a compiler.

PHP code is executed in the server. It can be integrated with many databases such as
Oracle, Microsoft SQL Server, MySQL, PostgreSQL, Sybase, and Informix. It is powerful to
hold a content management system like WordPress and can be used to control user access.

It supports main protocols like HTTP Basic, HTTP Digest, IMAP, FTP, and others.
Websites like www.facebook.com and www.yahoo.com are also built on PHP. One of the
main reasons behind this is that PHP can be easily embedded in HTML files and HTML
codes can also be written in a PHP file.

The thing that differentiates PHP from the client-side language like HTML is, that
PHP codes are executed on the server whereas HTML codes are directly rendered on
the browser. PHP codes are first executed on the server and then the result is returned
to the browser.

The only information that the client or browser knows is the result returned after
executing the PHP script on the server and not the actual PHP codes present in the
PHP file. Also, PHP files can support other client-side scripting languages like CSS
and JavaScript.

Other characteristics of PHP are as follows.

• Simple and fast.
• Efficient.
• Secured.
• Flexible

DEPT. OF ISE, AMCEC 2022-2023 PAGE-2

COLLEGE EVENT MANAGEMENT SYSTEM

1.2 BENEFITS OF PHP

The most important advantage of PHP is that it’s open-source and free from cost. It
can be downloaded anywhere and is readily available to use for events or web applications.
• It is platform-independent. PHP-based applications can run on any OS like UNIX, Linux,
Windows, etc.
• Applications can easily be loaded which are based on PHP and connected to the database.
It’s mainly used due to its faster rate of loading over slow internet speed than other
programming language.
• It 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 for a few years with the assistance of providing continuous support to
various versions.
• It helps in reusing an equivalent code and not got have to write lengthy code and
sophisticated structure for events of web applications.
• It helps in managing code easily.
• It has powerful library support to use various function modules for data representation.
• PHP’s built-in database connection modules help in connecting databases easily reducing
trouble and time for the development of web applications and content-based sites.
• The popularity of PHP gave rise to various communities 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.

1.3 FEATURES IN PHP

The main features of PHP are; it is open-source scripting language so you can free
download this and use. PHP is a server site scripting language.
• It is open-source scripting language. It is widely used all over the world. It is faster than
other scripting language. Some important features of PHP are given below; 34 It is most
popular and frequently used worldwide scripting language, the main reason of popularity
is; It is open source and very simple.

DEPT. OF ISE, AMCEC 2022-2023 PAGE-3

COLLEGE EVENT MANAGEMENT SYSTEM

• Simple: It is very simple and easy to use, compare to other scripting language it is very
simple and easy, this is widely used all over the world.
• Interpreted: It is an interpreted language, i.e., there is no need for compilation.
• Faster: It is faster than other scripting language e.g., asp and jsp.
• Open Source: Open source means you no need to pay for use php, you can free download
and use.
• Platform Independent: PHP code will be run on every platform, Linux, Unix, Mac OS X,
Windows.

HTML:

HTML is a hypertext markup language which is, in reality, a spinal cord of any
website. Any website can’t be structured without the knowledge of HTML. If we make
our webpage only with the help of HTML, then we can’t add many of the effective
features in a webpage, for making a web page more effective we use various platforms
such as static and dynamics methods.
Here we are using this language to make our web pages more effective as well as
interactive for users to understand. And to make our web pages dynamic we are using
JavaScript and XML.

CSS:
CSS in PHP Stands for (Cascading Style Sheet). Cascading style sheets are used to
format the layout of Web pages. They can be used to define way of writing or style, size of
various table, and other aspects of Web pages that previously could only be defined in a
static page's HTML.
The main work of CSS is to separate content of a web document (written in any
markup language) that is written using Cascading Style Sheets. There are lots of benefits
that one can extract through this like improved content accessibility, better flexibility and
moreover, and hence gives a level of control over various presentation characteristics of
the document. It also helps in reducing the problems and helps in saving access time. It
gives the option of selecting various style schemes and rules according to the necessity.

DEPT. OF ISE, AMCEC 2022-2023 PAGE-4

COLLEGE EVENT MANAGEMENT SYSTEM

CHAPTER 2
SYSTEM REQUIREMENTS

2.1 HARDWARE CONFIGURATION:

System Pentium Dual Core.

Hard Disk 120 GB

Ram 2GB

Table 2.1 Hardware Configuration

2.2 SOFTWARE CONFIGURATION:

Operating System Windows XP/7/10 /11

Language HTML, CSS, PHP

IDE NetBeans IDE 8.2

Table 2.2 Software Configuration

CHAPTER 3

DEPT. OF ISE, AMCEC 2022-2023 PAGE-5

COLLEGE EVENT MANAGEMENT SYSTEM

SYSTEM DESIGN AND MODELLING

ENTITY – RELATIONSHIP MODEL

An entity – relationship model describes interrelated things of interest in a specific domain

of knowledge.

3.1 ENTITY - RELATIONSHIP MODEL ON COLLEGE EVENT MANAGEMENT

SYSTEM.

FIG 3.1.1 ER-DIAGRAM

CHAPTER 4

DEPT. OF ISE, AMCEC 2022-2023 PAGE-6

COLLEGE EVENT MANAGEMENT SYSTEM

4.1 IMPLEMENTATION

College event management System is the application to manage and development of

festivals, events and conferences. Proposed work involves study of identifying the target of
budget, cost, and analysis. Post event analysis and ensuring a return on investment have
become significant drivers for the event industry.

This is an online College event management system, software project that serves the
functionality of an event manager. The project provides most of the basic functionality
required for an event. This web-based application system can be implemented in any place
for booking events.

The system can also be used as software to promote the entire booking places. The
user gets all the resources at a single place instead of wondering round for these. This system
is effective and saves time and cost of the user.

Functionally Performed by Admin, Participant and Faculty:

1) Admin
• Home
• Upload Event
• Verify Events
• Verify Registered student
• Delete Events
• About us
• Logout

2) Participant
• Home
• View Event
• Event Registration
• View Status
• About us
• Logout
3) Faculty
• Home

DEPT. OF ISE, AMCEC 2022-2023 PAGE-7

COLLEGE EVENT MANAGEMENT SYSTEM

• View Event
• View Register Student
• About us
• Logout

4.2 APPENDIX A
Source-Code: -
Registration:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>cems</title>
<?php require 'utils/styles.php'; ?><!--css links. file found in utils folder-->

</head>
<body>
<?php require 'utils/header.php'; ?>
<div class ="content"><!--body content holder-->
<div class = "container">
<div class ="col-md-6 col-md-offset-3">
<form method="POST">

<label>Student USN:</label><br>
<input type="text" name="usn" class="form-control" required><br><br>

<label>Student Name:</label><br>
<input type="text" name="name" class="form-control" required><br><br>

<label>Branch:</label><br>
<input type="text" name="branch" class="form-control" required><br><br>

<label>Semester:</label><br>
<input type="text" name="sem" class="form-control" required><br><br>

<label>Email:</label><br>
<input type="text" name="email" class="form-control" required ><br><br>

<label>Phone:</label><br>
<input type="text" name="phone" class="form-control" required><br><br>

<label>College:</label><br>
<input type="text" name="college" class="form-control" required><br><br>

DEPT. OF ISE, AMCEC 2022-2023 PAGE-8

COLLEGE EVENT MANAGEMENT SYSTEM

<button type="submit" name="update" required>Submit</button><br><br>

<a href="usn.php" ><u>Already registered ?</u></a>

</div>
</div>
</div>
</form>

<?php require 'utils/footer.php'; ?>

</body>
</html>

<?php

if (isset($_POST["update"]))
{
$usn=$_POST["usn"];
$name=$_POST["name"];
$branch=$_POST["branch"];
$sem=$_POST["sem"];
$email=$_POST["email"];
$phone=$_POST["phone"];
$college=$_POST["college"];

if( !empty($usn) || !empty($name) || !empty($branch) || !empty($sem) || !empty($email) ||

!empty($phone) || !empty($college) )
{

include 'classes/db1.php';
$INSERT="INSERT INTO participent (usn,name,branch,sem,email,phone,college)
VALUES('$usn','$name','$branch',$sem,'$email','$phone','$college')";

if($conn->query($INSERT)===True){
echo "<script>
alert('Registered Successfully!');
window.location.href='usn.php';
</script>";
}
else
{
echo"<script>
alert(' Already registered this usn');
window.location.href='usn.php';
</script>";

DEPT. OF ISE, AMCEC 2022-2023 PAGE-9

COLLEGE EVENT MANAGEMENT SYSTEM

$conn->close();

}
else
{
echo"<script>
alert('All fields are required');
window.location.href='register.php';
</script>";
}
}

?>

Login Page:

<?php
include_once 'classes/db1.php';?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>cems</title>
<title></title>
<style>
span.error{
color: red;
}
</style>
<?php require 'utils/styles.php'; ?><!--css links. file found in utils folder-->
</head>
<body>
<?php require 'utils/header.php'; ?><!--header content. file found in utils folder-->
<div class = "content"><!--body content holder-->
<div class = "container">
<div class ="col-md-6 col-md-offset-3">

<form method="POST"><!--form-->

<!--username field-->
<label>UserName:</label><br>
<input type="text" name="name" class="form-control" required><br>

<label>Password</label><br>
<input type="password" name="password" class="form-control" required><br>
<button type = "submit" name="update" class = "btn
btn-default">Login</button>

DEPT. OF ISE, AMCEC 2022-2023 PAGE-10

COLLEGE EVENT MANAGEMENT SYSTEM

</form>
</div><!--col md 6 div-->
</div><!--container div-->
</div><!--content div-->
<?php require 'utils/footer.php'; ?><!--footer content. file found in utils folder-->
</body>
</html>
<?php
if (isset($_POST["update"]))
{
$myusername=$_POST['name'];
$mypassword=$_POST['password'];

if($mypassword=='admin' && $myusername=='admin')

{
echo "<script>
alert('Login Successfull');
window.location.href='adminPage.php';
</script>";
}
else
{
echo "<script>
alert('Invalid credentials');
window.location.href='login_form.php';
</script>";
}
}
?>

Admin page:

<?php
include_once 'classes/db1.php';
$result = mysqli_query($conn,"SELECT * FROM staff_coordinator s ,event_info
ef ,student_coordinator st,events e where e.event_id= ef.event_id and e.event_id= s.event_id
and e.event_id= st.event_id");
?>

<!DOCTYPE html>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>cems</title>
</head>

<body>

DEPT. OF ISE, AMCEC 2022-2023 PAGE-11

COLLEGE EVENT MANAGEMENT SYSTEM

<?php include 'utils/adminHeader.php'?>

<div class = "content">

<div class = "container">
<h1>Event details</h1>
<?php
if (mysqli_num_rows($result) > 0) {
?>
<table class="table table-hover" >
<thead>
<tr>

<th>Event_name</th>
<th>No. of Participents</th>
<th>Price</th>
<th>Student Co-ordinator</th>
<th>Staff Co-ordinator</th>

<th>Date</th>

<th>Time</th>
<th>location </th>

</tr>
</thead>
<tbody>
<?php
$i=0;
while($row = mysqli_fetch_array($result)){
echo '<tr>';

echo '<td>' . $row['event_title'] . '</td>';

echo '<td>' . $row['participents'] . '</td>';
echo '<td>' . $row['event_price'] . '</td>';
echo '<td>' . $row['st_name'] . '</td>';
echo '<td>' . $row['name'] . '</td>';
echo '<td>'.$row['Date'].'</td>';
echo '<td>'.$row['time'].'</td>';
echo '<td>'.$row['location'].'</td>';

echo '<td>'

.'<a class="delete" href="deleteEvent.php?id='.

$row['event_id'].'">Delete</a> '
.'</td>';
echo '</tr>';

DEPT. OF ISE, AMCEC 2022-2023 PAGE-12

COLLEGE EVENT MANAGEMENT SYSTEM

$i++;
}

?>
</tbody>
</table>
<?php
}

?>
<a class="btn btn-default" href = "createEventForm.php">Create Event</a><!--
register button-->
</div>
</div>

<?php require 'utils/footer.php'; ?>

</body>
</html>

Create Event:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>cems</title>
<title></title>
<?php require 'utils/styles.php'; ?><!--css links. file found in utils folder-->

</head>
<body>
<?php require 'utils/adminHeader.php'; ?>
<form method="POST">

<div class="w3-container">

<div class ="content"><!--body content holder-->

<div class = "container">
<div class ="col-md-6 col-md-offset-3">
<label>Event ID:</label><br>
<input type="number" name="event_id" required class="form-control"><br><br>

<label>Event Name:</label><br>
<input type="text" name="event_title" required class="form-control"><br><br>

<label>Event Price:</label><br>
<input type="number" name="event_price" required class="form-control"><br><br>

DEPT. OF ISE, AMCEC 2022-2023 PAGE-13

COLLEGE EVENT MANAGEMENT SYSTEM

<label>Upload Path to Image:</label><br>

<input type="text" name="img_link" required class="form-control"><br><br>

<label>Type_ID </label><br>
<input type="number" name="type_id" required class="form-control"><br><br>

<label>Event Date</label><br>
<input type="date" name="Date" required class="form-control"><br><br>

<label>Event Time</label><br>
<input type="text" name="time" required class="form-control"><br><br>

<label>Event Location</label><br>
<input type="text" name="location" required class="form-control"><br><br>
<label>Staff co-ordinator name</label><br>
<input type="text" name="sname" required class="form-control"><br><br>
<label>Student co-ordinator name</label><br>
<input type="text" name="st_name" required class="form-control"><br><br>

<button type="submit" name="update" class = "btn btn-default pull-right">Create Event

<span class="glyphicon glyphicon-send"></span></button>

<a class="btn btn-default navbar-btn" href = "adminPage.php"><span class="glyphicon

glyphicon-circle-arrow-left"></span> Back</a>

</div></div></div>
</form>

</body>

<?php require 'utils/footer.php'; ?>

</html>

<?php

if (isset($_POST["update"]))
{
$event_id=$_POST["event_id"];
$event_title=$_POST["event_title"];
$event_price=$_POST["event_price"];

$img_link=$_POST["img_link"];
$type_id=$_POST["type_id"];
$name=$_POST["sname"];
$st_name=$_POST["st_name"];

DEPT. OF ISE, AMCEC 2022-2023 PAGE-14

COLLEGE EVENT MANAGEMENT SYSTEM

$Date=$_POST["Date"];
$time=$_POST["time"];
$location=$_POST["location"];
if(!empty($event_id) || !empty($event_title) || !empty($event_price) || !
empty($participents) || !empty($img_link) || !empty($type_id) )

{
include 'classes/db1.php';

$INSERT="INSERT INTO events(event_id,event_title,event_price,img_link,type_id)

VALUES($event_id,'$event_title', $event_price,'$img_link',$type_id);";

$INSERT.= "INSERT INTO event_info (event_id,Date,time,location) Values

($event_id,'$Date','$time','$location');";
$INSERT.="INSERT into student_coordinator(sid,st_name,phone,event_id)
values($event_id,'$st_name',NULL,$event_id);";
$INSERT.="INSERT into staff_coordinator(stid,name,phone,event_id)
values($event_id,'$name',NULL,$event_id)";

if($conn->multi_query($INSERT)===True){
echo "<script>
alert('Event Inserted Successfully!');
window.location.href='adminPage.php';
</script>";
}
else
{
echo"<script>
alert('Event already exsists!');
window.location.href='createEventForm.php';
</script>";
}

$conn->close();

}
else
{
echo"<script>
alert('All fields are required');
window.location.href='createEventForm1.php';
</script>";
}
}
?>

DEPT. OF ISE, AMCEC 2022-2023 PAGE-15

COLLEGE EVENT MANAGEMENT SYSTEM

Delete Event:

<?php require 'classes/db1.php';

$id=$_GET['id'];

$sql="delete from events where event_id='$id';";

$sql.="delete from event_info where event_id='$id';";
$sql.="delete from staff_coordinator where event_id='$id';";
$sql.="delete from student_coordinator where event_id='$id';";
$sql.="delete from registered where event_id='$id'";
if($conn->multi_query($sql) === True)
{
echo"<script>
alert('Event Deleted Successfully');
window.location.href='adminPage.php';
</script>";
}
else{
echo "Error deleting record".$conn->error;
}
$conn->close();
?>

Events page:

<div class="container">
<div class="col-md-12">
<hr>
</div>

<div class="row">
<section>
<div class="container">
<div class="col-md-6">

<img src=" <?php echo $row['img_link'];?>" class="img-responsive">

</div>
<div class="subcontent col-md-6">
<h1 style="color:#003300 ; font-size:38px ;" ><u><strong><?php echo
'<td>' . $row['event_title'] . '</td>';?></strong></u></h1><!--title-->
<p style="color:#003300 ;font-size:20px "><!--content-->
<?php

echo 'Date:' . $row['Date'] .'<br>';

echo 'Time:' . $row['time'] .'<br>';
echo 'Location:' . $row['location'] .'<br>';

DEPT. OF ISE, AMCEC 2022-2023 PAGE-16

COLLEGE EVENT MANAGEMENT SYSTEM

echo 'Student Co-ordinator:' . $row['st_name'] .'<br>';

echo 'Staff Co-ordinator:' . $row['name'] .'<br>';
echo 'Event Price:' . $row['event_price'].'<br>' ;

?>
</p>

<br><br>
<?php echo
'<a class="btn btn-default" href="register.php"> <span class="glyphicon
glyphicon-circle-arrow-right"></span>Register</a>'
?>
</div><!--subcontent div-->
</div><!--container div-->
</section>
</div>
</div><!--row div-->

Staff Co-ordinator:

<?php
include_once 'classes/db1.php';
$result = mysqli_query($conn,"SELECT * FROM staff_coordinator s ,events e where
e.event_id= s.event_id");
?>
<!DOCTYPE html>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>cems</title>
<title></title>
<?php require 'utils/styles.php'; ?><!--css links. file found in utils folder-->

</head>

<body><?php include 'utils/adminHeader.php'?>

<div class = "content">
<div class = "container">
<h1>Staff Co-ordinator details</h1>
<?php
if (mysqli_num_rows($result) > 0) {
?>
<table class="table table-hover" >

<tr>
<th>Name</th>
<th>Phone</th>

DEPT. OF ISE, AMCEC 2022-2023 PAGE-17

COLLEGE EVENT MANAGEMENT SYSTEM

<th>Event</th>
<th></th>
</tr>
<?php
$i=0;
while($row = mysqli_fetch_array($result)) {
?>
<tr>
<td><?php echo $row["name"]; ?></td>
<td><?php echo $row["phone"]; ?></td>
<td><?php echo $row["event_title"]; ?></td>
<td> <?php echo '<a href="updateStaff.php?id='.$row['event_id'].'" class = "btn btn-
default"> Update</a>'?></td>

</tr>
<?php
$i++;
}
?>
</table>
<?php
}
else{
echo "No result found";
}
?>
</div>
</div>
</body>
<?php include 'utils/footer.php';?>
</html>

Student Co-ordinator:

<?php
include_once 'classes/db1.php';
$result = mysqli_query($conn,"SELECT * FROM student_coordinator s ,events e where
e.event_id= s.event_id");
?>
<!DOCTYPE html>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>cems</title>
<title></title>
<?php require 'utils/styles.php'; ?><!--css links. file found in utils folder-->

DEPT. OF ISE, AMCEC 2022-2023 PAGE-18

COLLEGE EVENT MANAGEMENT SYSTEM

</head>

<body><?php include 'utils/adminHeader.php'?>

<div class = "content">
<div class = "container">
<h1>Student Co-ordinator details</h1>
<?php
if (mysqli_num_rows($result) > 0) {
?>
<table class="table table-hover" >

<tr>
<th>Name</th>
<th>Phone</th>
<th>Event</th>
<th></th>
</tr>
<?php
$i=0;
while($row = mysqli_fetch_array($result)) {
?>
<tr>
<td><?php echo $row["st_name"]; ?></td>
<td><?php echo $row["phone"]; ?></td>
<td><?php echo $row["event_title"]; ?></td>
<td> <?php echo '<a href="updateStudent.php?id='.$row['event_id'].'" class = "btn btn-
default"> Update</a>'?></td>

</tr>
<?php
$i++;
}
?>
</table>
<?php
}
else{
echo "No result found";
}
?>
</div>
</div>
</body>
<?php include 'utils/footer.php';?>
</html>

Student Details:

DEPT. OF ISE, AMCEC 2022-2023 PAGE-19

COLLEGE EVENT MANAGEMENT SYSTEM

<?php
include_once 'classes/db1.php';
$result = mysqli_query($conn,"SELECT * FROM events,registered r ,participent p WHERE
events.event_id=r.event_id and r.usn = p.usn order by event_title");
?>
<!DOCTYPE html>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>cems</title>
<title></title>
<?php require 'utils/styles.php'; ?><!--css links. file found in utils folder-->

</head>

<body><?php include 'utils/adminHeader.php'?>

<div class = "content">
<div class = "container">
<h1>Student details</h1>
<?php
if (mysqli_num_rows($result) > 0) {
?>
<table class="table table-hover" >

<tr>
<th>USN</th>
<th>Name</th>
<th>Branch</th>
<th>Sem</th>
<th>Email</th>
<th>Phone</th>
<th>College</th>
<th>Event</th>
</tr>
<?php
$i=0;
while($row = mysqli_fetch_array($result)) {
?>
<tr>
<td><?php echo $row["usn"]; ?></td>
<td><?php echo $row["name"]; ?></td>
<td><?php echo $row["branch"]; ?></td>
<td><?php echo $row["sem"]; ?></td>
<td><?php echo $row["email"]; ?></td>
<td><?php echo $row["phone"]; ?></td>
<td><?php echo $row["college"]; ?></td>
<td><?php echo $row["event_title"]; ?></td>

DEPT. OF ISE, AMCEC 2022-2023 PAGE-20

COLLEGE EVENT MANAGEMENT SYSTEM

</tr>
<?php
$i++;
}
?>
</table>
<?php
}
else{
echo "No result found";
}
?>
</div>
</div>
<?php include 'utils/footer.php'?>;
</body>

View Event:

<?php
require 'classes/db1.php';
$id=$_GET['id'];
$result = mysqli_query($conn,"SELECT * FROM events,event_info ef,student_coordinator
s,staff_coordinator st WHERE type_id = $id and ef.event_id=events.event_id and
s.event_id=events.event_id and st.event_id=events.event_id ");
?>

<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>cems</title>
<title></title>
<?php require 'utils/styles.php'; ?><!--css links. file found in utils folder-->

</head>

<body>

<?php require 'utils/header.php'; ?><!--header content. file found in utils folder-->

<div class = "content"><!--body content holder-->

<div class = "container">
<div class = "col-md-12"><!--body content title holder with 12 grid columns-->

</div>

DEPT. OF ISE, AMCEC 2022-2023 PAGE-21

COLLEGE EVENT MANAGEMENT SYSTEM

<?php
if (mysqli_num_rows($result) > 0) {

$i=0;
while($row = mysqli_fetch_array($result)) {

include 'events.php';

$i++;
}
?>
<div class="container">
<div class="col-md-12">
<hr>
</div>
</div>
<?php }?>
<a class="btn btn-default" href="index.php"><span class="glyphicon glyphicon-
circle-arrow-left"></span> Back</a>
</div><!--body content div-->
<?php require 'utils/footer.php'; ?><!--footer content. file found in utils folder-->
</body>

</html>

4.3 APPENDIX B

DEPT. OF ISE, AMCEC 2022-2023 PAGE-22

COLLEGE EVENT MANAGEMENT SYSTEM

SNAPSHOTS

HOME:

FIG 4.3.1 HOME

REGISTER FOR EVENTS:

FIG 4.3.2 TECHNICAL EVENTS

DEPT. OF ISE, AMCEC 2022-2023 PAGE-23

COLLEGE EVENT MANAGEMENT SYSTEM

FIG 4.3.3 SPORTS EVENTS

FIG 4.3.4 ON-STAGE EVENTS

FIG 4.3.5 OFF-STAGE EVENTS

DEPT. OF ISE, AMCEC 2022-2023 PAGE-24

COLLEGE EVENT MANAGEMENT SYSTEM

PARTICIPANT REGISTER:

FIG 4.3.6 PARTICIPANT REGISTER

ADMIN:

FIG 4.3.7 ADMIN

DEPT. OF ISE, AMCEC 2022-2023 PAGE-25

COLLEGE EVENT MANAGEMENT SYSTEM

EVENT DETAILS:

FIG 4.3.8 EVENT DETAILS

DELETE EVENTS:

FIG 4.3.9 DELETE EVENTS

DEPT. OF ISE, AMCEC 2022-2023 PAGE-26

COLLEGE EVENT MANAGEMENT SYSTEM

STUDENT DETAILS

FIG 4.3.10 STUDENT DETAILS

STUDENT CO-ORDINATOR DETAILS:

FIG 4.3.11 STUDENT CO-ORDINATOR DETAILS

DEPT. OF ISE, AMCEC 2022-2023 PAGE-27

COLLEGE EVENT MANAGEMENT SYSTEM

STAFF CO-ORDINATOR DETAILS:

FIG 4.3.12 STAFF CO-ORDINATOR DETAILS

DATABASE EVENT DETAILS:

FIG 4.3.13 DATABASE EVENT DETAILS

DEPT. OF ISE, AMCEC 2022-2023 PAGE-28

COLLEGE EVENT MANAGEMENT SYSTEM

DATABASE PARTICIPANTS DETAILS:

FIG 4.3.14 DATABASE PARTCIPANTS DETAILS

DATABASE REGISTERED DETAILS:

FIG 4.3.15 DATABASE REGISTERED DETAIL

DEPT. OF ISE, AMCEC 2022-2023 PAGE-29

COLLEGE EVENT MANAGEMENT SYSTEM

DATABASE STAFF CO-ORDINATOR DETAILS:

FIG 4.3.16 DATABASE STAFF CO-ORDINATOR DETAILS

DEPT. OF ISE, AMCEC 2022-2023 PAGE-30

COLLEGE EVENT MANAGEMENT SYSTEM

DATABASE STUDENT CO-ORDINATOR DETAILS:

FIG 4.3.17 DATABASE STUDENT CO-ORDINATOR DETAILS

DEPT. OF ISE, AMCEC 2022-2023 PAGE-31

COLLEGE EVENT MANAGEMENT SYSTEM

CHAPTER 5

5.1 CONCLUSION:

In this way the College Event Management System is useful for establishment to keep up the
event records of students. This lessens the burden of client and it is additionally an efficient
procedure.

The data can be effortlessly retrieved. The framework keeps up all records easily. The
proposed framework is automated and has been created utilizing advance language in this
way it gives a greater number of facilities than present framework. It gives fast access to any
information. Event Management System is user friendly and cost-effective system, it is customized
with activities related to event management life-cycle.

It provides a new edge to management industry. Solution Dot always keep your objectives
and goals on top priority while developing any plan of work.

DEPT. OF ISE, AMCEC 2022-2023 PAGE-32

COLLEGE EVENT MANAGEMENT SYSTEM

6.0 REFERENCES:

1] www.wikipedia.com

2] www.youtube.com

3] www.sourcecode.com

4] www.edureka.com

5] www.stackoverflow.com

6] www.pintrest.com

7] www.tutorialspoint.com

8] www.w3resource.com

9] www.geeksforgeeks.com

DEPT. OF ISE, AMCEC 2022-2023 PAGE-33