1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
class breveManager {
private $_db;
public function __construct($db) {
$this->setDb($db);
}
public function setDb(PDO $dbh) {
$this->_db = $dbh;
}
public function addBreve(Breve $breve) {
$sql = 'INSERT INTO breve(texte, dt_creation) VALUES(:texte, :dt_creation)';
$stmnt = $this->_db->prepare($sql);
$stmnt->bindParam(':texte', htmlspecialchars($breve->getText()));
$stmnt->bindParam(':dt_creation', $breve->getDt_creation());
$stmnt->execute();
}
public function updateBreve(Breve $breve) {
$sql = 'UPDATE breve SET texte = :texte, dt_creation = :dt_creation WHERE id = :id';
$stmnt = $this->_db->prepare($sql);
$stmnt->bindParam(':id', $breve->getId());
$stmnt->bindParam(':texte', $breve->getText());
$stmnt->bindParam(':dt_creation', $breve->getDt_creation());
$stmnt->execute();
} |
