<?php require_once 'library/Cardio.php'; require_once 'library/DataManager.php'; $dm = new DataManager(); $cardio_id = $_POST['id']; $exercise = htmlspecialchars($_POST['exercise']); $time = htmlspecialchars($_POST['time']); $distance = htmlspecialchars($_POST['distance']); $level = htmlspecialchars($_POST['level']); $date = htmlspecialchars($_POST['date']); $cardio = new Cardio($exercise, $time, $distance, $level, $date); $cardio->set_cardio_id($cardio_id); $dm->update_cardio($cardio);
/** * Returns the full Cardio table * * @return Cardio[] An array of cardio objects * */ public function create_cardio_list() { $counter = 0; $query = "SELECT cardio_id, exercise, time, distance, level, date\n FROM cardio\n ORDER BY cardio_id DESC"; $result = MYSQL_query($query); while ($row = MYSQL_fetch_array($result, MYSQL_ASSOC)) { $cardio_id = $row['cardio_id']; $exercise = $row['exercise']; $time = $row['time']; $distance = $row['distance']; $level = $row['level']; $date = $row['date']; $cardio = new Cardio($exercise, $time, $distance, $level, $date); $cardio->set_cardio_id($cardio_id); $cardio_list[$counter] = $cardio; $counter++; } return $cardio_list; }
/** * Passes data from a Cardio object to the * database handler to update in storage * * @param Cardio $cardio */ public function update_cardio($cardio) { $mh = $this->create_MySQLHandler(); $mh->update_cardio($cardio->get_cardio_id(), $cardio->get_name(), $cardio->get_time(), $cardio->get_distance(), $cardio->get_level(), $cardio->get_date()); }