public function createHistorique($historique) {
$query = $this -> pdo -> prepare(
- 'INSERT INTO historiques (installation, alertes) VALUES (NOW(), :alertes)'
+ 'INSERT INTO historiques (installation, alertes, versions) VALUES (NOW(), :alertes, :versions)'
);
$query -> bindValue(':alertes', implode("|", $historique -> getAlertes()));
+ $query -> bindValue(':versions', implode("|", $historique -> getVersions()));
$query -> execute();
$query -> closeCursor();
}
public function updateHistorique($historique) {
$query = $this -> pdo -> prepare(
- 'UPDATE historiques SET installation = :installation, alertes = :alertes WHERE id = :id'
+ 'UPDATE historiques SET
+ installation = :installation,
+ alertes = :alertes,
+ versions = :versions
+ WHERE id = :id'
);
$query -> bindValue(':id', $historique -> getId());
$query -> bindValue(':installation', $historique -> getInstallation());
$query -> bindValue(':alertes', implode("|", $historique -> getAlertes()));
+ $query -> bindValue(':versions', implode("|", $historique -> getVersions()));
$query -> execute();
$query -> closeCursor();
}
$query -> execute();
$result = $query -> fetch(PDO::FETCH_ASSOC);
- $historique = new Historique($result['id'], $result['installation'], explode("|", $result['alertes']));
+ $historique = new Historique($result['id'], $result['installation'], explode("|", $result['alertes']), explode("|", $result['versions']));
$query->closeCursor();
$query -> execute();
$result = $query -> fetch(PDO::FETCH_ASSOC);
- $historique = new Historique($result['id'], $result['installation'], explode("|", $result['alertes']));
+ $historique = new Historique($result['id'], $result['installation'], explode("|", $result['alertes']), explode("|", $result['versions']));
$query->closeCursor();
$results = $query -> fetchAll(PDO::FETCH_ASSOC);
$historiques = array();
foreach ($results as $result) {
- $historiques[] = new Historique($result['id'], $result['installation'], explode("|", $result['alertes']));
+ $historiques[] = new Historique($result['id'], $result['installation'], explode("|", $result['alertes']), explode("|", $result['versions']));
}
$query->closeCursor();