-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathUpdateHealthProfile.php
28 lines (23 loc) · 1021 Bytes
/
UpdateHealthProfile.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
<?php
$servername = "localhost";
$username = "1044722";
$password = "yusuke6635";
$dbname = "1044722";
$con = mysqli_connect($servername, $username,$password,$dbname);
$healthprofileid = $_POST["healthprofileid"];
$userID = $_POST["userID"];
$weight= $_POST["weight"];
$BP = $_POST["BP"];
$RHR = $_POST["RHR"];
$ArmG = $_POST["ArmG"];
$ChestG = $_POST["ChestG"];
$CalfG = $_POST["CalfG"];
$ThighG = $_POST["ThighG"];
$Time = $_POST["Time"];
$Waist = $_POST["Waist"];
$HIP = $_POST["HIP"];
$statement = mysqli_prepare($con,"UPDATE Health_Profile Set Weight = '$weight' ,Blood_Pressure = '$BP' ,Resting_Heart_Rate = '$RHR' , Arm_Girth = '$ArmG' , Chest_Girth = ' $ChestG', Calf_Girth = '$CalfG' , Thigh_Girth = '$ThighG' , Waist = '$Waist', HIP = '$HIP' ,Record_DateTime = '$Time' WHERE Health_Profile_ID = '$healthprofileid' AND User_ID = '$userID' ");
mysqli_stmt_execute($statement);
mysqli_stmt_close($statement);
mysqli_close($con);
?>