<?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;