public function createAlerte($alerte) {
$query = $this -> pdo -> prepare(
- 'INSERT INTO alertes (creation, nature, message) VALUES (NOW(), :nature, :message);'
+ 'INSERT INTO alertes (creation, nature, message, version) VALUES (NOW(), :nature, :message, :version);'
);
$query -> bindValue(':nature', $alerte -> getNature());
$query -> bindValue(':message', $alerte -> getMessage());
+ $query -> bindValue(':version', $alerte -> getVersion());
$query -> execute();
}
'UPDATE alertes
SET creation = :creation,
nature = :nature,
- message = :message
+ message = :message,
+ version = :version
WHERE id = :id'
);
$query -> bindValue(':id', $alerte -> getId());
$query -> bindValue(':creation', $alerte -> getCreation());
$query -> bindValue(':nature', $alerte -> getNature());
$query -> bindValue(':message', $alerte -> getMessage());
+ $query -> bindValue(':version', $alerte -> getVersion());
$query -> execute();
}
$query -> execute();
$result = $query -> fetch(PDO::FETCH_ASSOC);
- $alerte = new Alerte($result['id'], $result['creation'], $result['nature'], $result['message']);
+ $alerte = new Alerte($result['id'], $result['creation'], $result['nature'], $result['message'], $result['version']);
$query->closeCursor();
$query -> execute();
$result = $query -> fetch(PDO::FETCH_ASSOC);
- $alerte = new Alerte($result['id'], $result['creation'], $result['nature'], $result['message']);
+ $alerte = new Alerte($result['id'], $result['creation'], $result['nature'], $result['message'], $result['version']);
$query->closeCursor();
$results = $query -> fetchAll(PDO::FETCH_ASSOC);
$alertes = array();
foreach ($results as $result) {
- $alertes[] = new Alerte($result['id'], $result['creation'], $result['nature'], $result['message']);
+ $alertes[] = new Alerte($result['id'], $result['creation'], $result['nature'], $result['message'], $result['version']);
}
$query->closeCursor();