--- /dev/null
+<?php
+
+ require_once('protected/required.php');
+
+ class PdoTemplateManager extends AbstractPdoManager implements TemplateManager {
+
+ public function createTemplate($template) {
+
+ $query = $this -> pdo -> prepare(
+ 'INSERT INTO templates (
+ valeur1,
+ valeur2,
+ valeur3,
+ valeur4,
+ valeur5
+ ) VALUES (
+ :valeur1,
+ :valeur2,
+ :valeur3,
+ :valeur4,
+ :valeur5
+ );'
+ );
+ $query -> bindValue(':valeur1', $template -> getValeur1());
+ $query -> bindValue(':valeur2', $template -> getValeur2());
+ $query -> bindValue(':valeur3', $template -> getValeur3());
+ $query -> bindValue(':valeur4', $template -> getValeur4());
+ $query -> bindValue(':valeur5', $template -> getValeur5());
+ $query -> execute();
+ }
+
+ public function updateTemplate($template) {
+
+ $query = $this -> pdo -> prepare(
+ 'UPDATE templates
+ SET valeur1 = :valeur1,
+ valeur2 = :valeur2,
+ valeur3 = :valeur3,
+ valeur4 = :valeur4,
+ valeur5 = :valeur5
+ WHERE id = :id'
+ );
+ $query -> bindValue(':id', $template -> getId());
+ $query -> bindValue(':valeur1', $template -> getValeur1());
+ $query -> bindValue(':valeur2', $template -> getValeur2());
+ $query -> bindValue(':valeur3', $template -> getValeur3());
+ $query -> bindValue(':valeur4', $template -> getValeur4());
+ $query -> bindValue(':valeur5', $template -> getValeur5());
+ $query -> execute();
+ }
+
+ public function getTemplate($id) {
+
+ $query = $this -> pdo -> prepare('SELECT * FROM templates WHERE id = :id');
+ $query -> bindValue(':id', $id);
+ $query -> execute();
+
+ $result = $query -> fetch(PDO::FETCH_ASSOC);
+ $template = new Template($result['id'], $result['valeur1'], $result['valeur2'], $result['valeur3'], $result['valeur4'], $result['valeur5']);
+
+ $query->closeCursor();
+
+ return $template;
+ }
+
+ public function getTemplates() {
+
+ $query = $this -> pdo -> prepare('SELECT * FROM templates');
+ $query -> execute();
+
+ $results = $query -> fetchAll(PDO::FETCH_ASSOC);
+ $templates = array();
+ foreach ($results as $result) {
+ $templates[] = new Template($result['id'], $result['valeur1'], $result['valeur2'], $result['valeur3'], $result['valeur4'], $result['valeur5']);
+ }
+
+ $query->closeCursor();
+
+ return $templates;
+ }
+
+ public function removeTemplate($template) {
+
+ $query = $this -> pdo -> prepare('DELETE FROM templates WHERE id = :id');
+ $query -> bindValue('id', $template -> getId());
+ $query -> execute();
+ }
+
+ }
+
+?>