DBMS

PROJECT REPORT

TOPIC:-SOCCER MANAGEMENT

SUBMITTED BY:-
Vineeth Venu -60
Sibin Sabu -59
Ajo Gregory -53
 INDEX

1. Abstract
2. Tools used
3. Languages
 PHP
 HTML
 CSS
 BOOTSTRAP
 MYSQL
4. Program
 Home.php
 Connect.php
5. Screenshots
 ABSTRACT

INTRODUCTION:
This web application comes with a simple interface where a person can simply login or
register using some basic requirement. That login welcome’s him to the main interface which
held with some data fields. The main fields are Players, Store, Management, Sponsors, Events.
The user can simply visit this fields and give support to his favourite team and if a person who is
dreams to join with this team at any of the field can apply his request through this web
application. The live updates about the team should be released through the event field in the
web application.

OBJECTIVE:
The main aim of our project is to put a football team under the hand of common people.
Which means a common man who has an active internet connection and a laptop or a
smartphone can know the team updates, on time. If a person is highly passionate to join with this
team in any of the job positions can simply apply through this web application. The team’s
official store is also available at this application so that purchasing of tickets, jersey’s, badges
etc. are very easy. whereabout of the sponsors is also displays on the website this makes helpful
to the sponsors.

MATERIALS:

‘SOCCER MANAGEMENT’ web-application is built in Html, CSS, Bootstrap as frontend

and backend is integrated in PHP. MySQL is used as database to arrange all the data.
 TOOLS USED

OPERATING SYSTEM:-WINDOWS 10
FRONT END:-HTML, CSS, BOOTSTRAP
BACK END:-PHP
DATABASE:- MYSQL

LANGUAGES

PHP
PHP is a general-purpose scripting language geared towards web development.[7] It was
originally created by Danish-Canadian programmer Rasmus Lerdorf in 1994.[8] The PHP
reference implementation is now produced by The PHP Group.[9] PHP originally stood for
Personal Home Page,[8] but it now stands for the recursive initialism PHP: Hypertext
Preprocessor.[10] 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.[13] The PHP
language evolved without a written formal specification or standard until 2014, with the original
implementation acting as the de facto standard which other implementations aimed to follow.
Since 2014, work has gone on to create a formal PHP specification.[14] W3Techs reports that, as
of January 2022, "PHP is used by 78.1% of all the websites whose server-side programming
language we know."[15] PHP version 7.4 is the most used version. Support for version 7.3 was
dropped on 6 December 2021.

HTML
The HyperText Markup Language or HTML is the standard markup language for documents
designed to be displayed in a web browser. It can be assisted by technologies such as Cascading
Style Sheets (CSS) and scripting languages such as JavaScript.
Web browsers receive HTML documents from a web server or from local storage and render the
documents into multimedia web pages. HTML describes the structure of a web
page semantically and originally included cues for the appearance of the document.
HTML elements are the building blocks of HTML pages. With HTML constructs, images and
other objects such as interactive forms may be embedded into the rendered page. HTML
provides a means to create structured documents by denoting structural semantics for text such as
headings, paragraphs, lists, links, quotes and other items. HTML elements are delineated by tags,
written using angle brackets. Tags such as  <img />  and  <input />  directly introduce content
into the page. Other tags such as  <p>  surround and provide information about document text
and may include other tags as sub-elements. Browsers do not display the HTML tags but use
them to interpret the content of the page.
HTML can embed programs written in a scripting language such as JavaScript, which affects the
behavior and content of web pages. Inclusion of CSS defines the look and layout of content.
The World Wide Web Consortium (W3C), former maintainer of the HTML and current
maintainer of the CSS standards, has encouraged the use of CSS over explicit presentational
HTML since 1997.[2] A form of HTML, known as HTML5, is used to display video and audio,
primarily using the  <canvas>  element, in collaboration with java script.

CSS
Cascading Style Sheets (CSS) is a style sheet language used for describing the presentation of a
document written in a markup language such as HTML.[1] CSS is a cornerstone technology of
the World Wide Web, alongside HTML and JavaScript.[2]
CSS is designed to enable the separation of presentation and content, including layout, colors,
and fonts.[3] This separation can improve content accessibility; provide more flexibility and
control in the specification of presentation characteristics; enable multiple web pages to share
formatting by specifying the relevant CSS in a separate .css file, which reduces complexity and
repetition in the structural content; and enable the .css file to be cached to improve the page load
speed between the pages that share the file and its formatting.
Separation of formatting and content also makes it feasible to present the same markup page in
different styles for different rendering methods, such as on-screen, in print, by voice (via speech-
based browser or screen reader), and on Braille-based tactile devices. CSS also has rules for
alternate formatting if the content is accessed on a mobile device.[4]
The name cascading comes from the specified priority scheme to determine which style rule
applies if more than one rule matches a particular element. This cascading priority scheme is
predictable.
BOOTSTRAP
Bootstrap is a free and open-source CSS framework directed at responsive, mobile-first front-
end web development. It contains HTML, CSS and (optionally) JavaScript-based design
templates for typography, forms, buttons, navigation, and other interface components.

MYSQL
 MySQL  is an open-source relational database management system (RDBMS) Its name
is a combination of "My", the name of co-founder Michael Widenius's daughter,[7] and
"SQL", the abbreviation for Structured Query Language. A relational database organizes
data into one or more data tables in which data types may be related to each other; these
relations help structure the data. SQL is a language programmers use to create, modify
and extract data from the relational database, as well as control user access to the
database. In addition to relational databases and SQL, an RDBMS like MySQL works
with an operating system to implement a relational database in a computer's storage
system, manages users, allows for network access and facilitates testing database
integrity and creation of backups.
 MySQL is free and open-source software under the terms of the GNU General Public
License, and is also available under a variety of proprietary licenses. MySQL was owned
and sponsored by the Swedish company MySQL AB, which was bought by Sun
Microsystems (now Oracle Corporation). In 2010, when Oracle acquired Sun,
Widenius forked the open-source MySQL project to create MariaDB
 MySQL has stand-alone clients that allow users to interact directly with a MySQL
database using SQL, but more often, MySQL is used with other programs to implement
applications that need relational database capability. MySQL is a component of
the LAMP web application software stack (and others), which is an acronym
for Linux, Apache, MySQL, Perl/PHP/Python. MySQL is used by many database-driven
web applications, including Drupal, Joomla, phpBB, and WordPress. MySQL is also used
by many popular websites, including Facebook,
Flickr, MediaWiki, Twitter, and YouTube
 PROGRAM
HOME.PHP

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="style.css">
<!-- JavaScript Bundle with Popper -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"
integrity="sha384-
ka7Sk0Gln4gmtz2MlQnikT1wXgYsOg+OMhuP+IlRH9sENBO0LRn5q+8nbTov4+1p"
crossorigin="anonymous"></script>
<!-- CSS only -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css"
rel="stylesheet" integrity="sha384-
1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3"
crossorigin="anonymous">
<title>SOCCER MANAGEMENT</title>
</head>
<body>
<section id="header-sections">
<header>
<nav class="navbar">
 <div class="container-fluid">
<div>
<a href="#" style="text-decoration: none;
font-weight: 700; font-size: 25px;">
SOCCER MANAGEMENT
</a>
</div>
<div class="nav navbar-nav1">
<a href="home.php" class="btn text-light">Home</a>
<a href="registration.php" class="btn text-light">Registration</a>
<a href="purchase.php" class="btn text-light">Purchase</a>
<a href="tickets.php" class="btn text-light">Tickets</a>
<a href="appointment.php" class="btn text-light">Appointment</a>
<a href="event.php" class="btn text-light">Events</a>
<a href="admin.php"> <button type="button" class="btn btn-primary text-
light"><b>ADMIN</b></button></a>
</div>
</div>
</nav>
</header>
</section>
<section id="slpor">
<img src="sldr1.jpeg" alt="" srcset="" style="width: 100%;">
</section>
<section>
<section class="about my-5">
<div class="container">
<h3 style="color:
#323049;text-align: center;"><u><b>VISION</b></u></h3>
 <p style="line-height: 2.0;color:
#323049;font-size: 20px;"> Vision is not only about how well you can see, it also involves 17
different visual skills that enable accurate, smooth, and precise eye movements for clear and
comfortable vision— all necessary for many daily activities. These visual skills allow you to
visualize, use your peripheral vision, switch visual focus between target points at varying
distances, sustain focus on a moving target, and more!

The 17 visual skills are essential for success in reading, writing, and sports performance.
Reduced performance in any of these areas may indicate a problem with the visual skills.Vision
is not only about how well you can see, it also involves 17 different visual skills that enable
accurate, smooth, and precise eye movements for clear and comfortable vision— all necessary
for many daily activities. These visual skills allow you to visualize, use your peripheral vision,
switch visual focus between target points at varying distances, sustain focus on a moving target,
and more!

The 17 visual skills are essential for success in reading, writing, and sports performance.
Reduced performance in any of these areas may indicate a problem with the visual skills.</p>
</div>

</section>
<section>

<div class="container my-5">

<h3 style="color:
#323049;text-align: center;"><u><b>CLUB GALLERY</b></u></h3>
<!-- Gallery -->
<div class="row my-5">
<div class="col-lg-4 col-md-12 mb-4 mb-lg-0">
<img
src="match1.jpg"
class="w-100 shadow-1-strong rounded mb-4"
 alt="Boat on Calm Water"
/>

<img
src="rr.jpg"
class="w-100 shadow-1-strong rounded mb-4"
alt="Wintry Mountain Landscape"
/>
</div>

<div class="col-lg-4 mb-4 mb-lg-0">

<img
src="childs.jpg"
class="w-100 shadow-1-strong rounded mb-4"
alt="Mountains in the Clouds"
/>

<img
src="award.jpg"
class="w-100 shadow-1-strong rounded mb-4"
alt="Boat on Calm Water"
/>
</div>

<div class="col-lg-4 mb-4 mb-lg-0">

<img
src="boat.jpg"
class="w-100 shadow-1-strong rounded mb-4"
 alt="Waves at Sea"
/>

<img
src="dj.jpg"
class="w-100 shadow-1-strong rounded mb-4"
alt="Yosemite National Park"
/>
</div>
</div>
<!-- Gallery --></div>
</div>

</section>
<!-- Footer -->
<footer class="page-footer font-small blue">

<!-- Copyright -->

<div class="footer-copyright text-center py-3 text-light">© 2022 Copyright:
<a href="https://mdbootstrap.com/" class="text-light" style="text-decoration: none;">Soccer
Management System</a>
</div>
<!-- Copyright -->

</footer>
<!-- Footer -->
</section>
</body>
</html>
COONECT.PHP
<?php
$host = "localhost";
$users = "root";
$pass = "";
$database ="club";
$connection = mysqli_connect($host,$users,$pass,$database);
?>
Screenshoot
 CONCLUSION

The project training undertaken by me at "College of Engineering and management

Punnapra" helped me in not only gaining practical experience but also to adapt the technical skill
and procedures.
It is said that no system is perfect; every system has some limitations and flaws. Taking
this into consideration, the project "Soccer Management" for "Database Management System"
has been carried out successfully.
Thus I confidently conclude that this was not only beneficial in its technical and
educational aspect but also wins equality in building up my personality.