Fifa 18 project - Database and Web Technology Assignment Jss Acadamy of Technology PDF

Preview

Summary

Database and Web Technology Assignment Jss Acadamy of Technology...

Description

PLAYER MANAGEMENT SOFTWARE FOR GAME INDUSTRY, FIFA 18

Chapter 1

1.1

Introduction

Introduction to Player Management Software for FIFA 18 FIFA 18 is the web technology project with backend in MySQL and front-end code written using

HTML, JavaScript, CSS and PHP. Player management software 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 who are spread around the world. From personal details to football technicalities, FIFA 18 Player Management Software allows easy maintenance record of such skilled youth talent.

1.2 Introduction to Web Technology Web technologies is a general term referring to the many languages and multimedia packages that are used in conjunction with one another, to produce dynamic web sites such as this one. Each separate technology is fairly limited on its own, and tends to require the dual use of at least one other such technology. Therefore, we can conclude that all of the components that make up a site are interdependent on one another. HTML (Hyper Text Mark-up Language) is the glue that holds together every web site. Like building a house, you always build a strong foundation first. For any site, HTML is that foundation. HTML is an open source language (i.e. not owned by anyone), which is easy to learn, and requires no fancy (or expensive!) packages to start using it. All you need is something to type with, such as Windows Notepad, and a lot of time and patience. Although relatively limited by itself, it is the flexibility of HTML that allows web sites to grow in complexity. Like the foundation of your house, HTML is robust enough to support many kinds of languages integrated within your HTML pages. Dept. of CSE, JSSATE

Page 1

PLAYER MANAGEMENT SOFTWARE FOR GAME INDUSTRY, FIFA 18

DHTML (Dynamic HTML) is just as the name suggests, it adds dynamic, moving or changing content to your plain old HTML pages. Think of it as a more advanced version of HTML, although DTHML is in fact not a programming language in itself. DHTML is a broad term used to describe a group of applications, the main ones are described below: JavaScript: JavaScript is a 'scripting' language. A bit like a script in a feature film, it is used to decide 'what happens next'. This may be a sequence of screen events, where one event is initiated by the end of another, or it could be a programmed response to a user interacting with the page in some way, e.g. moving their mouse over a link. JavaScript is a complex and powerful language, and may be placed directly inside a HTML page, or in a separate JavaScript file. CSS and CSS-P: CSS (Cascading Style Sheets) is a relatively new language, designed to expand upon the limited style properties of HTML. Easy to learn and implement, CSS is an excellent way to control the style of your site, such as text styles like size, color and font. CSS may also be placed inside the HTML page or in separate files. The real advantage of having all of the style properties for your entire site in one single CSS file is that you may edit that single file to effect changes on the whole site, rather than having to go through each HTML file one at a time. For this reason, it is perhaps the most useful web technology and certainly one of my favourites.CSS-P (CSS-Positioning) is a sub-set of CSSs, and is concerned mainly with the layout of your HTML pages. It allows the web designer to place any element (text, graphic etc.) exactly on the screen where they want it, to the pixel. DOM: DOM (Document Object Model) allows the designer to access any element in a HTML page, such as an image, layer or table. Each element may be assigned a unique 'id' name to identify it. When combined with CSS and JavaScript, the DOM may be used to make changes to only "My Tag" and no other element, such as increasing text size or the position of "My Tag" on the screen. JavaScript can also be used to animated such changes to any identified element, such as gradually increasing the size of the text on screen. Each different browser has its own DOM, and this is often used to determine which browser the visitor is using. A particular action may be carried out if the person is using NS6, for example, and ignored if the person is using IE5.

1.3 PHP PHP is a server-side scripting language designed primarily for web development but also used as a general-purpose programming language. Originally created by Rasmus Redorf in 1994, the PHP reference Dept. of CSE, JSSATE

Page 2

PLAYER MANAGEMENT SOFTWARE FOR GAME INDUSTRY, FIFA 18 implementation is now produced by The PHP Development Team. PHP originally stood for Personal Home Page, but it now stands for the recursive acronym PHP: Hypertext Pre-processor. PHP code may be embedded into HTML or HTML5 markup, or it can be used in combination with various web template systems, web content management systems and web frameworks. PHP code is usually processed by a PHP interpreter implemented as a module in the web server or as a Common Gateway Interface (CGI) executable. The web server software combines the results of the interpreted and executed PHP code, which may be any type of data, including images, with the generated web page. PHP code may also be executed with a command line interface (CLI) and can be used to implement standalone graphical applications. The standard PHP interpreter, powered by the Zend engine, is a free software released under the PHP License. PHP has been widely ported and can be deployed on most web servers on almost every operating system. The PHP language evolved without a written formal specification or standard until 2014, leaving the canonical PHP interpreter as a de facto standard. Since 2014 work has gone on to create a formal PHP specification.

1.4 JavaScript JavaScript is a programming language that started off simply as a mechanism to add logic and interactivity to an otherwise static Netscape browser. In the years since its introduction, it has not only supplanted a variety of other competing languages and technologies to become the standard for browserbased programming, but it has also expanded beyond the client space to become a dominant language on the server side, as well.

The Hyper Text Transport Protocol, or HTTP, was designed to do exactly what the name implies, which is to transport HTML text across a network for viewing. But the problem with HTML is that it is completely static, providing no capabilities to implement logic. Basic features we currently take for granted, such as input validation, autocorrect, progress bars or causing a graphic to change during a mouse rollover, would all be impossible for a browser to perform without some type of scripting capability. As a result, when the web first rose to prominence, every vendor in that space provided some mechanism to make HTML web pages more interactive.

Microsoft promoted a competitor to JavaScript named VBScript, along with plug-in technologies, such as ActiveX Data Object (ADO). Sun Microsystems promoted Java applets that were cross-platform and Dept. of CSE, JSSATE

Page 3

PLAYER MANAGEMENT SOFTWARE FOR GAME INDUSTRY, FIFA 18 could be used in any browser. Many other technologies came and went as the internet matured. In the end, JavaScript won the battle for popularity, and it is the only client-side scripting technology supported by the Chrome, Firefox, Safari and Internet JavaScript is an interpreted language, as opposed to compiled languages, such as C++ and Java. This means that the code written in JavaScript does not go through an intermediary compilation stage in which the source code is transformed into machine language that is easy for a CPU to process. Instead, JavaScript is interpreted on the fly by the computer processing it. Because JavaScript code is not packaged in a CPUfriendly form, such as Java bytecode or a binary executable, program execution can be slower than a comparable program written in Scala or F#. However, modern JavaScript engines are highly optimized, and inefficiencies are rarely noticeable when using modern hardware.

1.5 INTRODUCTION TO XAMPP 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 deployments use the same components as XAMPP, it makes transitioning from a local test server to a live server extremely easy as well.

1.5.1 Components of XAMPP Apache HTTP Server: is free and open source web server software. Apache is developed and maintained by an open community of developers under the auspices of the Apache Software Foundation. The Apache HTTP Server is cross-platform. Maria DB: intends to maintain high compatibility with MySQL, ensuring a drop-in replacement capability with library binary equivalency and exact matching with MySQL APIs and commands. It includes the XtraDB storage engine for replacing InnoDB, as well as a new storage engine, Aria, that intends to be both a transactional and non-transactional engine perhaps even included in future versions of MySQL PHP: is a server-side scripting language designed primarily for web development but also used as a generalpurpose programming language. Originally created by Rasmus Lerdorf the PHP reference implementation is now produced by The PHP Development Team. PHP stands for Hypertext Preprocessor. PHP code may be embedded into HTML or HTML5 markup, or it can be used in combination with various web template Dept. of CSE, JSSATE

Page 4

PLAYER MANAGEMENT SOFTWARE FOR GAME INDUSTRY, FIFA 18 systems, web content management systems and web frameworks. PHP code is usually processed by a PHP interpreter implemented as a module in the web server

or

as

a Common

Gateway Interface

(CGI) executable. The web server software combines the results of the interpreted and executed PHP code, which may be any type of data, including images, with the generated web page. PHP code may also be executed with a command-line interface (CLI) and can be used to implement standalone graphical applications. 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 almost every operating system and platform, free of charge.

1.6 Graphics Pipeline Architecture The figure shown gives an abstract, high-level block diagram of how a web application processes data. In the diagram, commands enter from the left and proceed through what can be thought of as a processing pipeline. Some commands specify geometric objects to be drawn, and others control how the objects are handled during the various processing stages. Let’s now take a look at the separate stages

Figure 1.1: Pipeline Architecture of Web Applications

The concept of the web application pipeline is what really sets it apart from general CPUs, although the idea

of

a

pipeline

is

the

same

as

that

used

by

general

purpose

CPUs. The

graphics pipeline is built in stages. Every stage is specialized in precisely one element of the rendering Dept. of CSE, JSSATE

Page 5

PLAYER MANAGEMENT SOFTWARE FOR GAME INDUSTRY, FIFA 18 process. The main components of pipeline architecture include web browser, CDN, cloud storage and web app servers. As shown in the Figure 1, rather than having all commands proceeds immediately through the pipeline, you can choose to accumulate some of them in a display list for processing at a later time. In a single project scenario, separation of concerns is achieved through the use of folders. The default template includes separate folders for MVC pattern responsibilities of Models, Views, and Controllers, as well as additional folders for Data and Services. In this arrangement, presentation details should be limited as much as possible to the Views folder, and data access implementation details should be limited to classes kept in the Data folder.

1.7

Objectives of FIFA 18: To develop an application that can help people across the globe who want to choose a particular set of

players according to their needs but somehow get confused with all the options available.

We aim at providing a powerful and accurate mechanism with a strong database with an interactive user interface which will be containing data about the players and will sort out the most appropriate players according to the need of the consumer.

1.7.1 Motivation to take up Project Taking up the project under respective, supportive faculties shall give us an experience of objectifying the knowledge of programming, and work with databases. It shall lead to an extension of what we have learnt so far, building a concrete basis for the understanding of the subject.

1.8 Overview of the Project The front-end, or the user interface is coded in PHP, which gives the user a necessary platform to interact, and modify contents of the database (MySQL), which assures reliability.

1.9

Organization of the Report

Dept. of CSE, JSSATE

Page 6

PLAYER MANAGEMENT SOFTWARE FOR GAME INDUSTRY, FIFA 18 Chapter 1 provides the information about the web technologies used and objectives of our project. In Chapter 2, specifies the hardware and software requirements. Chapter 3, all the functions used in our program is described. Chapter 4 gives the idea of the project and its actual implementation. Chapter 5 discusses about the results and discussions regarding the project. Chapter 6 concludes by giving the direction for future enhancements.

Dept. of CSE, JSSATE

Page 7

Chapter 2

Requirements Specification A computerized way of handling information about property and users’ details is efficient, organized and time saving, compared to a manual way of doing so. This is done through a database driven web application whose requirements are mentioned in this section.

2.1

Hardware Requirement

The section of hardware configuration is an important task related to the software development insufficient random-access memory may affect adversely on the speed and efficiency of the entire system. The process should be powerful to handle the entire operations. The hard disk should have sufficient capacity to store the file and application.

Hardware Requirements Processor

: INTEL i3 or above

Ram

: Minimum RAM capacity

Peripherals

: Keyboard, Compatible mouse

Primary memory

: 512 MB RAM or more

Frequency

: 1 MHz or more

2.2 Software Requirement A major element in building a system is the section of compatible software since the software in the market is experiencing in geometric progression. Selected software should be acceptable by the firm and one user as well as it should be feasible for the system. This document gives a detailed description of the software requirement specification. The study of requirement specification is focused specially on the functioning of the system. It allows the developer or analyst to understand the system, function to be carried out the performance level to be obtained and corresponding interfaces to be established.

Software requirements Operating system

: WINDOWS 7 or above

Editor

: Sublime Text 2.0 or above

Programming language

: PHP, JAVASCRIPT

Web browser

: Internet Explorer or any web browser.

Scripting Language

: HTML/CSS

Server

: Apache (XAMPP)

Chapter 3

Function Descriptions

PHP MySQL functions gives to access the MySQL database servers. PHP works with MySQL version 4.1.13 or newer. The description of all the functions used in the program is given below: Table 2.1: List of Functions

Sl. No.

Function & Description

PHP

1

mysqli affected rows

4

It returns the number of affected rows in the previous SELECT, INSERT, UPDATE, REPLACE, or DELETE query. 2

mysqli client encoding

4.3.0

It is used to turn off or turn of auto-committing database modifications. 3

mysqli close It is used to close MySQLi connection

4

4

mysqli connect

4

It opens a connection to a MySQLi Server 5

mysqli create db

5

It is used to create MySQLi connection 6

mysqli change user

5

It is used to set the current database connection instead of specified data base connection.

7

mysqli character set name

5

It is returns default character set for the database connection 8

connect errno

5

It returns the error code from the last connection 9

data seek

4

It is used to move internal result pointer. 10

mysqli debug

5

It is used to performs debugging operations 11

dump debug info

5

It is used dumps debugging info into the log 12

mysqli error list

4

It returns a list of errors from the last connection 13

mysqli_error It returns the last error description for the most recent function

4

14

mysqli fetch all

4

It is used to fetch all result rows and returns the result set as an associative array 15

mysqli fetch array

5

It is used to fetch a result row as an associative array 16

mysqli fetch assoc

5.3

It is used to fetches a result row as an associative array. 17

mysqli fetch field direct

4

It is used to returns the next column in the result set as an object. 18

mysqli fetch fields

4

It is used to returns an array of objects 19

mysqli fetch lengths

4

It is used to returns the length of the fields in the result 20

mysqli fetch object

5

It returns an object 21

mysqli field count

5

It returns the number of columns for the most recent query. 22

mysqli field seek

5

This function sets the column cursor to the given column offset. 23

mysqli field tell

5