-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathStoreFitnessRecord.php
29 lines (23 loc) · 1.15 KB
/
StoreFitnessRecord.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
29
<?php
$servername = "seekt.asia";
$username = "seektasi_fitness";
$password = "fitness53300";
$dbname = "seektasi_bus";
$con = mysqli_connect($servername,$username,$password,$dbname);
$fitnessRecordID = $_POST["id"];
$userID = $_POST["user_id"];
$activitiesID = $_POST["activities_id"];
$recordDuration = $_POST["record_duration"];
$recordDistance = $_POST["record_distance"];
$recordCalories = $_POST["record_calories"];
$recordStep = $_POST["record_step"];
$HR = $_POST["average_heart_rate"];
$createdAt = $_POST["created_at"];
$updateAt = $_POST["created_at"];
$statement = mysqli_prepare($con,"INSERT INTO Fitness_Record (id,user_id,record_distance,record_duration,record_calories,record_step,average_heart_rate,created_at,updated_at,activity_id)
Values(?,?,?,?,?,?,?,?,?,?)");
mysqli_stmt_bind_param($statement,"siiididssi", $fitnessRecordID,$userID,$recordDistance,$recordDuration,$recordCalories,$recordStep,$HR,$createdAt,$updateAt,$fitnessActivity);
mysqli_stmt_execute($statement);
mysqli_stmt_close($statement);
mysqli_close($con);
?>