<?php
//Connect to the database
include '../includes/connect.php';
//Remove any existing workout table
$dropTables = "DROP TABLE IF EXISTS tblWorkouts;";
$result = mysqli_query($connection, $dropTables);
//Set up a table of Workouts
$createTable = "CREATE TABLE tblWorkouts\n (\n workID INT(3) NOT NULL AUTO_INCREMENT,\n title VARCHAR(40) NOT NULL,\n date INT(10) NOT NULL,\n\n PRIMARY KEY(workID)\n )";
//Create the workouts table
$result = mysqli_query($connection, $createTable) or die("Couldn't create table" . mysqli_error());
//add a workout to tblWorkouts
function addWorkout($title, $date, $connection)
{
$insertWorkout = "Insert into tblWorkouts(title, date)\n VALUES ('{$title}','{$date}')";
$result = mysqli_query($connection, $insertWorkout);
}
addWorkout('gym', '2014-10-09');
addWorkout('walk', '2014-10-19');
addWorkout('taekwondo', '2014-10-20');
addWorkout('workout', '2014-10-21');
addWorkout('yoga', '2014-10-22');
addWorkout('run', '2014-10-22');
</head>
<?php
include 'config.php';
include 'tools.php';
$action = $_REQUEST['action'];
if (isset($action)) {
if (!empty($action)) {
if (!strcmp($action, "addWorkout")) {
$datetime = $_REQUEST['waDate'];
$comment = $_REQUEST['waComment'];
$maxspeed = $_REQUEST['waMaxSpeed'];
$averagespeed = $_REQUEST['waAvgSpeed'];
$duration = $_REQUEST['waDuration'];
$distance = $_REQUEST['waDistance'];
addWorkout();
}
}
}
?>
<body>
<div data-role="page">
<div data-role="header">
<h1>JuMiCycling Mobile</h1>
</div><!-- /header -->
<div data-role="content">
<a href="mobAddWorkout.php" data-role="button" data-theme="b" data-icon="star" data-rel="dialog">Add Workout</a>
