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 "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";
} else {