/** * 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; }
<?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);