<?php
require_once "NewsSourcePDO.php";
require_once "NewsSource.php";
if (isset($_POST['submit'])) {
$newssourcename = $_POST["newssourcename"];
// echo $username . "<br>\n";
$newssourcelink = $_POST["newssourcelink"];
//echo $password ."<br>\n";
$newssourcelinktype = $_POST["newssourcelinktype"];
if ($newssourcename != '' && $newssourcelink != '' && $newssourcelinktype != '') {
$newsSourcePDO = new NewsSourcePDO();
$newsSource = new NewsSource();
$newsSource->setNewsSourceName($newssourcename);
$newsSource->setNewsSourceLink($newssourcelink);
$newsSource->setNewsSourceLinkType($newssourcelinktype);
$newsSourcePDO->insertNewsSource($newsSource);
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 - Insert NewsSource</title>";
echo "</head>";
echo "<body>";
include "menu.php";
echo "Created a NewsSource </br>";
echo "<a href='index.php'> Back to Home</a>";
echo "</body>";
echo "</html";
} else {
echo "Please fill all of the fields" . "<br>\n";
public function getNewsSources()
{
$connection = parent::connect();
$selectSQL = "SELECT * FROM NEWSSOURCE";
$rows = $connection->query($selectSQL);
$newssources = array();
foreach ($rows as $row) {
$newsSource = new NewsSource();
$newsSource->setNewsSourceId($row[0]);
$newsSource->setNewsSourceName($row[1]);
$newsSource->setNewsSourceLink($row[2]);
$newsSource->setNewsSourceLinkType($row[3]);
$newssources[] = $newsSource;
}
parent::disconnect($connection);
return $newssources;
}