‘VISVESVARAYA TECHNOLOGICAL UNIVERSITY

“JNANA SANGAMA” BELAGAVI- 590018, KARNATAKA

DBMS MINI PROJECT REPORT

On

“ FITNESS TRACKING SYSTEM ”

Submitted in the partial fulfilment of the requirement for the award of degree of
BACHELOR OF ENGINEERING
IN
COMPUTER SCIENCE AND ENGINEERING
BY
CHARAN KUMAR S CHANDAN KUMAR YR
1RL21CS022 1RL21CS019
Under the Guidance of
Mr.Praveen S R Mr.J Rajesh Kumar
Assistant Professor Assistant Professor

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

R L JALAPPA INSTITUTE OF TECHNOLOGY

DODDABALLAPUR-561 203 (KARNATAKA) 2023-2024
(A Unit of Sri Devaraj Urs Educational Trust (Regd.))
 R L JALAPPA INSTITUTE OF TECHNOLOGY
DODDABALLAPUR -561203 (KARNATAKA)
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

This is to certify that the Project work entitled “Fitness Tracking System” is a bonafield work
carried out by Charan Kumar S(1RL21CS022), Chandan Kumar YR (1RL21CS019) in partial
fulfilment for the requirement of V semester, Bachelor of Engineering in Computer Science &
Engineering of VISVESVARAYA TECHNOLOGICAL UNIVERSITY, Belagavi, during the
year 2023-24. It is certified that all corrections/suggestions indicated for the internal assessment
have been incorporated in the report. This report has been approved as it satisfies the academic
requirements in respect of mini project work prescribed for said degree.

Signature of Guide Signature of HOD Signature of Principal

Signature of co-ordinator
Mr. J Rajesh Kumar Mr.Praveen S R Dr. Murali G Dr.P Vijay Karthik
Assistant Professor Assistant Professor Dept. of CS&E,RLJIT RLJIT
Dept. of CS&E, RLJIT Dept. of CS&E, RLJIT

Evaluators

Name Signature

1.

2.
 ACKNOWLEDGEMENT

With Great pride we would like to convey our gratitude and appreciation to our college “R. L.
Jalappa Institute of Technology” for giving us the required platform for the fulfilment of the
Mini project on **FITNESS TRACKING SYSTEM ** as per the V.T.U requirements, for the
Fifth semester Lab on the DBMS subject.

We express my sincere thanks to Dr.P Vijay Karthik, Principal of R. L. Jalappa Insitiute

of Technology, Dodaballapura for providing me with excellent infrastructure to complete the
Miniproject.

We express wholehearted gratitude to Dr. Murali G who is the respectable HOD of

Computer Science Department. We wish to acknowledge his help in making my task easy by
providing me with his valuable help and encouragement.

It is our pleasure to thank our guide Mr.J Rajesh Kumar Assistant Professor and
Mr.Praveen S R Assistant professor, Department of Computer Science and Engineering,
RLJIT for their guidance, encouragement and valuable suggestion from the beginning of the
Mini project work till the completion without which this Mini project work would not have been
accomplished. We are greatly indebted to them.

And last but not the least, we would be very pleased to express our heart full thanks to the
Teaching and Non-teaching staff of the Department of Computer Science and Engineering,
RLJIT for their motivation and support.

We also thank all those who extended their support and co-operation while bringing out this
Mini project.

CHARAN KUMAR S (1RL21CS022)

CHANDAN KUMAR YR (1RL21CS019)

 ABSTRACT

The Fitness Tracking System (FTS) is a comprehensive software solution designed to streamline
and automate the administrative tasks involved in running a fitness center. This system aims to
enhance operational efficiency, improve member experience, and facilitate better management of
resources. The FTS offers a range of features tailored to meet thespecific needs of owners, staff,
and members. These features include membership management, class scheduling, attendance
tracking, billing and invoicing, inventory management,and reporting functionalities. With the FTS,
owners can easily manage membership registrations, renewals, and cancellations, ensuring smooth
membership operations. Class scheduling functionalities enable efficient organization and
scheduling of various fitness classes and sessions, allowing members to book classes in advance.
Attendance tracking features enable staff to monitor member attendance and track their progress
over time. Billing and invoicingfunctionalities automate the billing process, generating invoices
and managing payments seamlessly. Inventory management capabilities help in tracking and
managing equipment and supplies effectively. Moreover, the FTS provides comprehensive
reporting tools, allowing owners to gain insights into various aspects of their business, such as
membership trends, revenue generation, class attendance, and inventory usage. These insights
enable data-driven decision- making and help in optimizing business operations.Overall, the
Management System offersa user-friendly interface, scalability, and robust functionality, making
it an indispensable tool for owners and managers seeking to efficiently manage their operations
and deliver exceptionalservice to their member
CHAPTER TABLE OF CONTENTS PAGE NO

NO

1 INTRODUCTION FITNESS TRACKING 1

SYSTEM

1.1 Introduction 1

1.2 Problem Statement 1-2

1.3 Objectives 2

2 DESIGN AND ANALYSIS 3

2.1 How Fitness tracking system works 3

2.2 Benefits of Fitness tracking system 3

2.3 E-R Diagram 4

2.4 Schema Diagram 5

3 SYSTEM REQUIREMENTS 6

3.1 Hardware Requirements 6

3.2 6
Software Requirements

3.3 Tool used 6

3.4 6
Other Requirements

4 IMPLEMENTATION 7

4.1 Back End: MySQL 7

4.2 10-12
Code For login page
4.3 12
Code for logout page

4.4 12-13
Code For Count Equipment

4.5 13
Code for staff count
4.6 Code for count trainer 13-14

4.7 Code for session part 14

4.8 Code for payment 14-20

5 SYSTEM TESTING 21

5.1 login page 21

5.2 Count Equipment 22

5.3 Trainer list 22

5.4 Home Page 23

5.5 Payment 24

6 CONCLUSION 25

7 REFERANCES 26
 LIST OF FIGURES

SL.NO NAME PAGE NO

1 ER-DIAGRAM 4
2 SCHEMA DIAGRAM 5
3 LOGIN PAGE 21
4 COUNT EQUIPMENT 22
5 TRAINER LIST 22
6 HOME PAGE 23
7 PAYMENT 24
Fitness Tracking System

CHAPTER 1

INTRODUCTION TO FITNESS TRACKING SYSTEM

1.1 INTRODUCTION
Our Fitness tracking Software is a gym and health club membership management system.
You can keep records on your members, their memberships, and have quick and easy
communication between you and your members.Fitness tracking system also includes a booking
system, point of sale, banking, accounting, concessions and has a range of reports that help in the
management of your fitness club. Our Fitness tracking system Software is a complete fitness and
recreation facility system program which looks after all of your members, memberships and
activities. It is designed for recreation centres, and health clubs. Our fitness tracking system
Software provides lots of functions such data entry of customer, keeping records of all the things
about customer’s fees, plan, and physical fitness which help to provide good quality of services to
customer from managers.

In this proposed system also provide the total information about machinery and data of coaches is
also stored in it. Services provided by fitness center are also handled by this system. This system
structure is become very simple to understand because of Data Flow Diagram provided by us.
Context level Diagram and Some chart are also available in this case study. The demo of using the
software such as customer detail form, data base of software is also provided by us. This project is
designed to facilitate a fitness centre to automate its operations of keeping records and store them
in form of a large and user-friendly database further facilitating easy access to the personnel.
Fitness trascking system also includes a booking system, point of sale, banking, accounting,
concessions and has a range of reports that help in the management of your club.

Our Fitness tracking system Software is a complete fitness center and recreation facility system
program which looks after all of your members, memberships and activities. A Fitness tracking
system is basically software that is designed to seamlessly integrate all aspects of your business,
allowing you to more easily and efficiently run your facility. Businesses the functionality needed
to manage all aspects of their business and efficiently operate their studio. software can also be
referred to as clue

Dept.CSE,RLJIT 1 2023-24
Fitness Tracking System

management software, fitness software. Regardless of the nomenclature, these platforms all
share similar feature sets and are used for the same purposes. Fitness tracking system software
helps fitness owners and operators manage their class and trainer scheduling, keep track of their
members, communicate with clients, and process payments.

1.1 Problem Statement

The Fitness tracking system is a web-based project which is used by manager and customers.
They use this software to save records of customers like related to their fitness, starting period,
diet, fees, their personal details because of this work of manager get easy and time saving.
Fitness tracking systems provide fitness businesses the functionality to manage schedules,
memberships, and facilities. The capabilities of systems include storing member information in a
database, managing financial records, scheduling classes, and reserving facilities

1.2 Objectives

• The main objective of the project is to develop software that facilitates the data storage,
data maintenance and its retrieval for the fitness club in an igneous way.
• To store the record of the customers, the staff that has the privileges to access, modify
and delete any record and finally the service, fitness club provides to its customers.
• Also, only the staff has the privilege to access any database and make the required
changes, if necessary.
• To develop easy-to-use software which handles the customer-staff relationship in
an effective manner.
• To develop a user-friendly system that requires minimal user training. Most of features
and function are similar to those on any windows platform.
• To simplify the entire member management process.
• To easily schedule classes and manage all bookings and any other events you’re hosting.
• To involve a ton of administrative tasks like contracts, invoices, billing, membership
cancellations, and payments.
• To engage members and increase retention by automating communication and
interacting with members regularly, it increases the overall customer experience.

Dept of CS&E,RLJIT 2 2023-24

Fitness Tracking System

CHAPTER 2
DESIGN AND ANALYSIS

2.1 How Fitness tracking system work

A Fitness system typically includes features like member registration, scheduling of classes,
equipment management, staff management, billing and payments, and sometimes even
integrated fitness tracking. It works by collecting and organizing data related to members, staff,
classes, and equipment, allowing administrators to efficiently manage operations and provide
better services to members. This system often includes a software platform accessible toboth
staff and members, facilitating communication and interaction between them.

2.2 Benefits of fitness tracking system

• Efficient Operations: Streamlines administrative tasks such as member registration, class

scheduling, and staff management, leading to smoother operations.
• Improved Member Experience: Enables easier access to class schedules, equipment
availability, and membership information, enhancing the overall experience for members.
• Enhanced Communication: Facilitates communication between gym staff and members,
allowing for updates, reminders, and announcements to be easily disseminated.
• Better Resource Management:Helps in optimizing the usage of resources such equipment
and staff, ensuring that they are efficiently utilized.
• Automated Billing and Payments: Simplifies the billing process for both the gym and its
members, reducing errors and delays in payment processing

Dept of CS&E,RLJIT 3 2023-24

Fitness Tracking System

2.3 E-R DIAGRAM

Fig2.3 E R Diagram

Dept of CS&E,RLJIT 4 2023-24

Fitness Tracking System

2.4 Schema Diagram

Fig2.4 Schema Diagram

Dept of CS&E,RLJIT 5 2023-24

Fitness Tracking System

CHAPTER 3

SYSTEM REQUIREMENTS

3.1 Hardware Requirements

CLIENT SIDE

➢ RAM: 512 MB
➢ Hard Disk: 10 GB
➢ Processor: 1.0 GHz

SERVER SIDE

➢ RAM: 1GB
➢ Hard Disk: 20 GB
➢ Processor: 2.0 GHz

3.2 Software Requirements

CLIENT SIDE:

➢ Web Browser: Google Chrome or any compatible browser.

➢ Operating System: Windows or any equivalent OS.

SERVER SIDE

➢ Web Server: APACHE

➢ Server side Language: PHP5.6 or above version
➢ Database Server: MYSQL
➢ Web Browser: Google Chrome or any compatible browser
➢ Operating System: Windows or any equivalent OS

3.3 Tool used: Xampp

3.4 Other Requirements

• PHP
• MySQL
• APACHE

Dept of CS&E,RLJIT 6 2023-24

Fitness Tracking System

CHAPTER 4
IMPLEMENTATION

4.1 Back End: MySQL

A Back-End Data base is a data base that is accessed by users indirectly through an internal application
rather than by application programming stored with in the Data base itself by low level manipulation
of the data.

SQL QUERIES

Table structure for table ‘Admin’

CREATE TABLE `admin` (

`user_id` int(11) NOT NULL,
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Table structure for table ‘Announcements’

CREATE TABLE `announcements` (

`id` int(11) NOT NULL,
`message` varchar(100) NOT NULL,
`date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Table structure for table `attendance`

CREATE TABLE `attendance` (

`id` int(11) NOT NULL,
`user_id` varchar(100) NOT NULL,
`curr_date` text NOT NULL,
`curr_time` text NOT NULL,
`present` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Dept of CS&E,RLJIT 7 2023-24

 Fitness Tracking System

Table structure for table `equipment`

CREATE TABLE `equipment` (

`id` int(11) NOT NULL,
`name` varchar(30) NOT NULL,
`amount` int(100) NOT NULL,
`quantity` int(100) NOT NULL,

`vendor` varchar(50) NOT NULL,

`description` varchar(50) NOT NULL,
`address` varchar(20) NOT NULL,
`contact` varchar(10) NOT NULL,
`date` date NOT NULL)
ENGINE=InnoDB DEFAULT CHARSET=latin1;

Table structure for table `members`

CREATE TABLE `members` (

`user_id` int(11) NOT NULL,
`fullname` varchar(20) NOT NULL,
`username` varchar(20) NOT NULL,
`password` varchar(100) NOT NULL,
`gender` varchar(20) NOT NULL,
`dor` date NOT NULL,
`services` varchar(50) NOT NULL,
`amount` int(100) NOT NULL,
`paid_date` date NOT NULL,
`p_year` int(11) NOT NULL,
`plan` varchar(100) NOT NULL,
`address` varchar(20) NOT NULL,
`contact` varchar(10) NOT NULL,
`status` varchar(20) NOT NULL DEFAULT 'Active',
`attendance_count` int(100) NOT NULL,
`ini_weight` int(100) NOT NULL DEFAULT '0',
`curr_weight` int(100) NOT NULL DEFAULT '0',
`ini_bodytype` varchar(50) NOT NULL,
`curr_bodytype` varchar(50) NOT NULL,
`progress_date` date NOT NULL,
`reminder` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Table structure for table `rates`

CREATE TABLE `rates` (

`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
Dept of CS&E,RLJIT 8 2023-24
 Fitness Tracking System

`charge` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Table structure for table `reminder`

CREATE TABLE `reminder` (

`id` int(50) NOT NULL,

`name` varchar(50) NOT NULL,
`message` text NOT NULL,
`status` text NOT NULL,
`date` datetime NOT NULL,
`user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Table structure for table `staffs`

CREATE TABLE `staffs` (

`user_id` int(11) NOT NULL,
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`fullname` varchar(50) NOT NULL,
`address` varchar(20) NOT NULL,
`designation` varchar(20) NOT NULL,
`gender` varchar(10) NOT NULL,
`contact` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Table structure for table `todo`

CREATE TABLE `todo` (

`id` int(11) NOT NULL,
`task_status` varchar(50) NOT NULL,
`task_desc` varchar(30) NOT NULL,
`user_id` int(7) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Dept of CS&E,RLJIT 9 2023-24

Fitness Tracking System

4.2 CODE FOR LOGIN PAGE

<?php session_start(); include('dbcon.php'); ?>

<!DOCTYPE html>
<html lang="en">
<head>
<title>Gym System Admin</title><meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<link rel="stylesheet" href="css/bootstrap.min.css" />
<link rel="stylesheet" href="css/bootstrap-responsive.min.css" />
<link rel="stylesheet" href="css/matrix-style.css" />
<link rel="stylesheet" href="css/matrix-login.css" />
<link href="font-awesome/css/fontawesome.css" rel="stylesheet" />
<link href="font-awesome/css/all.css" rel="stylesheet" />
<link href='http://fonts.googleapis.com/css?family=Open+Sans:400,700,800'
rel='stylesheet' type='text/css'>
</head>

<body>

<div id="loginbox">
<form id="loginform" method="POST" class="form-vertical" action="#">
<div class="control-group normal_text"> <h3><img
src="img/icontest3.png" alt="Logo" /></h3></div>
<div class="control-group">
<div class="controls">
<div class="main_input_box">

Dept of CS&E,RLJIT 10 2023-24

Fitness Tracking System

<span class="add-on bg_lg"><i class="fas fa-user-

user"></i></span><input type="text" name="user" placeholder="Username"
required/>
</div>
</div>
</div>
<div class =”control-group">
<div class="controls">
<div class="main_input_box">
<span class="add-on bg_ly"><i class="fas fa-
lock"></i></span><input type="password" name="pass" placeholder="Password”
required />
</div>
</div>
</div>
< div class="form-actions center">
<button type="submit" class="btn btn-block btn-large btn-
ainfo" title="Log In" name="login" value="Admin Login">Admin Login</button>
</div>
</form>
<?php
if(isset($_POST[‘login’]))
{
$username = mysqli_real_escape_string($con,
$_POST[‘user’]);
$password = mysqli_real_escape_string($con,
$_POST[‘pass’]);

$password = md5($password);
$query = mysqli_query($con, "SELECT * FROM admin
WHERE password='$password' and username='$username'");
$row = mysqli_fetch_array($query);
$num_row = mysqli_num_rows($query);
if ($num_row > 0)
{
$_SESSION['user_id']=$row['user_id'];
header('location:admin/index.php');
}
Else
{

dismissible' role='alert'> echo "<div class='alert alert-danger alert-

Dept of CS&E,RLJIT 11 2023-24

Fitness Tracking System

Invalid Username and Password

<button type='button' class='close' data-
dismiss='alert' aria-label='Close'>
<span aria-hidden='true'>&times;</span>
</button>
</div>";
}
}
?>
<div class="pull-left">
<a href="customer/index.php"><h6>Customer Login</h6></a>
</div>

<div class="pull-right">
<a href="staff/index.php"><h6>Staff Login</h6></a>
</div>

</div>

<script src="js/jquery.min.js"></script>
<script src="js/matrix.login.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/matrix.js"></script>
</body>
</html>

4.3 CODE FOR LOGOUT PAGE

<?php session_start();
session_destroy();
header('location:index.php');
?>

4.4 CODE FOR COUNT EQUIPMENT

<?php

$servername="localhost";
$uname="root";
$pass="";
$db="gymnsb";

Dept of CS&E,RLJIT 12 2023-24

Fitness Tracking System

$conn=mysqli_connect($servername,$uname,$pass,$db);

if(!$conn){die("Connection Failed");

}$sql = "SELECT * FROM equipment";

$query = $conn->query($sql);

echo "$query->num_rows";

?>

4.5 CODE FOR STAFF COUNT

<?php

$servername="localhost";
$uname="root";
$pass="";
$db="gymnsb";
$conn=mysqli_connect($servername,$uname,$pass,$db); if(!$conn){
die("Connection Failed");
}

$sql = "SELECT * FROM staffs";

$query = $conn->query($sql);

echo "$query->num_rows";
?>

4.6 CODE FOR COUNT TRAINER

<?php

$servername="localhost";
$uname="root";

Dept of CS&E,RLJIT 13 2023-24

Fitness Tracking System

$pass="";
$db="gymnsb";
$conn=mysqli_connect($servername,$uname,$pass,$db); if(!$conn){
die("Connection Failed");
}

$sql = "SELECT * FROM staffs WHERE designation='Trainer'";

$query = $conn->query($sql);

echo "$query->num_rows";
?>

4.7 CODE FOR SESSION PART

<?php
//Start session
session_start();
//Check whether the session variable SESS_MEMBER_ID is present or not
if (!isset($_SESSION['user_id']) || (trim($_SESSION['user_id']) == '')) {
header("location: index.php");
exit();
}
$session_id=$_SESSION['user_id'];

?>

4.8 CODE FOR PAYMENT

<?php session_start();
//the isset function to check username is already loged in and stored on the
session
if(!isset($_SESSION['user_id'])){ header('location:../index.php');
}
?>

<!DOCTYPE html>
<html lang="en">

Dept of CS&E,RLJIT 14 2023-24

Fitness Tracking System

<head>
<title>Gym System</title>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<link rel="stylesheet" href="../css/bootstrap.min.css" />
<link rel="stylesheet" href="../css/bootstrap-responsive.min.css" />
<link rel="stylesheet" href="../css/fullcalendar.css" />
<link rel="stylesheet" href="../css/matrix-style.css" />
<link rel="stylesheet" href="../css/matrix-media.css" />
<link href="../font-awesome/css/font-awesome.css" rel="stylesheet" />
<link rel="stylesheet" href="../css/jquery.gritter.css" />
<link href='http://fonts.googleapis.com/css?family=Open+Sans:400,700,800' rel='stylesheet'
type='text/css'>
</head>
<body>

<div id="header">
<h1><a href="dashboard.html">Perfect fitness</a></h1>
</div>
<?php include '../includes/header.php'?>
<?php $page='payment'; include '../includes/sidebar.php'?>
<?php
include
'dbcon.php';$id=$_GET['id'];
$qry= "select * from members where user_id='$id'";
$result=mysqli_query($conn,$qry);
while($row=mysqli_fetch_array($result)){?>
<div id="content">
<div id="content-header">
<div id="breadcrumb"> <a href="index.php" title="Go to Home" class="tip -
bottom"><i class="icon-home"></i> Home</a> <a href="payment.php">Payments</a> <a
href="#" class="current">Invoice</a> </div>
<h1>Payment Form</h1>
</div>

<div class="container-fluid" style="margin-top:-38px;">

<div class="row-fluid">
<div class="span12">
<div class="widget-box">

Dept of CS&E,RLJIT 15 2023-24

Fitness Tracking System

<div class="widget-title"> <span class="icon"> <i class="icon-

money"></i> </span>
<h5>Payments</h5>
</div>
<div class="widget-content">
<div class="row-fluid">
<div class="span5">
<table class="">
<tbody>
<tr><td><img src="../img/gym-logo.png" alt="Gym Logo"
width=”175"></td>
</tr>
<tr>
<td><h4>Perfect GYM Club</h4></td>
</tr>
<tr>
<td>5021 Wetzel Lane, Williamsburg</td>
</tr>

<tr>
<td>Tel: 231-267-6011</td>
</tr>
<tr>
<td >Email: [email protected]</td>
</tr>
</tbody>
</table>
</div>
<div class="span7">
<table class="table table-bordered table-invoice">
<tbody>
<form action="userpay.php" method="POST">
<tr>
<tr>
<td class="width30">Member's Fullname:</td>
<input type="hidden" name="fullname" value="<?php echo
$row['fullname']; ?>">
<td class="width70"><strong><?php echo $row['fullname'];
?></strong></td>

Dept of CS&E,RLJIT 16 2023-24

Fitness Tracking System

</tr>
<tr>
<td>Service:</td>
<input type="hidden" name="services" value="<?php echo
$row['services']; ?>">
<td><strong><?php echo $row['services']; ?></strong></td>
</tr>
<tr>
<td>Amount Per Month:</td>
<td><input id="amount" type="number" name="amount" value='<?php
if($row['services'] == 'Fitness') { echo '55';} elseif ($row['services']
== 'Sauna') { echo '35';} else {echo '40';} ?>' /></td></tr>
<input type="hidden" name="paid_date"
value="<?phpecho$row['paid_date']; ?>">
<td class="width30">Plan:</td>
<td class="width70">
<div class="controls">
<select name="plan" required="required" id="select">
<option value="1" selected="selected" >One Month</option>
<option value="3">Three Month</option>
<option value="6">Six Month</option>
<option value="12">One Year</option>
<option value="0">None-Expired</option>
</select>
</div>

</td>

<tr>

</tr>
<td class="width30">Member's Status:</td>
<td class="width70">
<div class="controls">
<select name="status" required="required" id="select">
<option value="Active" selected="selected" >Active</option>
<option value="Expired">Expired</option>

Dept of CS&E,RLJIT 17 2023-24

Fitness Tracking System

</select>
</div>

</td>
</tr>
</tbody>

</table>
</div>

</div>

<div class="row-fluid">
<div class="span12">

<hr>
<div class="text-center">
<!-- user's ID is hidden here -->
<input type="hidden" name="id" value="<?php echo
$row['user_id'];?>">
<button class="btn btn-success btn-large" type="SUBMIT" href="">Make
Payment</button>
</div>

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

<?php
}
?>
</div>

</div>
</div>

Dept of CS&E,RLJIT 18 2023-24

Fitness Tracking System

</div>
</div>
</div>
<div class="row-fluid">
<div id="footer" class="span12">
<?php echo date("Y");?> &copy; Developed By Chandan Charan</a> </div></div>
<style>
#footer {
color: white;}
</style>
<script src="../js/excanvas.min.js"></script>
<script src="../js/jquery.min.js"></script>
<script src="../js/jquery.ui.custom.js"></script>
<script src="../js/bootstrap.min.js"></script>
<script src="../js/jquery.flot.min.js"></script>
<script src="../js/jquery.flot.resize.min.js"></script>
<script src="../js/jquery.peity.min.js"></script>
<script src="../js/fullcalendar.min.js"></script>
<script src="../js/matrix.js"></script>
<script src="../js/matrix.dashboard.js"></script>
<script src="../js/jquery.gritter.min.js"></script>
<script src="../js/matrix.interface.js"></script>
<script src="../js/matrix.chat.js"></script>
<script src="../js/jquery.validate.js"></script>
<script src="../js/matrix.form_validation.js"></script>
<script src="../js/jquery.wizard.js"></script>
<script src="../js/jquery.uniform.js"></script>
<script src="../js/select2.min.js"></script>
<script src="../js/matrix.popover.js"></script>
<script src="../js/jquery.dataTables.min.js"></script>
<script src="../js/matrix.tables.js"></script>
<script type="text/javascript">
function goPage (newURL)

Dept of CS&E,RLJIT 19 2023-24

Fitness Tracking System

if (newURL != "") {

if (newURL == "-" ) { resetMenu();

}
else {
document.location.href = newURL;
}
}
}
function resetMenu() { document.gomenu.selector.selectedIndex = 2;
}
</script>
</body>
</html>

Dept of CS&E,RLJIT 20 2023-24

 Fitness Tracking System

`CHAPTER 5
SYSTEM TESTING
5.1 login Page

FIG 5.1 Admin Login

➢ Administration enter his user name and password for login.

➢ customer enters his user name and password for login.

➢ Staff enters his user name and password for login.

➢ New customer give his completed personal details, address, phone,plans and servies
details for registration.

Dept of CS&E,RLJIT 21 2023-24

 Fitness Tracking System

5.2 COUNT EQUIPMENT

FIG 5.2 Count Equipment

➢ It contains of equipment list .
➢ Equipment details which ae in use for the customer.
➢ It contins of the price of the equipments.

5.3 TRAINER LIST

FIG 5.3 Trainer List

Dept of CS&E,RLJIT 22 2023-24
 Fitness Tracking System

5.4 HOME PAGE

FIG 5.4 Home Page

➢ In this page it consists of menus or options which are accessable by the user and admin.
➢ It contins of details consists of number of user,member,announcements.
➢ For admin it will have total Earnings and total expention for the admin.
➢ Attendance for the user to count the number of days after join.

Dept of CS&E,RLJIT 23 2023-24

 Fitness Tracking System

5.5 PAYMENT

Fig 5.5 Payment

➢ It contains of payments details for the new coustomer .

➢ It contains of customer name, service amount per month, plan and member status.
➢ By using this customer can make payments as per their plans.

Dept of CS&E,RLJIT 24 2023-24

Fitness Tracking System

6.CONCLUSION

The objective of this project was to build a program for maintaining the details of all the
members, employees and inventory. The system developed is able to meet all the basic
requirements. The management of the records (both members and employees) will be also
benefited by the proposed system, as it will automate the whole procedure, which will reduce the
workload. The security of the system is also one of the prime concerns. There is always a room
for improvement in any software, however efficient the system may be. The important thing is
that the system should be flexible enough for future modifications. The system has been factored
into different modules to make system adapt to the further changes. Every effort has been made
to cover all user requirements and make it user friendly. Goal achieved: The System is able
provide the interface to the owner so that he can replicate his desired data. User friendliness:
Though the most part of the system is supposed to act in the background, efforts have been made
to make the foreground interaction with user(owner) as smooth as possible. Also the integration
of the existing system with the project has been kept in mind throughout the deve

Dept of CS&E,RLJIT 25 2023-24

Fitness Tracking System

7.REFERANCES

1. https://www.w3schools.com/php/default.asp

2. https://www.sitepoint.com/php/

3. https://www.php.net/

4. https://www.mysql.com/

5. http://www.mysqltutorial.org

6. .https://www.apachefriends.org/download.html

Dept of CS&E,RLJIT 26 2023-24