$updatedOption->LastName = $_POST['lastname']; $updatedOption->Gender = $_POST['gender']; $updatedOption->Email = $_POST['email']; $updatedOption->Address = $_POST['address']; $updatedOption->Suburb_Id = $_POST['suburb']; $updatedOption->Rating = $_POST['rating']; if ($updatedOption->update() == true) { header("location:guests.php"); } else { echo "<script>alert('There was an error updating this item');window.location = 'guests.php' </script>"; } } if (isset($_POST['delete'])) { $updatedOption = new Guest($db); $updatedOption->Id = $_POST['id']; if ($updatedOption->delete() == true) { header("location:guests.php"); } else { echo "<script>alert('There was an error deleting this item');window.location = 'guests.php' </script>"; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title></title>
public static function delete_all() { global $g_pdo; $request = <<<EOF SELECT id_guest FROM event_guest WHERE id_event = :id EOF; debug($request); $pst = $g_pdo->prepare($request); $array = array(":id" => $_SESSION["event_id"]); debug("array=" . sprint_r($array)); $pst->execute($array); while (($record = $pst->fetch()) != null) { $guest = new Guest(); $guest->id = $record["id_guest"]; $guest->delete(); } }