function createNouvelle(Nouvelle $n, $RSS_id)
{
if ($this->readNouvellefromTitre($n->getTitre(), $RSS_id) == NULL) {
$safeId = $this->db->quote($RSS_id);
$safePubDate = $this->db->quote($n->getDate());
$safeTitre = $this->db->quote($n->getTitre());
$safeDescription = $this->db->quote($n->getDescription());
$safeLink = $this->db->quote($n->getUrl());
$safeImage = $this->db->quote($n->getImage());
$query = "INSERT INTO Nouvelle (date, titre, description, url, image, RSS_id) " . "VALUES ({$safePubDate}, {$safeTitre}, {$safeDescription}, {$safeLink}, {$safeImage}, {$safeId})";
try {
$result = $this->db->exec($query);
if ($result == 0) {
die("Error: nouvelle not inserted\n");
}
} catch (Exception $ex) {
die("PDO Error :" . $ex->getMessage());
}
}
$this->updateImageNouvelle($n, $RSS_id);
}
function createNouvelle(Nouvelle $n, $RSS_id)
{
$o = $this->readNouvellefromTitre($n->getTitre(), $RSS_id);
if ($o == NULL) {
$q = "INSERT INTO nouvelle (date, titre, description, url, image, RSS_id) VALUES (\"" . htmlspecialchars($n->getPubDate()) . "\", \"" . htmlspecialchars($n->getTitre()) . "\", \"" . htmlspecialchars($n->getDescription()) . "\", \"" . htmlspecialchars($n->getLink()) . "\", \"" . htmlspecialchars($n->getImage()) . "\", " . $RSS_id . ")";
try {
$r = $this->db->exec($q);
if ($r == 0) {
echo "createRSS error: no rss inserted\n";
}
return $this->readRSSfromURL($n->getLink());
} catch (PDOException $e) {
echo "PDO Error :" . $e->getMessage();
}
} else {
return $n;
}
}
