Bryakotnin Nikolay Aleksandrovich

Irkutsk national research technical university, Russia

Design the server part and development the administrative part of the system "FitnessGid"

In recent years, the government has an increased focus on the nation's health and a healthy lifestyle. The idea of creating an application "FitnesGid" has arisen because of the lack of services, where all the information about the organizations engaged in sports nutrition, sports equipment, fitness training, etc. would be collected. The application is expected to develop a system with full information about the organizations connected with the sport, with opportunity to journalize training activity of sportsmen and drawing schedule of training activities.

Nowadays creating a web-based application is considered one of the most promising direction of activity for many companies engaged in high-tech digital and computer technology. Web-application’s logic is distributed between client and server, data storage is carried out mainly on the server, information exchange over the network.

The database has been developed for the assigned purpose. Roles of system users (actors) and their functions (precedents) in CASE-tool StarUML [1] were defined at the inception phase of development. In this case, the three actors work with the system - it's "Administrator", "Manager" and "User". The functions of the administrator is managing user accounts, database maintenance, also provides the function of generating and reviewing statistics by various criteria. Manager edits entered personal data organizations. The user views the information posted organizations, conducts personal training diary and sends the message. The resulting precedent’s diagram is shown in Figure 1.

In addition to the abovementioned diagram, also diagrams of classes, sequences, interface were developed.

In the next designing cycle logical and physical database model was built in ErWin program. Physical database model is presented in Figure 2

Fig. 1. Precedent’s diagram

Fig. 2. Physical database model

In accordance with any findings of database design was generated SQL script for the further implementation of the server.

In the capacity of a server on the local computer used OpenServer. OpenServer is a portable server platform and software environment for web developers [2].

PhpMyAdmin is a web application, open source, written in PHP and a web-based interface for managing the database management system. PhpMyAdmin allows the web browser to carry out the administration of the MySQL server (free relational database management system), run SQL commands and view the contents of tables and databases [3]. In PhpMyAdmin it was imported resulting database (Figure 3).

Fig.3. Database of PhpMyAdmin

Any Web-application needs to update information, hereat the interface of administrator has been created. By dint of this interface you can edit, add, or delete data. The part of the administrator is a part of the interface that allows users to view statistics on different criteria, view and edit data. Entrance to this block is not available to all users, because it is a secure application page from the user.

In "FitnesGid" system the access to the administrative part is available only to users with administrator status.

The interface has been implemented in accordance with the actions to be performed by its users (Figure 4).

Relational databases store data in tables. A table is a structure consisting of disordered plurality of horizontal rows, each comprising the same number of vertical columns. The intersection of the individual rows and columns called field, containing the information. A generator is a mechanism that creates a serial unique number that is automatically inserted into the database column when the operation is performed INSERT or UPDATE. A view is a virtual table is not physically stored in the database, which has similar features as a real table. The representation may comprise data from one or more tables or other kinds and is used for storing frequently used queries or a plurality of queries in the database [4].

The script contains three types of procedures: CREATE, DELETE and UPDATE.

In order to store the contents of the web-application and database used shared hosting that provides resources for hosting on a server data residing on the network. The server responds to client requests directly and fully while using only its own resources. Consequently server is a third-party network applications, and does not apply to third-party resources to carry out any part of the request [5], [6].

Fig.4. Сlient-server application interface

During the process of selecting items on the interface "Users" and "Reference" drop-down list to select an item. After selecting the proper item is displayed with a form of filters. By clicking the bitton "Find" displays a list that satisfies the specified parameters. The query result is shown in Figure 5.

Fig.5. Кesult display information from the base

The project provides information on companies engaged in sports clothing, sports nutrition, sports training, etc., news, events and other useful information. Users can subscribe to the interesting organization, to journalize their training activity and keep track of the required information.

Information about the application is available in the search systems.

We sincerely hope that created Web-application "FitnesGid" with applications for mobile phones, which are being developed in our team, contribute to the solution of choice of products and services for people who are interested in sports, and for organizations - advertise sports products or services narrowly focused audience.

References:

1. Agaltsov V.P. Computer Science and Engineering. M .: Raspredelennye i udalennye basy dannyh, 2011. 270 p.

2. Kuzin A.V. Computer Science and Engineering. M.:Akademya, 2010. 311 p.

3. MySQL и phpMyAdminImpor:enabling the server and access to its administration [electronic resource] // web server and the MySQL server: [site]. [2016]. URL: https://qnap.ru/kb/4608 (reference date 05/16/2016).

4. Dorofeev A.S. The manual on "Databases" discipline. Irkutsk .: Basy dannyh, 2008. 99 p.

5. Anatolyev A.G. Components of the network application. Client-server communication and server roles [Electronic resource] // Educational materials for students AIPSM department: [site]. [2007]. URL: http://www.4stud.info/networking/lecture5.html (reference date 05/16/2016).

6. Velikanov A.P. Designing architecture, implementation and organization of the development process by the example of his own project based on ZF [Electronic resource] // SlideShare: [site]. [2007]. URL: http://www.slideshare.net/zfconf/zfconf-2012-zf (reference date 05/19/2016).