public function getEvents() { $connection = parent::connect(); $selectSQL = "SELECT * FROM EVENT"; $rows = $connection->query($selectSQL); $events = array(); foreach ($rows as $row) { $event = new Event(); $event->setEventId($row[0]); $event->setEventType($row[1]); $event->setEventSourceName($row[2]); $event->setEventSourceLink($row[3]); $event->setEventSourceLinkType($row[4]); $events[] = $event; } parent::disconnect($connection); return $events; }
require_once "EventPDO.php"; require_once "Event.php"; if (isset($_POST['submit'])) { $eventid = $_POST["eventid"]; $eventtype = $_POST["eventtype"]; $eventsourcename = $_POST["eventsourcename"]; // echo $username . "<br>\n"; $eventsourcelink = $_POST["eventsourcelink"]; //echo $password ."<br>\n"; $eventsourcelinktype = $_POST["eventsourcelinktype"]; if ($eventtype != '' && $eventsourcename != '' && $eventsourcelink != '' && $eventsourcelinktype != '') { $eventPDO = new EventPDO(); $event = new Event(); $event->setEventId($eventid); $event->setEventType($eventtype); $event->setEventSourceName($eventsourcename); $event->setEventSourceLink($eventsourcelink); $event->setEventSourceLinkType($eventsourcelinktype); $eventPDO->updateEvent($event); echo "<html>"; echo "<head>"; echo "<meta http-equiv='Content-Type' content='text/html; charset=UTF-8' >"; echo "<link rel='stylesheet' type='text/css' href='menu.css'>"; echo "<title>News Portal - Edit Event Source</title>"; echo "</head>"; echo "<body>"; include "menu.php"; echo "Updated the Event Source </br>"; echo "<a href='Home.php'> Back to Home</a>"; echo "</body>"; echo "</html";