<?php
include "Includes/header.php";
if (!isset($_SESSION["username"])) {
echo "<p>Please log in</p>";
exit;
}
?>
<script>
var exerciseCategoriesArray = <?php
echo getAllCategoriesDetails();
?>
;
</script>
<form role='form' id='addWorkoutForm' class='form-horizontal'>
<div id='workoutDateGroup' class='form-group'>
<label class='control-label col-sm-1 col-sm-offset-4' for='date'>Date:</label>
<div class='col-sm-3 col-sm-offset-0 col-xs-8 col-xs-offset-2'>
<input type='date' class='form-control' name='date' required>
</div>
</div>
<br><br>
<button type='button' id='addExercise' class='btn btn-default col-md-2 col-md-offset-4'>Add Exercise</button>
<button type='button' id='removeExercise' class='btn btn-default col-md-2'>Remove Exercise</button>
<br><br>
<button type='submit' class="btn btn-default center-block">Submit</button>
</form>
$stmt->execute();
$stmt->free_result();
} else {
if ($exercise['category'] == 'endurance') {
$meters = $round['distanceUnit'] == 'kilometers' ? $round['distance'] * 1000 : $round['distance'] * 1609.344;
$milliseconds = getMillisecondsFromTime($round['time']);
$stmt = $db->prepare("INSERT INTO tbl_workoutlog_category_endurance (ExerciseId, Meters, Milliseconds, Notes) VALUES (?,?,?,?)");
$stmt->bind_param('iiis', $exerciseId, $meters, $milliseconds, $round['notes']);
$stmt->execute();
$stmt->free_result();
} else {
$fields = "(ExerciseId, ";
$values = "(" . $exerciseId . ", ";
foreach ($round as $fieldName => $fieldData) {
$fields .= $fieldName . ", ";
$allCategoriesDetails = json_decode(getAllCategoriesDetails(), TRUE);
$type = $allCategoriesDetails[$exercise['category']][$fieldName];
if ($type == "varchar") {
$values .= "'" . $db->real_escape_string($fieldData) . "', ";
} else {
if ($type == "int") {
if ($fieldData == "") {
$fieldData = 0;
}
$values .= $db->real_escape_string($fieldData) . ", ";
}
}
}
$fields = substr($fields, 0, -2) . ")";
$values = substr($values, 0, -2) . ")";
$query = "INSERT INTO tbl_workoutlog_category_" . $db->real_escape_string($exercise['category']) . " " . $fields . " VALUES " . $values;
