Download Fifa player Management System and more Study Guides, Projects, Research Computer Science in PDF only on Docsity!
Chapter 1
Introduction
The project titled “ FIFA Player Management System ” is player management software for monitoring and accessing players based on their FIFA PC/XBOX Game ratings. This project is developed using HTML, CSS and JavaScript for front-end and PHP, MySQL for back-end, which focuses on basic operation like adding a new player, new statistics, searching players with detailed information and edit as they grow their skills.
This project is a web based application designed and developed to help user’s access players and organize teams. This software is easy to use, and it features a familiar and well- thought- out attractive user interface, combined with strong searching, insertion, and deletion with procedure capabilities.
Analyzing players have been a huge task performed by professional scouting agents whoare spread around the world. From personal details to football technicalities, FIFA Player Management System allows easy maintenance record for such skilled youth talent.
To analyze and access players on a daily basics can be hectic and huge effort demanding task. To help users, managers, staffs and scouting agents in football world, FIFA 18 player management system provides effortless player management system to help users to analyse, improve, train and access plays on a daily basis.
This project consists of player details, which describes about player biodata such as age and nationality. It also consists of player stats which describes about players technical skills. It also consists of tables containing details such as player earnings, club information and preferred position of playing. It also provide a strong searching, updating, deleting and inserting operations with a user friendly web based UI.
This project is a simple prototype of managing larger numbers of players across different nations with different skill sets and attributes. It helps to access players and thus aids in building a strong positional team. It also helps in monitoring player growth.
Chapter 2
Requirement Analysis
2.1Basic HTML Tags:
Table No. 2.1: Basic HTML Tags Defines a title for the document <body> Defines the document's body <h1> to <h6> Defines HTML headings <p> Defines a paragraph <i> Italic <b> Bold <a> Anchor <ul>&<li> Unordered List & List Item <blockquote> Blockquote <hr> Horizontal Rule <img> Image <div> Division <a> ANCHOR tag creates <a href="http://www.fillster.com">link</a> to other internet location, or file. <abbr> ABBREVIATION tags indicate interpretation of the meaning to the browsers and search engines for such as kind of abbreviations as "Inc.", "etc.". <acronym> ACRONYM tags defines an acronym, like; <acronym title="World Wide Web">WWW</acronym>. <address> ADDRESS tags are used to identify the author's contact information for a section or a document. <applet> APPLET element tags are used to embed and invoke a Java application within an HTML page. <area> AREA tag defines a section of an image. <b> BOLD tag is specifying <b>bold section</b> within the text document. <base> BASE tag defines information regarding to the links on the page. <basefont> BASEFONT tags defines changes of all text appearance on the web page. <bdo> BDO tag is specifying the direction of text display by overwriting the default value from Left to Right. <bdodir="rtl">Right to Left</bdo> <bgsound> BGSOUND tag is defining a background sound for a webpage. <html> <head> <bgsoundsrc="JingleBells.wav" loop="3"> </head> <body> </body> </html>
1st Column 2nd Column
DD tag defines a definition description.
NASA National Aeronautics and Space Administration MBA Master of Business Administration
DFN tags emphasize definition, for example; PC: Personal Computer. DEL tag indicates DIR tags define directory lists.
First Second Third
DL tag defines a definition list.
CSU California State University UN United Nations
DIV tag is a logical section of a web document.
Home Pets
Cats
Dogs
DT tags defines a definition term.
HTML HyperText Markup Language CSS Cascading Style Sheets
2.2 Basic CSS Tags:
Table No. 2.2: Text Properties Property Description Values color Sets the color of a text RGB, hex, keyword line-height Sets the distance between lines normal, number, length, % letter-spacing Increase or decrease the space between characters
normal, length text-align Aligns the text in an element left, right, center, justify text-decoration Adds decoration to text none, underline, overline, line- through text-indent Indents the first line of text in an element length, % text-transform Controls the letters in an element none, capitalize, uppercase, lowercase
Table No. 2.3: List Properties Property Description Values list-style Sets all the properties for a list in one declaration
list-style-type, list-style-position, list-style- image,inherit list-style- image
Specifies an image as the list-item marker
URL, none, inherit list-style- position
Specifies where to place the list- item marker
inside, outside, inherit list-style-type Specifies the type of list-item marker
none, disc, circle, square, decimal, decimal- leading-zero, armenian, georgian, lower-alpha, upper- alpha, lower-greek, lower-latin, upper-latin, lower-roman, upper-roman, inherit
border-width Sets the width of the four borders
thin, medium, thick, length, inherit
Table No. 2.5: Font Properties Property Description Values font Sets all the font properties in one declaration
font-style, font-variant, font-weight, font-size/line- height, font-family, caption, icon, menu, message- box, small-caption, status-bar, inherit font-family Specifies the font family for text
family-name, generic-family, inherit font-size Specifies the font size of text xx-small, x-small, small, medium, large, x-large, xx-large, smaller, larger, length, %, inherit font-style Specifies the font style for text
normal, italic, oblique, inherit font-variant Specifies whether or not a text should be displayed in a small-caps font
normal, small-caps, inherit
font-weight Specifies the weight of a font
normal, bold, bolder, lighter, 100, 200, 300, 400, 500, 600, 700, 800, 900, inherit Careful, many of these are not supported!
2.3 PHP :
PHP started out as a small open source project that evolved as more and more people found out how useful it was. RasmusLerdorf unleashed the first version of PHP way back in 1994. ▲ PHP is a recursive acronym for "PHP: Hypertext Preprocessor". ▲ PHP is a server side scripting language that is embedded in HTML. It is used to manage dynamic content, databases, session tracking, even build entire e-commerce sites. ▲ It is integrated with a number of popular databases, including MySQL, PostgreSQL, Oracle, Sybase, Informix, and Microsoft SQL Server. ▲ PHP is pleasingly zippy in its execution, especially when compiled as an Apache module on the Unix side. The MySQL server, once started, executes even very complex queries with huge result sets in record-setting time. ▲ PHP supports a large number of major protocols such as POP3, IMAP, and LDAP. PHP4 added support for Java and distributed object architectures (COM and CORBA), making n-tier development a possibility for the first time.
▲ PHP is forgiving: PHP language tries to be as forgiving as possible. ▲ PHP Syntax is C-Like.
Common uses of PHP:
▲ PHP performs system functions, i.e. from files on a system it can create, open, read, write, and close them. ▲ PHP can handle forms, i.e. gather data from files, save data to a file, through email you can send data, return data to the user. ▲ You add, delete, modify elements within your database through PHP. ▲ Access cookies variables and set cookies. ▲ Using PHP, you can restrict users to access some pages of your website. ▲ It can encrypt data.
Characteristics of PHP :
Five important characteristics make PHP's practical nature possible –
▲ Simplicity ▲ Efficiency ▲ Security ▲ Flexibility ▲ Familiarity
Chapter 3
Software Requirement Specification
One of the most difficult tasks is that, the selection of the software, once system requirement is known is determining whether a software package fits the requirements. After initial selection further security is needed to determine the desirability of software compared with
This project consists of player details, which describes about player biodata such as age and nationality. It also consists of player stats which describes about players technical skills. It also consists of tables containing details such as player earnings, club information and preferred position of playing. It also provide a strong searching, updating, deleting and inserting operations with a user friendly web based UI.
The project also helps the users to keep track of the player details in a computerized way without any trouble. The project contains 7 stored proceduresand 3 triggers per table. Stored procedures are used in search engine. Every time the user searches through the database, a procedure is called and the results is collected and displayed for the user in a structured manner. It also has 3 trigger namely “Insert, Delete and Update” triggers assigned separately to each table. Whenever operations such as insert or delete or update is performed on any table, these triggers are automatically called, and the logs are captured into 3 separate tables, individually for each trigger. Hence use of triggers provides users to trace back all the latest as well as the oldest changes into any table at any point oftime. This project consists of player details, which describes about player biodata such as age and nationality. It also consists of player stats which describes about players technical skills. It also consists of tables containing details such as player earnings, club information and preferred position of playing. It also provide a strong searching, updating, deleting and inserting operations with a user friendly web based UI.
This project is a simple prototype of managing larger numbers of players across different nations with different skill sets and attributes. It helps to access players and thus aids in building a strong positional team. It also helps in monitoring player growth.
4.2 ER Diagram:
The Figure Shows the ER diagram of “FIFA Player Management System”.
Fig 4.1: ER Diagram
Chapter 5
Implementation
SOURCE CODE:-
Index Page : -
Home
FIFA PLAYER MANAGEMENT SYSTEM
Player Search.php :
Player Search Results
Home Search Update
Insert Database Procedures About
connect_error) { die("Connection failed: ". $conn->connect_error); } $choices = $_POST['choices-single-defaul']; $input_name = $_POST['input_search_keyword']; if ($choices == 'AGE' &&ctype_digit(strval($input_name))) { $sql = "SELECT player_name,age,nationality,overall_rating FROM personal_detailspd WHERE pd.age="$input_name""; ?>
NAME AGE OVERALL RATING NATIONALITY
OVERALL RATING NATIONALITY
query($sql); if ($result) { // output data of each row while($row = $result->fetch_assoc()) { echo ""; echo("". $row["player_name"]. "". $row["age"]. "". $row["overall_rating"]. "" .$row["nationality"]. ""); echo ""; } } } else if ($choices == 'OVERALL RATING' &&ctype_digit(strval($input_name))) { $sql = "SELECT * FROM personal_details WHERE overall_rating="$input_name""; ?>
NAME AGE OVERALL RATING NATIONALITY
query($sql); if ($result) { // output data of each row while($row = $result->fetch_assoc()) { echo ""; echo("". $row["player_name"]. "". $row["age"]. "". $row["overall_rating"]. "" .$row["nationality"]. ""); echo ""; } } } else if ($choices == 'PLAYER ID' &&ctype_digit(strval($input_name))) { $sql = "SELECT * FROM personal_details WHERE player_id="$input_name""; ?>
NAME AGE OVERALL RATING NATIONALITY
query($sql); if ($result) { // output data of each row while($row = $result->fetch_assoc()) { echo ""; echo("". $row["player_name"]. "". $row["age"]. "". $row["overall_rating"]. "" .$row["nationality"]. ""); echo ""; } } } else if ($choices == 'TEAM' && !ctype_digit(strval($input_name))) { $sql = "SELECT pd.player_name,pd.overall_rating,pd.age,pd.nationality,od.club FROM personal_detailspd,other_details od WHERE od.club = "$input_name" AND pd.player_id = od.player_id ORDER BY pd.player_id";
NAME AGE OVERALL RATING NATIONALITY TEAM
query($sql); if ($result) { // output data of each row while($row = $result->fetch_assoc()) { echo ""; echo("". $row["player_name"]. "". $row["age"]. "". $row["overall_rating"]. "" .$row["nationality"]. "". $row["club"]. ""); echo ""; } }
