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