<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "exercise";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$Date= $_POST['txtdate'];
$Duration=$_POST['txtduration'];
$Calorie=$_POST['txtcalorie'];
$Type=$_POST['type'];

if(isset($_POST["btnSubmit"]))
{
	$sql= "INSERT INTO record (date, duration, calories, exercise)
	VALUES('$Date' ,'$Duration' ,'$Calorie','$Type')";
	$result=mysqli_query($conn,$sql);
	if($result)
		{
			echo 'Data Saved!';
		}
	else
	{
		echo 'Date not Saved!';
	}
}

if(isset($_POST["btnDelete"]))
{
	$sql= "DELETE FROM record WHERE date='$Date'";

$result=mysqli_query($conn,$sql);
	if($result)
		{
			echo 'Data Deleted!';
		}
	else
	{
		echo 'Date not Deleted!';
	}
}

if(isset($_POST["btnSearch"]))
{
	$sql= "Select * FROM record WHERE date='$Date'";

$result=mysqli_query($conn,$sql);
	if($result)
		{
			echo 'Data Deleted!';
		}
	else
	{
		echo 'Date not Deleted!';
	}
}
?>