Exemple #1
0
 public function getSentiments()
 {
     $connection = parent::connect();
     $selectSQL = "SELECT * FROM SENTIMENT";
     $rows = $connection->query($selectSQL);
     $sentiments = array();
     foreach ($rows as $row) {
         $sentiment = new Sentiment();
         $sentiment->setSentimentId($row[0]);
         $sentiment->setSentimentSourceName($row[1]);
         $sentiment->setSentimentSourceLink($row[2]);
         $sentiment->setSentimentSourceLinkType($row[3]);
         $sentiments[] = $sentiment;
     }
     parent::disconnect($connection);
     return $sentiments;
 }
Exemple #2
0
<?php

require_once "SentimentPDO.php";
require_once "Sentiment.php";
if (isset($_POST['submit'])) {
    $sentimentid = $_POST["sentimentid"];
    $sentimentsourcename = $_POST["sentimentsourcename"];
    // echo $username . "<br>\n";
    $sentimentsourcelink = $_POST["sentimentsourcelink"];
    //echo $password ."<br>\n";
    $sentimentsourcelinktype = $_POST["sentimentsourcelinktype"];
    if ($sentimentsourcename != '' && $sentimentsourcelink != '' && $sentimentsourcelinktype != '') {
        $sentimentPDO = new SentimentPDO();
        $sentiment = new Sentiment();
        $sentiment->setSentimentId($sentimentid);
        $sentiment->setSentimentSourceName($sentimentsourcename);
        $sentiment->setSentimentSourceLink($sentimentsourcelink);
        $sentiment->setSentimentSourceLinkType($sentimentsourcelinktype);
        $sentimentPDO->updateSentiment($sentiment);
        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 - Update Sentiment Source</title>";
        echo "</head>";
        echo "<body>";
        include "menu.php";
        echo "Updated a Sentiment Source </br>";
        echo "<a href='Home.php'> Back to Home</a>";
        echo "</body>";
        echo "</html";