Gym and Fitness Management System Project – Source Code Download.
del_trainer.php
<?php
include 'conn.php';
$id = $_GET['id'];
$q = " DELETE FROM `trainer` WHERE id = $id ";
mysqli_query($con, $q);
header('location:trainer.php');
?>
del_user.php
<?php
include 'conn.php';
$id = $_GET['id'];
$q = " DELETE FROM `user` WHERE id = $id ";
mysqli_query($con, $q);
header('location:display_user.php');
?>
insert_eqipment.php
<?php
include 'conn.php';
if(isset($_POST['done']))
{
$name = $_POST['name'];
$model = $_POST['model'];
$info=$_POST['info'];
$price=$_POST['price'];
//$status=$_post['0'];
$q = " INSERT INTO `equipment`(name,model,info,price) VALUES ( '$name', '$model','$info','$price')";
$query = mysqli_query($con,$q);
header('location:equipment.php');
}
?>
insert_trainer.php
<?php
include 'conn.php';
if(isset($_POST['done']))
{
$name = $_POST['name'];
$email = $_POST['email'];
$phn=$_POST['phone'];
$cnic=$_POST['cnic'];
$age = $_POST['age'];
//$status=$_post['0'];
$q = " INSERT INTO `trainer`(name,email,phone,cnic,age) VALUES ( '$name', '$email','$phn','$cnic','$age')";
$query = mysqli_query($con,$q);
header('location:trainer.php');
}
?>
platinum_update.php
<?php
if(isset($_POST['done']))
{
$location = $_POST['mf'];
$phn=$_POST['msf'];
$email = $_POST['gaccess'];
$fb = $_POST['fc'];
$pt = $_POST['pt'];
$conn=new mysqli('localhost','root','','proj1') or die ("could not to the database");
if($conn->connect_error)
{
die("connection failed:".$conn->connect_error);
}
//$status=$_post['0'];
$sql= " UPDATE platinum SET month_fee='$location',membership_fee='$phn',access='$email',facilities='$fb',pt='$pt' WHERE id=1";
if ($conn->query($sql) === TRUE)
{
}
else
{
echo "Error updating record: " . $conn->error;
}
header('location:platinum_display.php');
}
?>
Download Full Code